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

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 Forms with Google Sheets
Welvin

Jotform Support

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
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.
LHEDJ
Answered on September 28, 2016 at 11:42 AM

has there been a solution to the sheet resetting upon updating the form?
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