I am no longer getting updates on my google sheet from the JotForm.

  • Profile Image
    Iz Flores
    Asked on May 07, 2018 at 02:08 AM

    Hi-

    I am no longer getting updates on my google sheet from the JotForm. How can I confirm if the integration is broken and how do I fix it if it is broken?



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Scott
    Answered on May 07, 2018 at 04:21 AM

    Hey there Iz,

    Can you please share the integrated form's link or ID?

    Meanwhile, you can always delete the current integration and re-integrate your form. This will be also passing on the existing submission data too.

    ps. If you have made any manual changes on the integrated sheet, it can break the integration

  • Profile Image
    Iz Flores
    Answered on May 07, 2018 at 07:43 AM
    So it looks like the form is working again. The new form submissions just rolled in.
    Are you with Jotform or a user group?
    ...
  • Profile Image
    amy
    Answered on May 07, 2018 at 08:01 AM

    Dear Iz, 

    It is very nice to hear that your problem has been resolved. 

    One of spammer sent a message to your thread and my colleague has already deleted it. Please ignore that post. 

    Let us know if you need further assistance. 

  • Profile Image
    Iz Flores
    Answered on May 09, 2018 at 01:43 PM
    Hi-
    I’m having an issue again. It looks like the googlesheets picked up a column heading and put it in the middle of the responses. It is causing an issue again.
    How can I reset the integration to google sheets? If I reset the integration, will it go to a different file?
    Sent from my iPhone
    ...
  • Profile Image
    Kevin_G
    Answered on May 09, 2018 at 02:21 PM

    I would recommend you to reset the integration and avoid making changes on the integrated sheet, this will create a new document where the submissions from the form will be sent to, but you may import those submissions into a different file and edit this second file. The following guides will help you with that: 

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    https://support.google.com/docs/answer/3093340?hl=en 

    Please let us know if the issue persists.