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

    Google Spreadsheet integration does not work for new entries

    Asked by raidlife on March 15, 2014 at 05:35 AM

    Once again, I have problems with Google Spreadsheet integration.

    My form : http://www.jotform.com//?formID=40426790039354

    It was working fine until several fields were mixed (not in the good columns) in the google sheet. I removed integration, re-created it, and now new submissions are not completely added in the Google spreadsheet. It seems that fields containing accented characters do not fill the google spreadsheet.

    I have removed accented characrters in the header of the google spreadsheet (replacing "é" by "e"), as this method used to work before, but it is not working any more.

    does not work Submissions JotForm mixed fill
  • Profile Image
    JotForm Support

    Answered by Welvin on March 15, 2014 at 12:13 PM

    Hi,

    Our apologies for the trouble and inconvenience this may have cause to you. We do not advise on changing anything on the spreadsheet columns or headers as it may cause the integration to stop from working.

    I can forward this to our developers. But for now, please consider using an English character to your form field labels. After doing this changes, re-integrate the form to Google Spreadsheet. Again, make sure not to change anything on the google spreadsheet sheet columns/headers.

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 18, 2014 at 10:18 AM

    Hi,

    I have looked into the problem and realized that you have 2 or more fields with the same label. Unfortunately current Google integration is not able insert data into the columns with the same header, in which case only the first column is filled. However, we are planning to utilize New Google Spreadsheets api as soon as it is available.

    I apologize for the inconvience.

    Best regards

  • Profile Image

    Answered by raidlife on March 18, 2014 at 01:17 PM

    Thank you for your answer.

    I don't understand why it used to work fine and why this "same label" problem suddenly occurs.

    So you suggest that instead of having 2 fields named "Email" I should use two different fields, Email1 and Email2 for example ?!!

  • Profile Image
    JotForm Support

    Answered by Welvin on March 18, 2014 at 03:16 PM

    Hi,

    Yes, that is correct. You can add the prefix such as "Equipier 1 Email". That should work. Kindly try it and let us know here if there are still issues.

    Thank you for your kind understanding on this matter.