Why did my Google Spreadsheet become disconnected?

  • Profile Image
    MobileGist
    Asked on March 21, 2018 at 04:23 PM

    Hey there,


    Everything was working, but now my Google Spreadsheet has become disconnected from my order form.


    PayPal gets the order and collects the payment. JotForm sends the email but I don't see the order on Google Docs.


    What am I over looking?

  • Profile Image
    Adrian
    Answered on March 21, 2018 at 05:25 PM

    Making changes to the form (such as renaming a question or adding/removing a question) or to the spreadsheet can break the integration.

    To fix this, remove the Google Spreadsheets integration and add it again. This would create a new sheet and it will sync all the submissions that were made to your form and the new ones.

  • Profile Image
    MobileGist
    Answered on March 22, 2018 at 08:50 PM

    Hmmm. Ok, so I did delete a question and hide some others.  Now I've removed the integration and even tried and clone, but it's not working.


    Mind taking a peek?


    https://form.jotform.com/80785430099161


    (it works so well the first time I didn't really pay attention what I was doing in order to trouble shoot now :))


    Also, can you have a spreadsheet and Drive integration running at the same time? ( I currently do not but might want to)

  • Profile Image
    Nik_C
    Answered on March 23, 2018 at 03:52 AM

    Unfortunately, we cannot check your Spreadsheet since we don't have access.

    But, I tried to push the missing submissions manually, please check if they are showing properly.

    Also, you can integrate with Google Spreadsheet and Google Drive in the same form, that will work fine since those are two separate integrations.

    Let us know if you need any further assistance.

    Thank you!