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 numbers in auto-increment field

    Asked by ASRA on May 27, 2014 at 08:17 AM

    I have a form used by people to join a sports association. The form contains an auto-increment field which sets a unique membership number for each person who joins.

    Between May 21 and May 24 the auto-increment field gave duplicate membership numbers to 15 newly joined members. See the submissions for the following form:

    http://www.jotform.com//?formID=23047041959960

    I use this field as the unique identifier for our members, so duplicate numbers cause serious problems. Can you please investigate?

    Page URL:
    http://www.jotform.com//?formID=23047041959960

    Screenshot
    Submissions JotForm identifier unique
  • Profile Image
    JotForm Support

    Answered by jonathan on May 27, 2014 at 10:07 AM

    Hi,

    We apologize for the inconvenience caused. 

    I was able to see this issue in your form http://www.jotformpro.com/form/23047041959960  submissions 

    This problem was caused by database replication issue we had previously(which had already been fixed since). Unfortunately, forms that were using Unique ID field was affected by the issue even when the database replication was fixed.

    Since your form Member Number field is a Unique ID field data, it was affected also.

    There is no other method to fix this automatically. 

    To fix it, the only method is to do it manually. 

    First, to fix the Member Number to increment at the correct sequence number, you have to adjust the Current Index# value of the Unique ID field.

    You have to set the Current Index# to correct highest sequence number base on the submissions count.

    Similar to this

     

    Currently the highest Member Number I see on the form submission is "2171" -- this is most probably not correct anymore since there were duplicated number before.

     

    If you are correct when you said that there were "15" duplicated Member Number (or submissions), then, if you add +15 to 2171, the highest Member Number should be now at "2186"

    Put "2186" in the Current Index# value of the Member Number field in your form. This way, the newest submission going forward will have "2187" onward as the new generated Member Number

    --

    To correct the duplicate Member Number in the form submissions, you can edit the submission using the EDIT button in the form submission page.

    Similar to this

     

    You can re-submit the form after editing for the changes to take effect.

    Unfortunately, you will have to do it on all the 15 duplicate Member Number... you can also tell us if you want us to manually do it for you.

     

    Hope this help. Please inform us if you need further assistance.

    Thanks