I would like to be able to edit the Google Spreadheet without the changes being reset when new submission is received

  • Profile Image
    nikolai@mctdigital.com
    Asked on May 22, 2016 at 05:46 PM
    I am running into the same issue here. I would like to add several new columns where I can add notes, confirm dates, etc. I'm am not editing any of the info in the linked columns. Every time a new submission is made and the sheet repopulates it wipes out these columns. Is there a way to prevent this? Other option would be to create a second sheet with this info and then edit each individual submission with this info. But its not the cleanest method.
  • Profile Image
    jonathan
    Answered on May 22, 2016 at 06:57 PM

    We always recommend not editing the Submission sheet created by the google spreadsheet integarion. It is because every time the integration itself is reset, it will re-create the entire Submission sheet. Thus, wiping out any changes/customization done on the Submission sheet.

    There will be times when you will have to reset the integration (remove and re-integrate process). 

    As far as I know, if just adding new columns besides the existing columns of the Submission sheet, it is possible and will not break the integration.

    But the inserted columns should not be within the existing columns... it should only be on the farthest right. Basically it is not inserting but appending instead. 

    As you had already mentioned, doing the customization on a separate sheet will be the more safer method. If you can use data formula and look functions on the separate sheet, you will not have to manually edit each new submission rows every time.

    Hope this information help. Let us know how we can be of further assistance.