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

    The Google Spreadsheet integration in my form is failing

    Asked by Ger_martinez on June 06, 2017 at 04:56 PM

    Hi!:

    I have integrated my form with sheets (google); all data were sent to sheets but new submissions are saved in jotform but they weren't sent to sheets. 

    I have tried to eliminate the integration in order to make it again and the error appear again, all data are transmited in the configuration but new data weren't sent.

     

    Can you help me?

    Page URL:
    https://form.jotform.co/71534050993861

  • Profile Image
    JotForm Support

    Answered by AIDAN on June 06, 2017 at 06:06 PM

    I have issued a push of all your form submissions into the integrated Google Spreadsheet. Please check again and get back to us if the problem persists.

    Thank you.

  • Profile Image

    Answered by Ger_martinez on June 06, 2017 at 09:43 PM
    The problem persist. I need YOUR help because I can't Work without this data.
    Thanks
    Enviado desde mi iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on June 06, 2017 at 11:13 PM

    Hello Ger_martinez,

    I'm sorry for the trouble caused to you. 

    Have you done any changes in your integrated google spreadsheet? Please note that editing column headers of your integrated google spreadsheet will cause integration to break. I would suggest you to please re-integrate your form with google spreadsheet and get back to us if the issue persists.

    Thank you!

  • Profile Image

    Answered by Ger_martinez on June 06, 2017 at 11:43 PM
    I made three re-integration and the error still appear.
    Let me explain, I deleted the integration, erased the sheet, made the integración again, jotform created a New sheet, sent the data, without any change in the sheet, i submitted a New data but IT wasn't sent to the Sheet, only stored in jotform.
    Gerardo
    Enviado desde mi iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on June 07, 2017 at 02:59 AM

    I could not reproduce the problem when I tried it on a cloned version of your form.

    My test:

    Cloned Form: https://form.jotformpro.com/71570986870974

    Spreadsheet: https://docs.google.com/spreadsheets/d/14TL41-YD5PVVhlbOWd0HlEV4zInd60S8aRWh6d6C_e8/edit?usp=sharing

    Feel free to make a test submission on this form and check the result in the spreadsheet.

    Since your form has over 500 existing submissions, it is possible that JotForm is still syncing the data into the spreadsheet file while you're performing your tests at the same time. This might delay the new submissions.

    Please re-integrate your form again with Google Spreadsheet and allow some time around 10 minutes before you run some tests. Hopefully, this would accommodate the incoming submissions instantly.

    If that doesn't help, you can make a cloned version of your form and integrate it with Google Spreadsheet.

    Let us know if none of the solutions worked for you.