Google Sheets integration

  • CEOGlobal
    Asked on January 5, 2018 at 8:23 PM

    This form is not updating the google sheets integration:

    https://form.jotform.com/72715611084150


    But I can't tell why?  Is there a way to refresh the google sheet with the current data set from this form's submissions?  

    Otherwise, how can I fix the integration?

    Thanks.

  • Marvih
    Replied on January 6, 2018 at 2:53 AM

    Have you recently updated some fields on that form like deleting, changing or adding a new one ?

    If yes, you need to remove the Google Spreadsheet integration since it will be broken if you have changes on the form. And it is the same if you did some update/changes on your Spreadsheet.

    After removing the Integration you can now re-integrate it again.
    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet


    Please let us know if you need further help.

  • CEOGlobal
    Replied on January 6, 2018 at 2:29 PM

    I understand how to establish an integration. 

    What I need is to re-integrate with the existing google sheet, the one created by the original integration.   Isn't this possible?  The top row of the google sheet has not been changed.  

    The only change on the form has to do with unhiding a field.  Would this cause a problem with the integration?  In the past the hidden fields simply show up in the google sheet.

    I have 16 tabs that depend on data in that original sheet and I need the new data to be added in the normal fashion.  Thanks again.

  • TREVON
    Replied on January 6, 2018 at 4:01 PM

    If any changes to the form are made it will break the google integration hence you will need to do a re-integration again.

    Once you do the re-integration all the previous submissions should also appear in the newly reintegrated spreadsheet.