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

    Submission ID in google spreadsheet appear as ERROR value only

    Asked by aleaguilar1512 on April 04, 2017 at 04:57 PM

    Here's the link so you can check. The previous one was limited to my organization, sorry about that.



    As a precaution, I disabled the clear on submit. I'll retry, but I'd like you to take a look at the spreadsheet. There's a column that shows ERROR on every row.


  • Profile Image
    JotForm Support

    Answered by Kiran on April 04, 2017 at 10:28 PM

    It seems that there is an issue with the integration or an update with the integration might have caused this. Could you try removing the existing integration on the form and reintegrate again to see if the Submission ID is displaying correctly in the spreadsheet? 

    Please get back to us if the issue still persists. We will be happy to assist you further. 

  • Profile Image

    Answered by aleaguilar1512 on April 05, 2017 at 10:18 AM

    Hey Kiran,

    I redid the integration and it keeps showing error. Now, there's another issue with the same integration, it freezes and doesn't update new submissions. It stopped yesterday at 723 subs and I had 1023+ when I rebuilt the integration today it worked, but it keeps freezing.

    any thoughts?

  • Profile Image
    JotForm Support

    Answered by Kiran on April 05, 2017 at 11:34 AM

    I have cloned your JotForm and tried integrating the spreadsheet. I see that the Submission IDs are displayed normally on the integrated spreadsheet at my end. Could you confirm that you are not making any changes to integrated spreadsheet? 

    Also, I have pushed the missing submissions if any to the spreadsheet. Please check and let us know if the issue still persists. We will be happy to assist you further.