- sasa999Asked 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.
- JotForm SupportEduardoMendezAnswered on March 13, 2013 at 08:41 AM
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:
- sasa999Answered on March 16, 2013 at 06:54 AM
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.
- KadeJMAnswered on March 16, 2013 at 10:58 AM
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.
- sasa999Answered on March 16, 2013 at 06:10 PM
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
- JotForm SupportEltonCrisAnswered on March 16, 2013 at 06:46 PM
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.
- sasa999Answered on March 16, 2013 at 07:47 PM
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
- JotForm SupportEltonCrisAnswered on March 16, 2013 at 10:43 PM
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!
- sasa999Answered on March 19, 2013 at 09:12 AM
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?
- JotForm SupportWelvinAnswered on March 19, 2013 at 11:50 AM
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.
- tanawatAnswered on April 20, 2013 at 01:46 AM
- canerbalciAnswered on May 09, 2013 at 09:29 AM
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.