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

  • Profile Image
    PJ_
    Asked 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).
  • Profile Image
    Welvin
    Answered 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
    alp_deniz
    Answered 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
    PJ_
    Answered 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
    PJ_
    Answered 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
    Welvin
    Answered on October 05, 2015 at 07:54 AM

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

    Thanks

  • Profile Image
    nikolai@mctdigital.com
    Answered 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
    Carina
    Answered 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.