- edswartzAsked on August 12, 2014 at 05:54 PM
My form used to update a GoogleSheet with no issue. It suddenly stopped and I thought it was because I was using the free account and I had gone over 100 submissions. I'm now on a paid plan. I thought it was b/c the sheet had run out of rows so I added 100 rows. I thought the integration had stopped so I disassociated the form and added a new one.
After trying all of these steeps it is still not populating the sheet. What else can I try?
- JotForm SupportjonathanAnswered on August 12, 2014 at 07:12 PM
We apologize for any inconvenience caused.
It is possible that we have issue on the integration on our end at this time because multiple users seems to be reporting the same problem at the moment.
I will submit a bug ticket report to our higher teams support so that this can be checked thoroughly.
We will notify you when we have update on this.
- edswartzAnswered on August 12, 2014 at 08:00 PM
Great thank you. Let me know if there are other tests you want me to try. I know there are many changes going on with Google (docs.google.com -> drive.google.com, guid's are looking different etc) so please keep us apprised. My sheet has over 30 named ranges that I utilize to update other sheets so disconnecting and reconnecting the sheets is a pain, but will support what you need to get this resolved.
Your latest paying customer :)
- JotForm SupportjonathanAnswered on August 12, 2014 at 08:05 PM
I actually could not reproduced similar issue when I test using a cloned of your form.
Try this form http://form.jotform.me/form/42237067844458?
and this is the integrated spreadsheet
if you test submit my form version, you should see the spreadsheet gets updated.
Please tell me if this is not the case on your test.
- JotForm SupportjonathanAnswered on August 12, 2014 at 08:40 PM
It is also possible that the issue was on Google side, and could have fixed by itself at this time.
Can you please retry the integration process and check your Google spreadsheet.
Kindly inform us if this issue persist.
- JotForm SupportsteveAnswered on August 12, 2014 at 08:50 PM
This is working now. It looks like it was a system or network glitch, which resolved itself. It may have been our server, the network, or Google's server. We see no further warnings in our log files and all our tests are working.
Please let us know if you encounter further issues and do apologize for the inconvenience.
- edswartzAnswered on August 12, 2014 at 10:28 PM
Works! ...but until we understand what happened, I'm at 60% confidence level.
- JotForm SupportsteveAnswered on August 12, 2014 at 11:06 PM
Excellent news! Apparently today was a "slow" day on the internet. There were global systematic issues: http://www.zdnet.com/internet-hiccups-today-youre-not-alone-heres-why-7000032566/
We're cautiously optimistic it's related, and will be sorted out within a week or two, per the article.
If you do experience any issues, please let us know.
- alp_denizAnswered on August 13, 2014 at 05:26 AM
I can also confirm that issue no longer exists.
- edswartzAnswered on August 13, 2014 at 11:29 AM
Uh oh. I think this problem has reoccurred. I've submitted 3-4 forms this morning and one got through, but then it seems to have stopped.
- JotForm SupportMike_TAnswered on August 13, 2014 at 02:17 PM
The Google Spreadsheet integration appears to be fine on my side, the new form entries are being received without any issues.
Can you try to redo the Google Spreadsheet integration on your form? You will get a fresh spreadsheet with all the past data.
- edswartzAnswered on August 15, 2014 at 12:36 AM
I've tested a few times today and it seems to be working. Thank you!
I'm not sure if you can help me with this, but now the Google Sheet no longer fires a trigger when JotForm sends new data. It used to be that when JotForm passed a row into the Google Sheet, a trigger fired that called a function. Since I reintegrated the sheet, the trigger does not fire when Jotform passes data to it. It will run manually when I update the sheet, but not when JotForm passes it data.
- JotForm Supportashwin_dAnswered on August 15, 2014 at 04:24 AM
I am glad to know that your google spreadsheet integration is working fine.
I have moved your unrelated question to a new thread and you will be answered here: http://www.jotform.com/answers/416637