What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

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

    Asked by nikolai@mctdigital.com 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
    JotForm Support

    Answered by jonathan 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.