Question about Google Sheets Integration

  • NStarOrchard
    Asked on April 4, 2019 at 10:56 AM

    I always link my forms to Google Sheets...

    Question: If I add one or several new things to my form, will it add those seamlessly to the currently integrated sheet, or will that get messed up or not work?

    Ex: If I add a couple of new events people can register for, will those new things show up on my current sheet which doesn't already include them?

    Thank you!

  • David JotForm Support
    Replied on April 4, 2019 at 12:26 PM

    Any time changes are made to the form, those changes will attempt to update to the sheet with the next submission. This does very often cause the integration to disconnect due to the column structure in the sheet changing.  If that does occur, disconnecting and reconnecting the integration would create a new sheet with all current form fields and data.

  • NStarOrchard
    Replied on April 5, 2019 at 10:26 AM

    Will the previously entered data migrate into the new sheet, though??

    If not, any suggestions how to do that?

  • David JotForm Support
    Replied on April 5, 2019 at 11:39 AM

    All current form data would be sent to the new sheet.  If a submission had been deleted, it would not be included, but all data present in the submission view would be sent to the new sheet.