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

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

    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?

  • Profile Image
    Answered 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:


    Alternative Example SpreadSheet:


    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:


    Google Spreadsheet Additional Test: