{"id":8470,"date":"2022-02-16T22:07:48","date_gmt":"2022-02-16T22:07:48","guid":{"rendered":"http:\/\/3.26.62.22\/?p=8470"},"modified":"2022-02-16T22:07:49","modified_gmt":"2022-02-16T22:07:49","slug":"exporting-the-jobs-list-to-google-sheets","status":"publish","type":"post","link":"http:\/\/help.gjgardner.com\/nz\/2022\/02\/16\/exporting-the-jobs-list-to-google-sheets\/","title":{"rendered":"Exporting the jobs list to Google Sheets"},"content":{"rendered":"

In the February 2022 software release<\/a>, we introduce the ability to export the jobs list to Google Sheets. We’ve received a handful of reports from people who have been unable to successfully export. This is because an office role permission<\/a> is required to execute commands due to the potentially sensitive nature of some of this information. This article explains how to enable the required permission. <\/p>\n\n\n\n

Changing office role permissions is only possible for users with sufficient Setup Permissions to edit Office Roles & Permissions. <\/p>\n\n\n\n

1. Click on Setup on the left side menu<\/h3>\n\n\n\n

\"Click<\/p>\n\n\n\n

2. Click on Manager under Setup<\/h3>\n\n\n\n

\"Click<\/p>\n\n\n\n

3. Hover on the Office Role to edit<\/h3>\n\n\n\n

\"Hover<\/p>\n\n\n\n

4. Click the Permissions icon<\/h3>\n\n\n\n

\"Click<\/p>\n\n\n\n

5. Click the arrow to expand Job Admin and Jobs permissions<\/h3>\n\n\n\n

\"Click<\/p>\n\n\n\n

6. Select Execute under Jobs permissions<\/h3>\n\n\n\n

\"Select<\/p>\n\n\n\n

7. Click Process to save changes<\/h3>\n\n\n\n

\"Click<\/p>\n\n\n\n

Users with this Office Role will now be able to export the jobs list to Google Sheets as long as they have the ability to view the jobs list. Some columns are not visible without other permissions such as job profit margin which requires Job Financials Permissions or job costs that require Job Estimate permissions.<\/p>\n\n\n\n

We’re aware that when you try to export jobs without this permission that users experience a never-ending loading icon. In the March release, we’ll be adding an error message making it clear that the user does not have the necessary permissions to execute the action first. <\/p>","protected":false},"excerpt":{"rendered":"

In the February 2022 software release, we introduce the ability to export the jobs list to Google Sheets. We’ve received a handful of reports from people who have been unable to successfully export. This is because an office role permission is required to execute commands due to the potentially sensitive…<\/p>","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[122],"tags":[120,230],"class_list":["post-8470","post","type-post","status-publish","format-standard","hentry","category-job-admin","tag-google","tag-permissions"],"_links":{"self":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/posts\/8470"}],"collection":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/comments?post=8470"}],"version-history":[{"count":1,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/posts\/8470\/revisions"}],"predecessor-version":[{"id":8472,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/posts\/8470\/revisions\/8472"}],"wp:attachment":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/media?parent=8470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/categories?post=8470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/tags?post=8470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}