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: Submission ID's showing as #ERROR! in the integrated sheet

    Asked by slonigiraf on March 28, 2017 at 08:54 AM

    When somebody tryes to edit submission - the edited entry overwrites
    not itself but the first one in spreadsheet. See example form that I created to show
    this bug.
    Integrated spreadsheet
    Please look the attached screenshot.
    It was generated in following steps:
    1. Form created
    2. Integration established
    3. Entered "1" in q1, selected "Option 1" in q2. Submitted.
    4. Entered "2" in q1, selected "Option 2" in q2. Submitted.
    5. Entered "3" in q1, selected "Option 3" in q2. Submitted.
    6. Click on "edit submission" in spreadsheet for entry #2
    q1 changed to 2ed.

    This bug is crucial, please fix it as soon as possible. 

    Page URL:

  • Profile Image
    JotForm Support

    Answered by david on March 28, 2017 at 11:39 AM

    I tested this on my end and the appropriate submission is being edited in the sheet.  I entered 3 submissions: 

    Then clicked the edit link for the second submission and edited that submission:

    The correct submission was updated and the ID's remained the same.  Make sure you clicked on the correct edit link. 

    If this is still not working properly on your end, let us know and we will take another look.

  • Profile Image

    Answered by slonigiraf on March 28, 2017 at 01:40 PM

    Hi David, thanks for prompt reply. Still not working on my side - just try my form and spreadsheet.

  • Profile Image
    JotForm Support

    Answered by david on March 28, 2017 at 02:50 PM

    It looks like the submission ID's are correctly populating to your sheet.  This is causing the incorrect submission ID in the edit links. 

    Try removing the integration and adding it back once again.  With a fresh integration, my submission ID's are being populated in the sheet.  Let us know if they are still showing errors in your form and we will take another look.

  • Profile Image

    Answered by slonigiraf on March 28, 2017 at 02:57 PM

    No David, submission ID goes wrong. Also the same problem exists in all my integrations - I did this example just for showing to Jotform team the bug. It was buggy from the very beginning. Please help and stop arguing that everthing is working. It doesn't. I use jotform for my business and pay money for it. Please fix the bug.

  • Profile Image
    JotForm Support

    Answered by david on March 28, 2017 at 04:14 PM

    It seems there is indeed an error but it was not present due to my spreadsheet being set to English.  The following thread describes the same error, as well as a temporary fix:


    I will forward this to our developers to have a look.  We will let you know as soon as it is fixed.

  • Profile Image

    Answered by slonigiraf on March 29, 2017 at 01:10 AM

    Great! Many thanks.

  • Profile Image
    JotForm Developer

    Answered by Denis on April 11, 2017 at 04:59 AM


    Problem should be fixed now, but you should re-integrate your form with Google. Please check it and let us know if the issue still persists. Also if you need any further assistance please feel free to contact us.