Google spreadsheet integration is buggy

Timothy Law
Asked on January 07, 2020 at 02:49 AM

Hi Jotform Team,
I currently have a form with 2 tables where the end-user could populate with numbers - however the google sheet integration for the first table is buggy whereas the second table's results are fine. Any idea how I could fix this? Thanks.

This is a re-post of a comment on How to Integrate Forms with Google Sheets
jherwin
Answered on January 07, 2020 at 05:30 AM

Have you edited the headers in your form or in google sheets?

Please note that if you edit anything on the spreadsheet, your integration will break. You should not edit your spreadsheet.

Please try to reintegrate the form to google spreadsheet again and see if that fixes the issue.
Lalamovemarketing
Answered on January 07, 2020 at 05:32 AM

Hi Jherwin,

I haven't moved the headers and have reintegrated with googlesheets 3 times over 3 weeks, once reintegrated the correct results populate the sheet but subsequent entries begin to bug-up again.

Look forward to hearing from you
jherwin
Answered on January 07, 2020 at 06:51 AM

Can you please tell us to which form this issue is related to and we will try to manually push the submissions from our end to your integrated google sheets.

Guide: Where-to-Find-My-Form-URL

Looking forward to your response.
Lalamovemarketing
Answered on January 07, 2020 at 09:05 PM

This is the link: https://form.jotform.me/93381565600457

I've modified some of the responses to reflect what was submitted, so I'm concerned about future submissions vs. the previous records

Thanks
jherwin
Answered on January 07, 2020 at 10:41 PM

I have pushed the data to your integrated Google Sheet from our end. Please check to confirm whether the data is now visible on the integrated Google Sheet.