-
ryanwake@gmail.comAsked on March 12, 2018 at 1:18 PM
I recently added a simple change to one of the options on my form. It now no longer updates my Google Spreadsheet when the form is submitted. It still says my integration is up & running. Any suggestions?
-
Welvin Support Team LeadReplied on March 12, 2018 at 2:23 PM
Any modification to both form and spreadsheet file is not recommended once the integration is up and running. Doing so will create this kind of issue.
We can manually sync submissions to the sheet, just please share with us the form URL. However, this won't fix the problem. Once re-sync and still nothing, we recommend re-integrating the form with Google Spreadsheet. We will try to resync it. Please let us know the form.
-
ryanwake@gmail.comReplied on March 12, 2018 at 2:46 PM
Will it integrate with the exact same Google spreadsheet? I have other Google sheets pulling data from that sheet...
-
AdrianReplied on March 12, 2018 at 3:50 PM
Reintegrating the form will create another Spreadsheet.
The old sheet would not be used anymore.
-
ryanwake@gmail.comReplied on March 12, 2018 at 4:09 PM
Ok... That is not an option... I 100% need the old sheet integration to be linked to the Jotform.
-
Welvin Support Team LeadReplied on March 13, 2018 at 9:04 AM
As mentioned by my colleague, re-integrating Google Spreadsheet will give you a new sheet. If there's a reference on the current sheet, you will need to fetch the data from the new sheet. Are you doing ImportRange function?
There's no other way if re-syncing wont' work. What is the form? We will do it today. Please update us.
-
ryanwake@gmail.comReplied on March 13, 2018 at 9:43 AMThe form is "Salesperson Commission form"
... -
Welvin Support Team LeadReplied on March 13, 2018 at 10:53 AM
Syncing done. Please check and confirm.
-
ryanwake@gmail.comReplied on March 13, 2018 at 11:43 AMIt works!!
Can you also resend the form "Receipt Submission Form"
... -
Kevin Support Team LeadReplied on March 13, 2018 at 1:11 PM
I have sent the missing submissions for that form as well.
Thanks.