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

    Not all fields populating Google spreadsheet

    Asked by PrattChat on November 26, 2012 at 11:50 AM

    My form (http://www.jotform.com/?formID=23274318068152) has many fields that do not consistently populate the google spreadsheet it is integrated with. One submission from this morning populated all fields, but 3 subsequent submissions have only populated the machine fields and 2 user fields (email and Twitter--which are also the only non-numbered fields).

    Thanks. In the page template linked below, the form is linked in the sidebar under "Pratt Profiles".

    Page URL:
    http://www.prattlibrary.org/booksmedia/blog/profile_test.aspx

  • Profile Image

    Answered by jeanettebmz on November 26, 2012 at 01:01 PM

    I can see on the submission inbox of your Jotform Account ,  that there are 3 test submissions as well as  one submission from (zxc)  that are not showing all of the fields. And that is why not all the fields might not be also showing in the google spreadsheet

    I just sent a test, I filled out all of the fields. Can you please tell me if they are showin on the spreadsheet?

  • Profile Image

    Answered by PrattChat on November 26, 2012 at 02:02 PM

    Thank you for helping! I only see the same fields as with the earlier submissions: Submission Date, Email, Twitter, IP, and Submission ID.

    My form does not require that the user fill out all the fields; only name and contact are required. The tests I submitted that don't have all the fields fiilled out appear in the submission inbox as I filled them out, and they do not match the Google Spreadsheet.

    Could this be a bug, or could there be some problem with the way I created the form?

    Thanks!

    Jessica

     

    [edit] I should also add that in the spreadsheet, the new entries that don't have all the fields are formatted differently from the earlier ones that show up properly. They have a different font and alignment.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 26, 2012 at 04:00 PM

    @PrattChat

    Indeed, this is a bug with our Google Docs integration. Field labels that start with a number are the ones that are being affected.

    I have alerted our developers about the existence of the said bug. We'll inform you when this gets resolved.

    Sorry for the inconvenience.

  • Profile Image

    Answered by PrattChat on November 26, 2012 at 04:15 PM

    Thanks! I'll try removing the numbers and see if that solves the problem.

  • Profile Image

    Answered by kimberlydaniels11 on December 07, 2012 at 10:44 AM

    my form submissions are also not populating. they were... then they just stopped again yesterday...  all submissions were not populated. as the admin... I know I did not make any changes to the form, the placement area in Google Drive or to the folder... or anything.  While I was offline it was working... andt then it stopped.  so I only have th submissions from the previous day and that's it.  Here is my form link:    http://www.jotformpro.com/kimberlydaniels11/BJCLUBReport  

    I have a paid plan.  and it was working. It's not that some fields aren't working. the entire submission to the assigned/linked Google Spreadsheet just completely stopped.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on December 07, 2012 at 11:12 AM

    @kimberlydaniels11

    As your issue is a little different from the original topic at hand, would you mind if I ask you to open a new thread specific to your problem?

    This way, we will be able to focus on your problem and provide a better support experience for you and for others as well.