How do I auto increment a field in a sharepoint 2010 list?
<p>I have been working on a project for a while and I'm stuck.</p>

<p>I have a form used to add new data to the list. In that form, I have created a number generator that changes based on the criteria a user has selected from several filtered lists. </p>

<p>For example, if I were to ask where Jack lives, the first field would ask what continent he lives on, then the next field filters countries on that continent, followed by time zones, states, and finally cities.</p>

<p>The drop downs would look something like this in the end: North America -> The United States of America -> Mountain Standard Time -> Colorado -> Denver. The number generator concatenates values into a string based on Jack's selection. So North America would populate the generator with a 2, the United States would give 7, and so on until I have a generated number of 27032. I need this number to be completely unique. So in the event that Jill (who also lives in Denver) fills out the form, the generated number will be different from Jacks. </p>

<p>Jack - North America -> The United States of America -> Mountain Standard Time -> Colorado -> Denver - Auto Generated number: 27032</p>

<p>Jill - North America -> The United States of America -> Mountain Standard Time -> Colorado -> Denver - Auto Generated number: 27032 but it auto increments to 27033 since 27032 is already taken. </p>

<p>I understand that the ID field already holds a unique value, but most of the time, the number generator won't populate sequential numbers (this is on purpose and based on the criteria provided). I simply need the generated number to increment if it is already found in the Sharepoint list, and to continue to check (and increment) until the generated number is finally unique, then finally save the incremented number in the list.</p>

<p>The tools I have to make this happen are Sharepoint 2010, Sharepoint Workflows, and Infopath 2010. Any help that you guys can provide would be incredibly helpful. </p>

<p>Thank you,</p>

<p>John</p>