- uclamusicstageAsked 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.
This is a re-post of a comment on How to Integrate Form with Google Spreadsheet
- JotForm SupportWelvinAnswered 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.
- kaitmillerAnswered 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?
- JotForm SupportMikeAnswered on October 16, 2015 at 05:08 PM
The integration will still reset associated spreadsheet if you add new fields to the form or change existing field labels.
- LHEDJAnswered on September 28, 2016 at 11:42 AM
has there been a solution to the sheet resetting upon updating the form?
- JotForm SupportMikeAnswered on September 28, 2016 at 01:41 PM
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.
Also, there is an alternative to our Google Spreadsheet integration - the integration via JotForm > Zapier > Google Spreadsheet.