Google Sheets integration

  • Profile Image
    CEOGlobal
    Asked on January 05, 2018 at 08: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.

  • Profile Image
    Marvih
    Answered on January 06, 2018 at 02: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.

  • Profile Image
    CEOGlobal
    Answered on January 06, 2018 at 02: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.

  • Profile Image
    TREVON
    Answered on January 06, 2018 at 04: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.