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 - non-english characters are blocking submissions syncing

    Asked by brunopereira on August 08, 2013 at 02:10 PM

    Hi,

    I have used you Google spreadsheet integration for a couple of months, but lately i found that submissions weren't added any more to my spreadsheet.

     

    I removed the integration and re-connected it, and again it worked for a couple of minutes and then stopped.

     

    Links:

    http://jotformpro.com/form/31876266751968

    http://jotformpro.com/form/31877088272969

     

    Thanks and regards,

    Thiago Lorenzzoni

    t.lorenzzoni@moving.net.br

    Page URL:
    http://jotformpro.com/form/31876266751968

    Screenshot
    Submissions thanks google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Mike_T on August 08, 2013 at 03:58 PM

    Thank you for contacting us.

    According to my tests, the Google Spreadsheet integration can not handle non-english titles on your forms. For example, Usuário and Verificação words are breaking the integration.

    If possible, please using english titles to fix the issue.

    In the meantime, I have forwarded a ticket to our Development Team, to see if we can improve the integration so it can handle other characters.

  • Profile Image
    JotForm Founder

    Answered by aytekin on August 09, 2013 at 11:25 AM

    Because of google spreadsheets API ban issue on Monday/tuesday we received we disabled some features. I now enable this feature back. So, you should get those submissions now. 

  • Profile Image

    Answered by brunopereira on August 12, 2013 at 04:53 PM

    Hi, thank by the answers.

    It is very important for us to integrate with Google Spreadsheet, have some forms that are controlled by spreadsheets in Google, we need your help for this integration work.

    I tested some forms (below) and even removing the accentuation of field titles anyway integration is not working.

    So remove the accentuation of fields is something drastic for us because our Portuguese language would be an error of grammar. But if solve in all cases could temporarily remove the accentuation.

    Links (important):

    CLE: http://jotformpro.com/form/30624201126943

    CLP: http://jotformpro.com/form/30585255748968

    MOVING CHECK IN: http://jotformpro.com/form/31876266751968

    MOVING CHECK OUT: http://jotformpro.com/form/31877088272969

    MOVING ESCALA - VERSAO 4: http://jotformpro.com/form/31896842300960

    Trabalhe Conosco: http://jotformpro.com/form/31116280038949

    Moving Solicitações: http://jotformpro.com/form/30696769137973


    Can you help us?

    Thanks and regards,

    Thiago Lorenzzoni

    t.lorenzzoni@moving.net.br

    Moving | Vinci Park

  • Profile Image
    JotForm Support

    Answered by EltonCris on August 12, 2013 at 07:45 PM

    Hi Thiago,

    I was able to reproduce the problem with one of your form. This is something to do with the symbols or non-english characters on the field labels. This has been working normally before but it seems to have broken again. 

    Anyway, this issue has been on the dev team's list. Once this is fixed, we will let you know here.

    Our sincere apologies for the delayed response and for the inconveniences caused.

  • Profile Image

    Answered by brunopereira on August 13, 2013 at 10:08 AM

    Ok, we were waiting.

     

    Thanks and regards,

    Thiago Lorenzzoni

    t.lorenzzoni@moving.net.br

    Moving | Vinci Park

  • Profile Image
    JotForm Support

    Answered by liyam on August 15, 2013 at 11:16 PM

    Hello  brunopereira.  We've made a fix which might have had some delays before getting updated last weekend which might have not reflected right away early this week. 

    But upon checking your forms, I was able to receive updates to my Google spreadhseet integrations.  It make take a few secords to a few minutes before the spreadsheet gets updated when the form has special characters in the questions (labels). Are you still having issues with your forms?

    Thanks.

  • Profile Image

    Answered by brunopereira on August 26, 2013 at 05:16 PM

    Hi, Liyam.

    I tested the forms below and integration is not working yet.

     

    Forms not working integration:

    MOVING CHECK IN: http://jotformpro.com/form/31876266751968

    MOVING CHECK OUT: http://jotformpro.com/form/31877088272969

    MOVING ESCALA - VERSAO 4: http://jotformpro.com/form/31896842300960

     

    Can you help us?


    Thanks and regards,

    Thiago Lorenzzoni

    t.lorenzzoni@moving.net.br

    Moving | Vinci Park

  • Profile Image

    Answered by brunopereira on August 27, 2013 at 11:02 AM

    We also have a problem with the number of the rows, when we create a new integration the spreadsheet don't load more than 2000 submissions.

  • Profile Image

    Answered by EliezerN on August 27, 2013 at 02:05 PM

    @brunopereiraç

    Thanks for informing us about the persisistance of the issue. This information will help to our developers to solve the issue and to improve the Google spreadsheet integration. so, they will get back to you via this thread once they have information about the progress on this.

    We really appreciate your patience.

    Thanks

  • Profile Image
    JotForm Support

    Answered by liyam on August 29, 2013 at 07:34 PM

    Hello brunopereira.  Can you give a share access link to the spreadsheets integrated to the forms?  I've tried running a submission on a cloned form and I don't see a problem with receiving submissions to the spreadsheet.  The only issue I see is the 2000 row limit issue.

    Will wait for your response.

    Thanks.