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 - Stops Working After Few Days and You Have to Re-establish the integration

    Asked by sklayman on May 01, 2013 at 07:15 AM

    Hi, 

    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:

     http://www.jotform.com//?formID=30981658002958

    http://www.jotform.com//?formID=30713829321955

     

    Thansk!

    Submissions JotForm www
  • Profile Image
    JotForm Founder

    Answered by aytekin on May 01, 2013 at 07:24 AM

    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? 

  • Profile Image

    Answered by sklayman on May 01, 2013 at 08:21 AM

    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...

     

    Thanks!

  • Profile Image
    JotForm Support

    Answered by KadeJM on May 01, 2013 at 10:37 AM

    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:

     

  • Profile Image

    Answered by sklayman on May 02, 2013 at 07:20 AM

    Hi,

    Thanks for looking into it so thouroughly. 

    Any ETA for fixing this issue?

     

    Thanks again. Your support is awsome as always.

  • Profile Image

    Answered by pinoytech on May 02, 2013 at 08:14 AM

    Hi,

    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.

    Thank you!

  • Profile Image

    Answered by pedroof on May 02, 2013 at 08:53 AM

    Hi i'm brazilian and i have this problem to. Anyone find a solution or temporary solution?

    Thank You!

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 02, 2013 at 10:27 AM

    @pedroof

    Please check my answer on your thread. http://www.jotform.me/answers/212326

    Thank you!

  • Profile Image

    Answered by sklayman on August 08, 2013 at 09:51 AM

    Hi,

    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?

    Thanks!

     

    Thanks,

    Shai

  • Profile Image

    Answered by jeanettebmz on August 08, 2013 at 11:31 AM

    Hello Shai

    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

  • Profile Image

    Answered by sklayman on August 08, 2013 at 11:37 AM

    Thanks! I will.

    Anyway, what about the original question? :) (integration with Google spreadsheet is lost with special characters)?

  • Profile Image

    Answered by jeanettebmz on August 08, 2013 at 01:23 PM

    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