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: some data not transferredAsked by yannbuydens on December 11, 2013 at 10:03 AM
When I integrate JotForm with google spreadsheet when a new form submission arrives it does not copy all the fields.
Some fields are blank although I filled them in when I tried out my form. When I look at the form submission in jotform I can see them correctly. Problem is that I want them correctly in google spreadsheet also.
Can someone help me out plz? Its super important.
We apologize for this inconvenience. Upon checking your form it seems to be working fine.
However, I think the reason why some of the fields remain empty is because of the Condition you set on user choices as it skips to different pages leaving other fields blank. I tried to test it further depending while following your conditions and they appear on the Google spreadsheet without problems.
Here are a few things that you can do to fix this:
1. Clear your form's caches. Please view this user guide
2. Remove the Google Spreadsheet integration and reintegrate again.
3. Clone your form and integrate Google Spreadsheet from the cloned form and see if it is working. If it is working use that cloned version of the form.
Please let us know if the above suggestions do not work so that we can assist you immediately. Thank you
Hi I cloned it, cleared the cache. Still not every field gets inserted.
The email I receive is complete but certain fields google spreadsheet do not get updated.
More specifically the je veux, le, entre et fields in the form.
Again the form is correctly saved in jotform but there the integration between jot form and google spreadsheet is
BTW I dont see why clearing the cache would help in this problem since I dont think that
google spreadsheet is caching a lot on my computer (but I may be wrong).
Guys and gals can you please help me solve this problem? If I cant solve it soon Ill just make
a uglier form in google forms and be done with it.
We will investigate this problem and get back to you.
Just so that I am clear the integration is working but some of the form data are not showing up on the spreadsheet? Exactly which form questions are missing on your spreadsheet?
Yes exactly. There are new responses filling up in the spreadsheet and some columns do not get filled in correctly.
I know for certain that the following form questions are not showing up correctly:
je veux, le, entre et fields.
There could be other form fields but these Ive tested to be faulty.
Thanks for the information provided. We will notify you via this thread when the issue is resolved.
The issues are resolved along with overall improvements/enhancements on google spreadsheet integration. Please let us know if you still experience any issues.