Google Sheet Integration Stops

  • DelivereeBKK
    Asked on March 28, 2018 at 2:27 AM

    Hi,


    I integrated my forms to Google Sheet so that my team can have a view of the data, and use it for reporting purposes.

    However, I noticed that the entries from my Jotform had stopped sending the details to Google Sheet. I have tried to unlink and link the two but the same problem persists.

    What to do now?


     1522218433Capture2 Screenshot 101522218403Capture Screenshot 21

  • liyam
    Replied on March 28, 2018 at 5:10 AM

    Hello,

    Did any of your team make changes on the spreadsheet such as altering its contents or headers? If so, this may likely be the cause to why the integrations fail. Another possible instance of it failing is when you have made changes on the form such as adding fields. This can cause a conflict on the field information which may prevent the update of the Google spreadsheet.


  • DelivereeBKK
    Replied on March 29, 2018 at 10:57 PM

    I created another sheet that replicates the info being fed by Jotform to the google sheet. Edits are only made on the replication sheet.


    1522378559From Jotform Screenshot 10

    1522378602Replication of Jotform Screenshot 21

  • DelivereeBKK
    Replied on March 29, 2018 at 11:05 PM

    Did any of your team make changes on the spreadsheet such as altering its contents or headers? 

    The form has calendar widget (for appointment setting) that needs to be adjusted  based on our schedule. Would that affect it?

  • BJoanna
    Replied on March 30, 2018 at 5:00 AM

    Are you referring to the Date Picker field?

    1522400136date Screenshot 10

    Do you want to adjust this field or it was already adjusted?

    Editing of the field label will break the integration. Other changes inside of the field settings should not break the integration.

    If your integration stopped working, I would suggest you to re-integrate your form with the Google Spreadsheet. Remove the current integration and integrate the form again with the Google Spreadsheet. 

    How to Integrate Form with Google Spreadsheet