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

    Duplicate entry error

    Asked by nbicket on August 31, 2015 at 08:43 AM

    On resuming my incomplete form, and then finishing and submitting it, I get the following error message. I am testing this before sending it to client

     

    Page URL:
    http://form.jotformeu.com/form/52303081547348

    Screenshot
    message incomplete form duplicate entry
  • Profile Image
    JotForm Support

    Answered by BJoanna on August 31, 2015 at 11:43 AM

    Sorry for inconvenience this may caused you.

    Mentioned issue can not be recreated on our side. It looks like it was a temporary issue.

    Please let us know if the same issue happens again. 

  • Profile Image

    Answered by nbicket on August 31, 2015 at 01:12 PM

    Still no luck. And it takes about two minutes to return this error message.

    Am I doing something wrong with the "first form" (http://form.jotformeu.com/form/52422565368358)

    This is the url for the "Main Form": http://form.jotformeu.com/form/52303081547348

     

    Help!!

     

    Thanks

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on August 31, 2015 at 02:08 PM

    I was able to reproduce the problem, let me report this to our developers

  • Profile Image

    Answered by nbicket on August 31, 2015 at 05:18 PM

    Thank you - look forward to hearing from you

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on August 31, 2015 at 06:24 PM

    Our developers have fixed this issue, if the issue persists in your end, then consider to rebuild the google integration.

  • Profile Image

    Answered by nbicket on September 01, 2015 at 03:29 AM

    The problem is still there. It only applies to this/these forms, not to any others and I haven't done anything different. 

    What does "rebuild the google integration mean" and what do I have to do?

     

    Thanks

  • Profile Image

    Answered by nbicket on September 01, 2015 at 03:58 AM

    Now the response I get on submitting the form is:

    Oops!
    Error on query: 
    Error returned:MySQL server has gone away
  • Profile Image
    JotForm Support

    Answered by Charlie on September 01, 2015 at 09:59 AM

    Hi,

    Apologies for the inconvenience, what my manager meant is that you remove the Google Spreadsheet integration then re-add it again:

     

    Here's the tutorial on how to integrate your Google Spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet. Please note that it will create a new spreadsheet but will load all the existing submissions of the form.

    You can also try cloning your form and see if the cloned form will have the same problem, here's a guide on how to clone it: https://www.jotform.com/help/27-How-to-clone-an-existing-form-from-your-account 

    Do let us know if that works.

  • Profile Image

    Answered by nbicket on September 01, 2015 at 11:13 AM

    Hi, I "disintegrated" Google spreadsheet and now everything's working. Thanks very much for all your help. :)