Google Sheet Integration Stops

  • Profile Image
    DelivereeBKK
    Asked on March 28, 2018 at 02: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.JPG1522218403Capture.JPG

  • Profile Image
    liyam
    Answered on March 28, 2018 at 05: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.


  • Profile Image
    DelivereeBKK
    Answered 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.png

    1522378602Replication of Jotform.png

  • Profile Image
    DelivereeBKK
    Answered 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?

  • Profile Image
    BJoanna
    Answered on March 30, 2018 at 05:00 AM

    Are you referring to the Date Picker field?

    1522400136date.JPG

    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