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

    googlesheets integration

    Asked by formpartiloe on December 19, 2012 at 05:51 AM

    Hello,

     

    I got some troubles with google sheets integration. in fact, processing integration is successfull but, if I test the form, the new sumissions are not incremented into the google sheets. The only way to retrieve the new submissions is to generate a "rapport " file from Jotform.com but I don't want this option -

    How shall I proceed to have a good integration?

     

    Would you please answer me at sebastien.iloe@gmail.com or indicate when a answer is done, because i can't see when you answer me?isn'it possible to follow our question over the forum?

    thanks a lot

    ps : All my forms are concerned by this problem

    My Forms Submissions JotForm problem
  • Profile Image
    JotForm Support

    Answered by liyam on December 19, 2012 at 08:26 AM

    Hello formpartiloe.  What I'm suspecting here is the accented characters (and/or) degree character for labels on your form. Have you tried using regular a-z characters on your form?

    We'll also do our tests to figure out what's happening.

  • Profile Image
    JotForm Support

    Answered by jonathan on December 19, 2012 at 09:47 AM

    @ formpartiloe

    Hi, I have a similar assumption to what Liyam had already mentioned. So, we suggest to try using English characters only as much as possible on your form's labels

    But I would also like to inform you that I was actually able to integrate your form (a clone) as is, in my google doc spreadsheet.

    You can check the spreadsheet here https://docs.google.com/spreadsheet/ccc?key=0ArHMx2ARJqlrdG11QWhRQ2FQdkoxQ21NNURlLTNiZ3c 

    and the cloned test form here http://www.jotformpro.com/form/23533190836959 

    Please try to double check if during the google account verification process, all are validated succesfully -- as most of the time, an incomplete success in the validation is also the culprit as to why the integration seems to be not working.

    Hope this also help.

    Thanks.

  • Profile Image

    Answered by guest_30012314224029 on January 02, 2013 at 09:36 AM

    Ok many thanks for answering - i found your answer just after submiting a new integration for another form - I use accent charactère because in france we are used to....

    I'm managing formpartiloe et formation iloe but pleased if possible answer me at sebastien.iloe@gmail.com, it would be helpfull to be noticed for your answer.

     

    thanks

     

    sebastien

  • Profile Image

    Answered by raidlife on July 18, 2013 at 03:44 PM

    Have you solved this issue ? My google spreadshhet does not update with new entries. I also used accented characters because in French you have plenty of words using these characters.

    I have already posted this issue on this thread that seems to be broken now: http://www.jotform.com/answers/217510-submissions-not-sent-to-google-spreadsheet

    I reaaly need this form to work proprely asap now. Can you tell me if this will be solved quickly otherwise I will have to turn to another solution asap.

    Thank you 

  • Profile Image
    JotForm Support

    Answered by Welvin on July 18, 2013 at 05:30 PM

    @raidlife,

    The report thread is still currently opened and no updates so far from our developers. It is marked as Important. I would suggest updating that instead of responding to someone else thread.

    As a solution while waiting, I would suggest using English Field labels to your form. That should work in the mean time.

    Thanks