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.
Google Spreadsheet integration - Stops Working After Few Days and You Have to Re-establish the integrationAsked by sklayman on May 01, 2013 at 07:15 AM
I have used you awsome 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 days and then stopped.
Could you please look into it?
Forms for example:
Revoking access to the app or resetting some security settings might cause such problem. Are you sure you haven't done anything like that recently?
Where do you susspect those security changes were taken?
Haven't done anything from my side, not in jotform nor in my google drive or chrome browser...
Thank you for the additional information. I think I figured out the cause of this problem. It is related to a known issue with Special Characters such as the language you are using for your forms which is Hebrew and appears as Symboled Lettering and because of this it is causing the form integration to break. I will be notifying our Development Team about your issue and we will get back to you as soon as this problem has been corrected.
I tested it on this form http://form.jotform.us/form/31204515725143 with this Google Spreadsheets Integration here https://docs.google.com/spreadsheet/ccc?key=0AoQfICZ3OH3ldERpNmN2RmI2NWhEakd1UkhiZWZzTUE&usp=sharing.
As you can see 3 tests worked fine and that was when I had the first field on my test form labeled " test a " in english but after I changed that top first field to " מגזין מעריב לנוער חינם ללא התחייבות " with further test information input as " test 1 " this information did not transfer into Google Spreadsheets.
Normal Test w/Google Integration:
Special Character Test w/Google Integration:
Actual Results in Control Panel vs Google Spreadsheet Comparison:
Thanks for looking into it so thouroughly.
Any ETA for fixing this issue?
Thanks again. Your support is awsome as always.
Sorry to say but we can't provide you an ETA to when this issue fixed. But don't worry, one of our developer is already working on this and we will inform you immediately as soon as they sorted this out.
We would like to ask for your patience for the meantime.
Hi i'm brazilian and i have this problem to. Anyone find a solution or temporary solution?
Please check my answer on your thread. http://www.jotform.me/answers/212326
Any news with regard to known issue with Special Characters and spreadsheet integration?
In addition I have made some of the submission pages public (secured with a password).
Although I (admin) have no problem in exporting the files (xls,csv,pdf), my partners who got the passwrod and see the submission, while pressing on the export icons - nothing happens (no matter which format they choose)...
For example: http://www.jotform.com/submissions/30817057844963
Could you please look into it?
It looks like you are looking to make possible for the users to who you share the submissions view page, to be able to download the submission in a file, since this is not possible, right? Since this a different problem from the original one, please open a new thread with a title according to the problem and we will gladly assist you
Thanks! I will.
Anyway, what about the original question? :) (integration with Google spreadsheet is lost with special characters)?
I assume it's not been resolved in your end, have you re-built the integration? Please confirm this, otherwise I'll send a note to the developer in charge