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

    How can I enable Google Spreadsheet integration with non-English field names (e.g. Trad. Chinese?)

    Asked by sharkera on June 18, 2013 at 09:25 AM

    Hi Jotform,

    I read somewhere that Google Spreadsheets won't allow the new submission to be pushed onto the sheet if the field started with numbers.  I find that the same situation exists for non-English characters as well.  Is there a workaround for this?  Here's a form I created for testing, it only has one Chinese field in it.  No matter what I do, my new submissions won't show up on my google spreadsheet.

    http://form.jotform.me/form/31684068368464

    All I'm looking for really is just to be able to make some notes of my own for each submission that comes in.  We run a printing service where orders will come in through a form, but sometimes we like to make notes of the customers' preferences and other details.  We can't do that using a regular grid report or html report, those are read-only.  Any suggestions?

    non-English field names Submissions JotForm html report grid report
  • Profile Image
    JotForm Support

    Answered by KadeJM on June 18, 2013 at 11:49 AM

    Unfortunately, Our Integration to do this with Special Characters submitting into Google Spreadsheets has been known to have problems happen because of the differentiation in language barriers and the data which breaks the Integration. To my understanding this problem though has been resolved as far as I know. But it is known to break again if the " Field " label/title itself is labeled in a different language and that is what I found breaks it often.

    However, you can actually also manually do this within Google Spreadsheets. What you need to do is make your form and then Integrate it with Google Spreadsheets. Next find the Form Spreadsheet that was created inside Google followed by modifying it and then adding an extra column labeled " Notes " or whatever else you want to name it if you'd rather name it differently then you can use it to gather the data and just make manual notes. The extra column won't affect or be affected by anything else.

    I've created a test example that i've made using what i've mentioned above with a form and google spreadsheet. You will be able to submit data and then add a special character language inside of google spreadsheets. Go ahead and try it out for yourself. I've also given permission to edit it so that you can try it with the Note as well. I've highlighted in blue and the below Alternative Example of the Notes Row I manually added.

     

    Alternative Example Form:

    http://form.jotform.co/form/31684001267853

     

    Alternative Example SpreadSheet:

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

     

    Now in this Additional Test, at first it was working and so were the notes until I changed the Message Field Label in the third field to " 中文大名 " and that is what broke the integration which is why it doesn't work when you attempt to try it in this one. But if you clone this one and rename the Message Label Field to something normal such as English for " Notes " and then use special characters then integrate and use it you will note that it should start to work again. It won't work right now though because I broke it with the label though but you are more then welcome to try editing it if you want.


    Google Form Additional Test:

    http://form.jotform.co/form/31684493336865

     

    Google Spreadsheet Additional Test:

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