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

  • Profile Image
    uclamusicstage
    Asked 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

  • Profile Image
    Welvin
    Answered 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
    kaitmiller
    Answered 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
    Mike
    Answered 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
    LHEDJ
    Answered on September 28, 2016 at 11:42 AM

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

  • Profile Image
    Mike
    Answered 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