Duplicate numbers in auto-increment field

  • ASRA
    Asked on May 27, 2014 at 8: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?

    Jotform Thread 383499 Screenshot
    Page URL: http://www.jotform.com//?formID=23047041959960
  • jonathan
    Replied 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 

    Duplicate numbers in auto increment field Image 1 Screenshot 60

    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.

    Duplicate numbers in auto increment field Image 2 Screenshot 71

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

    Similar to this

    Duplicate numbers in auto increment field Image 3 Screenshot 82

     

    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.

    Duplicate numbers in auto increment field Image 4 Screenshot 93

     

    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

    Duplicate numbers in auto increment field Image 5 Screenshot 104

     

    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