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

  • PJ_
    Asked on February 9, 2015 at 7: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).
  • Welvin Support Team Lead
    Replied on February 9, 2015 at 8: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

  • alp_deniz
    Replied on October 4, 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

  • PJ_
    Replied on October 4, 2015 at 9: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.

  • PJ_
    Replied on October 5, 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.

  • Welvin Support Team Lead
    Replied on October 5, 2015 at 7:54 AM

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

    Thanks

  • nikolai@mctdigital.com
    Replied on May 22, 2016 at 4: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.
  • Carina
    Replied on May 22, 2016 at 5: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.