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

    Some fields are missing in Google Drive integration

    Asked by sophiebeique on November 21, 2013 at 09:51 PM

    Hi,

    I have created new forms last month and even if I tried to clear my cache and reintegrate the forms some fields are still missing and I have to cut and paste the date from excel exportation every day...

    These are the links:

    Form: http://jotformpro.com/form/32828626152961

    Intégration: https://docs.google.com/spreadsheet/ccc?key=0ArjqCkXqithZdGhSWXp3UVo2NkdYcHdacjE1NUVoTEE&usp=drive_web#gid=0

     

    Form: http://jotformpro.com/form/33125443564956

    Integration: https://docs.google.com/spreadsheet/ccc?key=0ArjqCkXqithZdEFiN3JxbXVlRjlZbkRhMmtGbzM5NlE&usp=drive_web#gid=0

     

    Thank you for your help.

    excel cache new forms
  • Profile Image

    Answered by Cesar on November 22, 2013 at 12:50 AM

    I have been able to replicate the issue by cloning both forms. On the clone of http://jotformpro.com/form/32828626152961 the only submission to log all the fields was the first submission then al subsequent submissions left a lot of required fields blank after making sure I filled out all fields within the form.

    https://cms.jotform.com/uploads/image_upload/image_upload/global/21348_tesst11212013.png

     

    The clone version of the form: http://jotformpro.com/form/33125443564956 did not sync any of the fields. Even after performing multiple submisison to the form:

    https://cms.jotform.com/uploads/image_upload/image_upload/global/21349_tesst112120132.png

    A simple test form did fill out the submissions on the integration properly.

    I will go ahead and raise a ticket in regards to the forms listed above. This way the development team can provide us further assistance as to why the integration is wokring properly on said forms.

    If you do need further assistance, do let us know. Thank you.

  • Profile Image

    Answered by sophiebeique on November 24, 2013 at 10:50 PM

    Hi,

    It seems like I have the same problem with this form:

    Form: http://jotformpro.com/form/33108832225953

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

    I hope it will be fixed soon because I have to cut and paste the excel exportation every day if I want the integration to be updated...

    thanks again for your help...

  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 25, 2013 at 03:57 AM

    Hello sophiebeique,

    We would appreciate if you start a new thread for your question related to your issue of google spreadsheet integration. We cannot answer multiple question and a new thread will help us create a separate ticket for you and send it to our back end team.

    That would help us to give your proper assistance and at the same time it would help other user with having the same problem.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz on December 06, 2013 at 12:37 AM

    Could you please provide some information. I would be glad to know which fields are missing and have some screenshots, spreadsheet links.

    All the best

  • Profile Image

    Answered by sophiebeique on December 14, 2013 at 12:29 AM

    Hi these are the three speeadsheet links:

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

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

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

    Here the form links:

    http://jotformpro.com/form/32828626152961

    http://jotformpro.com/form/33125443564956

    http://jotformpro.com/form/33108832225953

    I noticed that the missing fields were: Full Name and Check box in each spreadsheet

    here is a link for a screenshot example https://drive.google.com/?tab=wo&authuser=0#my-drive

  • Profile Image

    Answered by jedcadorna on December 14, 2013 at 05:02 AM

    Hello sophiebeique,

    Thank you for providing us with the details of the issue our developer will be looking into this and will notify you if any update is available. We thank you for your patience.

  • Profile Image

    Answered by sophiebeique on February 05, 2014 at 01:11 AM

    Hi,

    I'm still waiting for a Solution because it's not getting better.... Do you think it will be solved soon?

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 05, 2014 at 04:08 AM

    @sophiebeique

    I am truly sorry to say, but there is no updates about this from the higher ups. However, I see from the reports that there have been few commits and fixes for google spreadsheet integration. Could you please refresh the integration by re-integrating your form to google spreadsheet once again? If the issue persists, let us know so we'll try to gather updates from the developers about this issue.

    Thanks and apologies for any inconveniences caused.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 01, 2014 at 03:32 AM

    Hello sophiebeique,

    For some unknown reason, we have received an empty response from you. If you have replied from email, please use the following URL to reply again:  http://www.jotform.com/answers/294297-Some-fields-are-missing-in-Google-Drive-integration#9

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 01, 2014 at 05:07 AM

    Hello,

    I was able to capture your intended message, quoting:

    "I finally understood why fields were missing, it only happens in the renamed columns.  It was however working before but it is an issue now.

    I'll have to let column's title the same that's all."

    Unfortunately, current google api needs constant column names to be able to inject proper data. I apologise for all those troubles around google spreadsheets. However, I will immidiately renew google integration when google enables a better, new version for their integration. 

    We are glad to receive your feedback anytime.

    Kind regards