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.


  • Profile Image

    A new Google Spreadsheet is being created on each submission

    Asked by dcstalls 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:
    www.taxwatchgroup.org/register

    Screenshot
    Submissions new submission
  • Profile Image

    Answered by bumgore 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.

  • Profile Image
    JotForm Support

    Answered by Mike_T 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.

  • Profile Image

    Answered by dcstalls on May 08, 2013 at 08:35 AM

    I also created a new form from scratch and still have the same problem.

  • Profile Image

    Answered by canerbalci on May 08, 2013 at 08:41 AM

    hi dcstalls,

    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)

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image

    Answered by canerbalci 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

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image

    Answered by canerbalci 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.

  • Profile Image

    Answered by dcstalls 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

  • Profile Image
    JotForm Support

    Answered by jonathan on May 08, 2013 at 04:19 PM

    @dcstalls

    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

    https://docs.google.com/spreadsheet/ccc?key=0ArHMx2ARJqlrdGotVVZGM0JVcG5yalV0d096enAxM2c&usp=sharing

    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

    http://www.jotform.com/contact

     

    Thanks.

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image

    Answered by dcstalls 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.

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 08, 2013 at 10:25 PM

    @dcstalls

    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!

  • Profile Image

    Answered by dcstalls on May 09, 2013 at 01:14 PM

    Same problem still exists...

  • Profile Image
    JotForm Support

    Answered by Welvin on May 09, 2013 at 02:16 PM

    Hi,

    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.

    Thanks

  • Profile Image

    Answered by dcstalls 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...

  • Profile Image
    JotForm Support

    Answered by Mike_T 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.

  • Profile Image

    Answered by dcstalls 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?

  • Profile Image

    Answered by dcstalls on May 10, 2013 at 09:27 AM

    and that still does not account for the number of entries being mismatched!

  • Profile Image
    JotForm Support

    Answered by jonathan on May 10, 2013 at 10:58 AM

    @ dcstalls

    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

    http://www.jotform.com/contact

    and we will attend to your new post immediately.

    Thanks.

     

  • Profile Image

    Answered by dcstalls on May 10, 2013 at 11:34 AM

    Ok, I created a new post yesterday (nobody commented yet).  The original issue was corrected.

  • Profile Image
    JotForm Support

    Answered by jonathan 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.

    Regards,