{"id":143,"date":"2020-12-12T01:57:15","date_gmt":"2020-12-12T05:57:15","guid":{"rendered":"http:\/\/wdp.g-integrator.com\/docs\/?p=143"},"modified":"2023-11-13T11:31:08","modified_gmt":"2023-11-13T15:31:08","slug":"tutorial-get-output-on-new-sheet-vs-replace-data-in-same-sheet-vs-append-to-existing-data","status":"publish","type":"post","link":"https:\/\/wdp.g-integrator.com\/docs\/2020\/12\/12\/tutorial-get-output-on-new-sheet-vs-replace-data-in-same-sheet-vs-append-to-existing-data\/","title":{"rendered":"Tutorial: Get Output on New Sheet vs Replace Data in Same Sheet vs Append to Existing Data"},"content":{"rendered":"\n<p>Changes the way new data appears relative to existing data.<\/p>\n\n\n\n<p>NOTE: The default setting is for the data to appear on a new sheet. Sheets can be switched between at the bottom of the window<br><\/p>\n\n\n\n<p><strong>TO REPLACE DATA ON CURRENT SHEET<\/strong>:<\/p>\n\n\n\n<p>1.  Follow standard process to get module records (<a href=\"http:\/\/wdp.g-integrator.com\/docs\/2020\/11\/28\/tutorial-get-module-records\/\">See tutorial for step by step instructions<\/a>). DO NOT PRESS EXECUTE<\/p>\n\n\n\n<p><strong>THE FOLLOWING STEPS MUST BE TAKEN BEFORE PRESSING EXECUTE<\/strong><\/p>\n\n\n\n<p>2. After selecting desired fields, Select option 2 &#8220;Change pull settings (optional)&#8221;<\/p>\n\n\n\n<p>3. De-select option &#8220;Create a new sheet&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"499\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/042.png\" alt=\"\" class=\"wp-image-146\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/042.png 774w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/042-300x193.png 300w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/042-768x495.png 768w\" sizes=\"(max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure>\n\n\n\n<p><strong>TO APPEND DATA TO CURRENT SHEET<\/strong>:<\/p>\n\n\n\n<p>1.  Follow standard process to get module records (<a href=\"http:\/\/wdp.g-integrator.com\/docs\/2020\/11\/28\/tutorial-get-module-records\/\">See tutorial for step by step instructions<\/a>). DO NOT PRESS EXECUTE<\/p>\n\n\n\n<p><strong>THE FOLLOWING STEPS MUST BE TAKEN BEFORE PRESSING EXECUTE<\/strong><\/p>\n\n\n\n<p>2. After selecting desired fields, Select option 2 &#8220;Change pull settings (optional)&#8221;<\/p>\n\n\n\n<p>3. Change value in the &#8220;Start Cell Address&#8221; field to an unoccupied column <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"483\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/041-1.png\" alt=\"\" class=\"wp-image-147\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/041-1.png 773w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/041-1-300x187.png 300w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/041-1-768x480.png 768w\" sizes=\"(max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Changes the way new data appears relative to existing data. NOTE: The default setting is for the data to appear on a new sheet. Sheets can be switched between at the bottom of the window TO REPLACE DATA ON CURRENT SHEET: 1. Follow standard process to get module records (See tutorial for step by step &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/wdp.g-integrator.com\/docs\/2020\/12\/12\/tutorial-get-output-on-new-sheet-vs-replace-data-in-same-sheet-vs-append-to-existing-data\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Tutorial: Get Output on New Sheet vs Replace Data in Same Sheet vs Append to Existing Data&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,6,5],"tags":[11],"_links":{"self":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/143"}],"collection":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/comments?post=143"}],"version-history":[{"count":1,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/143\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/143\/revisions\/148"}],"wp:attachment":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/media?parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/categories?post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/tags?post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}