- dcstallsAsked on May 07, 2013 at 01:08 PM
Every time a new submission is submitted, i get a new file with all data instead of updating the original spreadsheet.Page URL:
- bumgoreAnswered on May 07, 2013 at 01:24 PM
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.
- JotForm SupportMike_TAnswered on May 07, 2013 at 03:11 PM
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.
- dcstallsAnswered on May 08, 2013 at 08:35 AM
I also created a new form from scratch and still have the same problem.
- canerbalciAnswered on May 08, 2013 at 08:41 AM
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)
- dcstallsAnswered on May 08, 2013 at 08:46 AM
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.
- dcstallsAnswered on May 08, 2013 at 08:48 AM
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.
- dcstallsAnswered on May 08, 2013 at 09:17 AM
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.
- canerbalciAnswered on May 08, 2013 at 10:18 AM
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
- dcstallsAnswered on May 08, 2013 at 10:45 AM
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.
- canerbalciAnswered on May 08, 2013 at 10:56 AM
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.
- dcstallsAnswered on May 08, 2013 at 01:53 PM
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
- JotForm SupportjonathanAnswered on May 08, 2013 at 04:19 PM
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
- dcstallsAnswered on May 08, 2013 at 06:48 PM
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.
- dcstallsAnswered on May 08, 2013 at 06:53 PM
Also, the logo permission does not have the punctuation. It does have a / (forward slash) but so do many default JotFields.
- JotForm SupportEltonCrisAnswered on May 08, 2013 at 10:25 PM
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!
- dcstallsAnswered on May 09, 2013 at 01:14 PM
Same problem still exists...
- JotForm SupportWelvinAnswered on May 09, 2013 at 02:16 PM
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.
- dcstallsAnswered on May 09, 2013 at 04:11 PM
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...
- JotForm SupportMike_TAnswered on May 09, 2013 at 05:56 PM
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.
- dcstallsAnswered on May 10, 2013 at 09:19 AM
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?
- dcstallsAnswered on May 10, 2013 at 09:27 AM
and that still does not account for the number of entries being mismatched!
- JotForm SupportjonathanAnswered on May 10, 2013 at 10:58 AM
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.
- dcstallsAnswered on May 10, 2013 at 11:34 AM
Ok, I created a new post yesterday (nobody commented yet). The original issue was corrected.
- JotForm SupportjonathanAnswered on May 10, 2013 at 01:03 PM
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.