Question about Google Sheets Integration

  • Profile Image
    NStarOrchard
    Asked on April 04, 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!

  • Profile Image
    david
    Answered on April 04, 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.

  • Profile Image
    NStarOrchard
    Answered on April 05, 2019 at 10:26 AM

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

    If not, any suggestions how to do that?

  • Profile Image
    david
    Answered on April 05, 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.