Google Spreadsheet - Lost all current data and formatting

  • mbrey
    Asked on October 2, 2017 at 3:13 PM

    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

  • David JotForm Support Manager
    Replied on October 2, 2017 at 4: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.

  • mbrey
    Replied on October 3, 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?

    Thanks, Mike

  • liyam
    Replied on October 3, 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.

    Thanks.