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.
A spreadsheet normally gets created after the integration, we don't believe there's an option where a spreadsheet will be created after submission. You may have integrated the form to google spreadsheet a couple of times and it created a couple spreadsheets with the same name.
There should be only one spreadsheet in there that will be updated with each new submissions, it should be the most recently created one, try running a couple of test and check the number of spreadsheets you have on google docs.
This is a bug, and I was able to reproduce it on a cloned version of your form.
I have escalated the problem to our Developers to proceed with the further investigation.
In the meantime, you can delete 'old' spreadsheets.
We will update this thread as soon as we have any news.
I also created a new form from scratch and still have the same problem.
sorry for the inconvenience. i am investigating the problem right now, i will inform you as soon as i release a fix (probably within a few hours)
I saw someone else reported another issue I am having, the uploaded files are stored in Google Drive, however the spreasheet is giving a link back to jotform instead of drive.
i saw another post you made about some characters causing problems with integration. Just so you know, both forms use <BR> to force line breaks on some questions - otherwise the text goes off the page.
I just tried removing the breaks on my new/scratch form however it has not updated the spredsheet yet.
hmm, now on my new form, the spreadsheet gets created, but number updates - unless I delete integration and resetup. Then all entries are populated once, and no new ones. I have deleted and re added integration twice.
hi dcstalls ,
I've just released a fix for <BR> tags, but the problem with your form was with column names starting with numbers. Google spreadsheets api refuses to work with column names starting with numbers. There are five fields that have labels containing only numbers. 2009, 2010 etc. in your form. Can you change them to something like Year 2009, Year 2010, Return 1040 ? If changing will not be an issue than your form should work well with gdocs integration.
Hope this resolved your problem, and please don't hesitate update this thread if you have further questions
What about the original form? It is still creating new spreadsheets with every submissing.
The new form is not updating at all (i added a submission about an hour ago) and it is still not in its spreadsheet.
You have to remove the integration, edit your form and reintegrate it. It makes sense that your last submission was not added to the spreadsheet because of the problem that we talked about (numbered field names).
Your previous submissions will be preserved if that was your worry.
ok... thank you.
However, back to the original form, now there are 5 fields that are no longer populating on the spreadsheet:
- Do you currently use a Document Management System (DMS)?
- If yes, do you use Arkworks or other? (please specify)
- Upload of Tax Renewal Letter (no link but file is visible in gdoc)
- Do we have permission to list your company on our member page?
- Upload of company logo
Hi, I was able to reproduce the new issue with those fields you mentioned not populating the spreadsheet. Here is a link to the google spreadsheet of my test form
On initial assessment, I think it has to do with field's labels/questions that are using comma(,) or parenthesis() -- I am about to retry without this characters on the form and see if it fixes the issue.
However, the original issue that this thread is about, seems to have been resolved ("A new Google Spreadsheet is being created on each submission")
So, I would like to suggest that you create a new post/topic for this new issue so that our developer can address the new bug separately. You can easily create the new topic here
Ok, but these are issues created from the changes the developer made. These fields were not having any problems before the code changes this morning.
Also, the logo permission does not have the punctuation. It does have a / (forward slash) but so do many default JotFields.
Have you tried re-integrating your original form yet? If not, I would suggest to do so to refresh the integration, see if that makes differences. It might also help if you could clear your browser's cache before re-integrating your form.
We'll wait your findings. Thank you!
Same problem still exists...
I can still see some symbols to your form. Can you please remove or change them into words? Especially those symbols for Calculations like , -, / & \, ( & ). Although, I cannot replicate the issue after cloning your form and integrating it to Google Spreadsheet.
The fields/columns that are not populating are
- Do you currently use a Document Management System
- Please scan and upload
- Do we have permission to list your company (A REQUIRED FIELD)
- If you have a logo...
It looks like that Google Spreadsheet does not accept heavy titles with different symbols.
I would like to recommend you to do the following:
- Do you currently use a Document Management System
Please try to avoid using -- in title.
Remove highlighted parts:
Do you currently use a Document Management System -DMS- ?
Please scan and upload
Try removing brackets:
Please scan and upload a copy of your Thomson Reuters 2013 Tax Renewal letter.
(This is just to verify you are eligible to receive any additional price consideration
from Thomson Reuters. If you do not want to upload please leave a note in the box
below and someone will be in contact with you).
Do we have permission to list your company on our member page and or company logo?
Seems to be fixed
- If you have a logo...
Try removing the comma from title:
If you have a logo that you would like us to use, please upload here.
I hope that mentioned changes will solve the problem for you. Thank you.
Ok, but you guys seem to be missing the point. All of this was working working before the code changes. Is there a way for me to have the questeions they way they are typed on the form, but user different header info on the form?
and that still does not account for the number of entries being mismatched!
Hi, the original post and the ticket submitted was actually about new spreadsheet created for each form submissions. Our developer (Canerbalci), to whom the bug ticket was assigned have fixed this already.
I can also confirm that this bug was fixed. Because I could not reproduce the issue of new spreadsheet for each submissions. Please do confirm to us if this issue still happens on your end?
As for the new issue "some columns are not being populated in the spreadsheet", I really suggest that you create a separate post for this so that it can be addressed separately -- outside this thread.
Please use this link to create a new post/topic
and we will attend to your new post immediately.
Ok, I created a new post yesterday (nobody commented yet). The original issue was corrected.
Thank you for updating us on the fixed original issue.
You must be refering to your new post here http://www.jotform.com/answers/215314-Integration-with-Google-Spreadsheets-not-working#3
I see that your question was attended to already. Let us use that new thread to provide you assistance.
I will then marked this thread as closed.