Google Spreadsheet integration - non-english characters are blocking submissions syncing

  • Profile Image
    brunopereira
    Asked 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

  • Profile Image
    Mike_T
    Answered 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
    aytekin
    Answered 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
    brunopereira
    Answered 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
    EltonCris
    Answered 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
    brunopereira
    Answered 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
    liyam
    Answered 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
    brunopereira
    Answered 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
    brunopereira
    Answered 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
    EliezerN
    Answered 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
    liyam
    Answered 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.