Not all fields populating Google spreadsheet

  • Profile Image
    Asked on November 26, 2012 at 11:50 AM

    My form ( 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".

  • Profile Image
    Answered 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 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?




    [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
    Answered on November 26, 2012 at 04:00 PM


    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 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 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:  

    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
    Answered on December 07, 2012 at 11:12 AM


    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.