Google Spreadsheet - Lost all current data and formatting

Hello,

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.

Thank you,

Mike

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.

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?

Thanks, Mike

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.

Thanks.