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

    Allow modification in the Google Spreadsheet sheet without resetting changes when new submission is received

    Asked by PJ_ on February 09, 2015 at 07:57 AM
    However, I would still keep on my wish and suggestion to revert the behavior of the old Google Sheet integration. Zapier is limited with a 5 minute interval of updates, whereas the old integration sends data instantly without any additional charges (being an integration itself).
    google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Welvin on February 09, 2015 at 08:06 AM

    Hi,

    As promised, I have now submitted this thread to our developers. You will be notified via this thread for updates regarding this matter.

    For now, you may consider the import range function which is the ideal solution so that data won't reset when you receive a new submission to the form. Import Range should work for as long as you keep the spreadsheet ID.

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on October 04, 2015 at 12:03 AM

    Hello,

    Until not very long ago, we have worked on Google spreadsheet integration quite intensively to fix its issues and improve it as much as possible. Not it should not reset the sheet unless a form field is modified. 

    Please let us know if you have any related trouble recently.

    All the best

  • Profile Image

    Answered by PJ_ on October 04, 2015 at 09:02 PM

    That's so great to hear! We'll check out with our sheets and test if it will still keep resetting when we send new submissions.

    Thanks a lot.

  • Profile Image

    Answered by PJ_ on October 05, 2015 at 12:54 AM

    That's so great to hear! We'll check out with our sheets and test if it will still keep resetting when we send new submissions.

    Thanks a lot.

  • Profile Image
    JotForm Support

    Answered by Welvin on October 05, 2015 at 07:54 AM

    You're welcome. Please let us know if there are issues.

    Thanks

  • Profile Image

    Answered by nikolai@mctdigital.com on May 22, 2016 at 04:40 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

    Answered by Carina on May 22, 2016 at 05:47 PM

    @nikolai@mctdigital.com   
    I have moved your question to a new thread, so it can be addressed.

    You can find it here:
    https://www.jotform.com/answers/844422 


    Let us know if we can assist you further.