Creating unique ID's in bulk
Hi, I want users to be able to "book" 99 unique ID's as they please, in my SharePoint List, and it needs to be sequential. So when a user clicks "new" a new row with a bulk of 99 unique ID's are created, which the user can assign to himself. Example: 1. | A00000 to A00099 | Assigned to Jeff 2. | A00100 to A00199 | Assigned to Jeff2 3. | A00200 to A00299 | Assigned to Jeff3 Etc. I will have two others columns where I can designate the number being taken, and who took it. However, for the ID column (see example) I am not sure on how to format it, so that it would produce the sequential ID when a user wants to add a new row (as to book the next 99 new unique numbers). Any immediate ideas? My immediate idea was to manually add a bunch of rows in a single text field, and let users book them, and then manually add new ones when it starts to run out... but I am certain this could be automated. Any help or direction would be appreciated, thanks.