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.
ERROR with auto increment field - Submissions are not found on serverAsked by john.roscoe on May 21, 2014 at 06:31 AM
HELP PLEASE URGENT
All submissione entered today have disappeared from your server. The forms were completed, the automatic email sent (which I have copies of) and the records are in Google spreadsheet, but they are no longer on the Jotform server.
I know your system was down last night when I was attempting to create a new form, and its been up all today, but something serious has happened. I think it is to do with the unique ID field which seems to have allocated a duplicate key and so has lost at least 6 records. I have just entered a dummy submission and it is now working correctly but is re-assigning number that were already assigned.
I need to know how to resolve this urgently as the unique IDs are used as a security barcode. Also I have lost 6 records in the system without trace. I do not want to re-enter them if at all possible.
Here are the records captured in Google spreadsheet - the records in green have been lost off the Jotform server and the last one #2110 just came in a few moments ago and is now auto-incrementing OK.
It also seems the format for date/time has changed - it is no longer recognised as a date/time field by google spreadsheet. (See the last 2 entries in the screenshot above - I cant change their format at all)
I created a copy of your form and made test submissions. Even though the Unique ID field index is 2112 the generated numbers were 1 digit long:
I forwarded this situation to our developers so they can look better into this matter. They will update you via this thread once they have an update on this.
Regarding the submissions issue the system is having a temporary glitch and our developers are already working on the solution.
We apologize for all the inconvenience.
Let us know if further support is needed.
We received the information that the missing submissions situation is solved now. This situation was caused by a problem with data replication. I checked your account and could see submissions after 19th May. Can you please confirm that the situation is solved?
Thank you so much for your patience.
Developers will still look into the Unique ID issue.
Please get back to us if further support is needed.
A data replication problem caused this. The problem is now fixed but unfortunately, it is not possible to fix those auto increment numbers. You will have some double entries.
Thanks for your response - yes the missing records are now back but I have had to delete and re-enter some submissions manually to fix the auto-increment errors.
Unfortunately there are still other problems I have discovered since your 'glitch'. I will start a new thread.
We really do apologize about that and thank you for letting us know. If you are still seeing any other problem areas that might be something we can help with. Then I would advise opening a new thread as you mentioned for that if you get stuck or need to should it be something more problematic. Thanks in advance.
HELP - I dont know whats happening.
As stated above on 22 May I deleted two error records from Jotform and also from Google sheets. Then I re-entered the submissions which allocated a new auto-number which is our security barcode.
Suddenly the two records I had deleted re-appeared a day later. So I again deleted them. Now today they have re-appeard again so instead of 2 duplicates I now have 6! This is getting out of control!
Can I delete them again - or will Jotform re-instate them again?