- mbreyAsked on October 02, 2017 at 03:13 PM
We had a Google sheet integrated with our Jotform. Everything working quite well. Today I added a new single-choice element to the form. The new column has automatically been added to the Google sheet - HOWEVER, all the current data is gone and all the formatting has been lost.
Please advise what I should do to recover the lost data.
The element added is the "Who Is Ordering" choice.
- JotForm SupportBDAVIDAnswered on October 02, 2017 at 04:44 PM
In order to fix it, simply remove the Google Spreadsheet integration, and integrate back again: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
All the previous data will be updated in the new spreadsheet. Let us know if you need more help, we will be glad to assist you.
- mbreyAnswered on October 03, 2017 at 10:50 AM
Thank you, that worked in terms of restoring all the old data. It seems to have re-created the spreadsheet with the original data, but it appears to be a brand new sheet, with the same name. All the formatting of the original has been lost.
Am I to understand that every single time I make a change to the Jotform, that I will loose all of the work done to the spreadsheet?
Perhaps I am missing something: Is there a way to keep my original Sheet with the formatting when I make a change to my Jotform?
- JotForm SupportliyamAnswered on October 03, 2017 at 11:59 AM
Unfortunately, yes, changes on the form would cause problems on the integration with Google Spreadsheet. Also, it is not be possible to keep the existing spreadsheet for integration. It will always create a new spreadsheet for every new integration that you create.