- tech_foAsked on March 15, 2018 at 05:36 AM
my account tech_fo (ps: quote is OK)
my form is connected to Google sheet. Since 14.03 the data has ceased to arrive in the table, why?
- tech_foAnswered on March 15, 2018 at 06:00 AM
- JotForm SupportTREVONAnswered on March 15, 2018 at 09:01 AM
Apologies for any inconveniences caused. Would you kindly try removing the integration and adding it again to your form?
Kindly note that this will create a new file however it will have all submissions. Kindly note that this may take some time depending on number of submissions your form has.
Kindly do let us know if this does not resolve the issue.
- tech_foAnswered on March 15, 2018 at 09:37 AM
this does not work and results in data loss
loss of more than 3,000 polls, this is a lot, how to fix it? ((
- JotForm SupportTREVONAnswered on March 15, 2018 at 11:09 AM
Kindly note that you will not loose your data on re-integrating with Google Sheet since the integration is picking data from your submissions.
As long as submissions are not deleted when you run the integration the form will sync with google sheet. Depending on number of submissions and size of each submission it may take some time for the data to be in sync.
Would you kindly confirm how many submission have ben Synced so far?
- tech_foAnswered on March 15, 2018 at 11:21 AM
Total 3741 submission
500 submission add sync google sheet
the rest do not sync
- JotForm SupportTREVONAnswered on March 15, 2018 at 12:33 PM
Thank you for confirming the above. I have pushed submissions to your google spreadsheet. Kindly confirm all submissions have been added to your Google sheet document
- tech_foAnswered on March 16, 2018 at 01:56 AM
nothing changed, this does not work
look at this problem in video http://recordit.co/JJsslr94K3
- JotForm SupportVictoria_KAnswered on March 16, 2018 at 07:54 AM
As far as I understood this issue upon jumping in to the thread, I can see that for some reason the original Google Spreadsheet integration was broken a while ago. You have re-integrated several times and got only 500 submissions synchronized immediately.
I have tried to download all your submissions as an excel file and can confirm that it includes all your submissions, which are ~3000. This means that the process works properly at our end.
Investigating the issue deaper, I have found the following information as to Google limits:
My suggestion would be that the process can take a while to reflect all ~3000 submissions.
I have tried to push the submissions once more, can you kindly let us know if it helped today?
- tech_foAnswered on March 21, 2018 at 08:35 AM
Thank you, but this is really a problem google. Well, I did so, I downloaded the Excel file and deleted all submissions, and delete integration google sheet. i create new integration sheet, but I do not get the data.
now more than 1k submissions and I'm forced to again export excel data manually
on another project it works without failures
- JotForm SupportTREVONAnswered on March 21, 2018 at 10:23 AM
Apologies for any inconveniences caused. Based on further analysis of the problem I would like to escalate the issue to our Level2 support team. We will update you on this thread once the issue is resolved.
In the meanwhile, kindly share the google spreadsheet (https://docs.google.com/spreadsheet/ccc?key=107aakdXYKjKCykLizNzi2-Wa5uqJeK48rPE2Kvqp9Og)with us to assist our developer to further investigate the issue. Use the guide below:
Share the above withe email firstname.lastname@example.org and let us know when its done
- tech_foAnswered on March 22, 2018 at 02:07 AM
Thanks you, I added access to the table