Form fields are not all mapping to Google spreadsheet columns

  • Profile Image
    lesansley
    Asked 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?
  • Profile Image
    lesansley
    Answered 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
    jonathan
    Answered 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
    ajarvis
    Answered 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
    EltonCris
    Answered 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!