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

    Form fields are not all mapping to Google spreadsheet columns

    Asked by lesansley on May 29, 2013 at 05:00 PM
    I've just been playing around with JotForm (which is pretty cool) but I seem to be having a problem with the Google Docs integration. I have set up a form with 27 fields. When I submit a form only the first nine fields (columns) and the last field are imported into the spreadsheet. So the mapping I get is:
    Column A - Submission Date
    Column B - Field 1
    Column ... - Field ...
    Column J - Field 9
    Column K - Field 27
    Column L - IP
    Column M - SubmissionID
    I really need all 27 fields to be imported into the spreadsheet. Any help with this would be most appreaciated.
    PS I copied the fields when I was developing the form, could be the problem?
    JotForm problem div google integration spreadsheet import
  • Profile Image

    Answered by lesansley on May 29, 2013 at 05:20 PM

    I redid the form and removed all the copied fields and it imported correctly. I can only guess that it must assign a unique ID to a field when it is first created that is then ported across when copied. then when the submitted form is imported into google docs only unique field IDs are included.

  • Profile Image
    JotForm Support

    Answered by jonathan on May 29, 2013 at 06:50 PM

    Hi,

    Thank you for contacting us.

    From your latest message, can I assume that you have sorted out the issue already?

    From what I understand on what you initially did, you added new fields to the form after you have already integrated to google docs spreadsheet -- the new fields will not be in the google spreadsheet unless you re-integrate the form again.

    So, whenever you amend  the form, you should redo the integration process so that the changes will also reflect on the spreadsheet.

    Please inform us if you have further inquiry.

    Thanks.

  • Profile Image

    Answered by ajarvis on June 05, 2013 at 04:43 PM

    I am having the same issue. I created a basic time sheet for our field folks. 

    All data goes in perfectly except the "TIME" fields. I did duplicate them to keep the 5 minute settings. 

    I did the whole form (only duplicating the times) and then linked it to a google spreadsheet.

    I would love to get this figured out as we have a lot of future use for this product! (We like it because it's very simular to MS Access in terms of capturing data. Just easier when people are out on the road)

  • Profile Image
    JotForm Support

    Answered by EltonCris on June 05, 2013 at 07:42 PM

    @ajarvis 

    We'd appreciate if you could please open your question into a separate thread so we can assist you better. Please include the form in question for us to investigate.

    Thank you!