Duplicate numbers in auto-increment field

  • Profile Image
    Asked 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:


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

  • Profile Image
    Answered on May 27, 2014 at 10:07 AM


    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.