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

    If I make changes to the Google Spreadsheet, should those changes stick

    Asked by uclamusicstage on October 12, 2015 at 09:17 PM

    If I make changes to the Google Spreadsheet, should those changes stick? Because every once in a while it seems the spreadsheet resets, and looses all the changes I've made.

    I kinda need to be able to notate and track the info that comes from the form.

    Thanks



    This is a re-post of a comment on How to Integrate Form with Google Spreadsheet

    Google Spreadsheet changes in the file changes lost file is reset
  • Profile Image
    JotForm Support

    Answered by Welvin on October 12, 2015 at 10:37 PM

    As far as I know about the latest update in our Google Spreadsheet integration, it should not reset your file to its default state. If it's doing that, please try re-integrating the form again. Doing so would give you a new sheet. Please do the changes in the spreadsheet and see what will happen if a submission is made.

    Thanks

  • Profile Image

    Answered by kaitmiller on October 16, 2015 at 04:12 PM

    I have the same question... and also just had a problem today with the spreadsheet changing. I will try re-integrating the form again.

    When was the latest update in the google spreadsheet integration?

  • Profile Image
    JotForm Support

    Answered by Mike on October 16, 2015 at 05:08 PM

    @Kaitmiller,

    The integration will still reset associated spreadsheet if you add new fields to the form or change existing field labels.

    Thank you.

  • Profile Image

    Answered by LHEDJ on September 28, 2016 at 11:42 AM

    has there been a solution to the sheet resetting upon updating the form?

  • Profile Image
    JotForm Support

    Answered by Mike on September 28, 2016 at 01:41 PM

    @LHEDJ,

    We do not have an option to stop the default Google Spreadsheet resetting upon updating the form.

    It might be possible to import the spreadsheet data to another (your custom one) spreadsheet with an IMPORTRANGE function.

    Google Docs: IMPORTRANGE

    Also, there is an alternative to our Google Spreadsheet integration - the integration via JotForm > Zapier > Google Spreadsheet.

    Zapier: Save new JotForm responses as Google Sheets rows