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.
Duplicate entry errorAsked 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
message incomplete form duplicate entry
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.
JotForm Support Manager
I was able to reproduce the problem, let me report this to our developers
Thank you - look forward to hearing from you
JotForm Support Manager
Our developers have fixed this issue, if the issue persists in your end, then consider to rebuild the google integration.
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?
Now the response I get on submitting the form is:Oops!Error on query:
Error returned:MySQL server has gone away
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.
Hi, I "disintegrated" Google spreadsheet and now everything's working. Thanks very much for all your help. :)