What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Google Spreadsheet Integration: Spreadsheet not synching on jotformEU.com domainAsked by sasa999 on March 13, 2013 at 03:41 AM
I have conected my form to Google spreadsheet, but it transfer only data that was submited before connection. Any new submision is not shown in spreadsheet, I got only email with form data. When I reconect, then it sends all missing data, but anyway any new submissions after reconection is not visible in Google spreadsheet. Can you help resolve this. Yrsterday I tested many times, but with no results. How much time take sinhronisation with google? May be more than 12 hours? Had tested right from here in prewiev, and from google blog. Mail notifications works fine.
Can you please provide us the URL of the form so that we can test and if necesary forward this to our dev team?
Meanwhile, you may want to look into our HTML listing Report. It can be embedded in a page or on a form and updates with every entry. Here is a guide to help you with that:
Tnx for answer! You can look all my forms. They all is not visible in google spreadsheet. I cen see only old submissions. I was trying Chrome, firefox, ie8, chache and cokies cleaning, form cloning, user account changing, meny reintegrations, but nothing helps get spreadsheet alive. Yesterday I found that there is no any importHtml on google spreadsheet that is created by jotform. I am not programmer anb maybe I am wrong. How do you transfer data to google spreadsheet? through importHtml or differet way? Can you write right adress where is stored table that contains data table that shoud be in google spreadsheet. I wiil try manualy resolve problems with dead Google spreadsheets.
Hi, I've done some additional investigating on a your forms and so far it is noted that you don't really have a whole lot of submissions on any of your forms but when you re-integrate it will grab all of the details and show it on your form to recompile it and from what I can tell the Integration is working properly as I was unable to replicate the same problem. Please try removing the integration then add it again. If you are having trouble with understanding the Google SpreadSheet Integration then I would like to recommend that you read it's guide throughly. If you are still having trouble please let us know.
I can not understand where and how you coud see that if my list 5 minutes ago was empty without any records
next after reintegration that i see on jotform after 2 submissions from 2 computers
this is what i see in Google spreadsheet
can you see difference in records. I look this for 3 diferent computers with different browsers. Submiting from 2 different computers..
try fill form and submit
there is link to my spreadsheet that you can see how nothing changes for new submissions - they are invisible for Google
p.s Have read http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly
Thank you for all the details. I have escalated the problem to our development team so they can look into this further.
Meantime, please try to clone this form: http://form.jotformpro.com/form/30746882963972? and integrate it to Google Spreadsheet. If the problem still persist, let us know so we can add it on the report.
Thanks and apologies for the incovneniences caused.
There is results
link to cloned form http://jotformeu.com/form/30747834207355
Let me know if you will be able make new submissions that i can see they in my spreadsheed
Thanks for your cooperation. The problem has been escalated to our dev team. They'll get back to you as soon as they check this thread. Thanks!
Today I check My form and found my google integration link is broken., After reintegration my google spreadsheet got data from JotForm :))))
OK that is good, All works . I am happy BUT ...:(
It start sending data to another (new) spradsheet. How to get data in my old spreadsheet?
Yes, reintegration will give you another spreadsheet. That is how it works. Unfortunately, all custom data to the old spreadsheet can only be moved manually. You will have to copy and paste them as stated by my colleague Gleen on the thread provided.
This is a bug related to Google Spreadsheets Api not accepting working with column names starting with numbers. For a quick workaround, can you please rename your columns that start with numbers to something like "Number 1", "Number 2", etc...
I am looking for a fix, however there seems no easy way since changing the behavior for this particular case has the potential of disrupting already working integrations of thousands of users.
Closing the ticket for now.