General

Re: Employee ID - unique

Tinker — Mon, 23 Apr 2012 14:13:44 GMT

yes I know - but if I want the employee ID to start with e.g 2000?

Re: Employee ID - unique

ErnestoM — Mon, 23 Apr 2012 13:40:32 GMT

This is an internal feature in SharePoint. Every list has an ID column which autoincrements for each item submitted.

Re: Employee ID - unique

Tinker — Mon, 23 Apr 2012 13:37:21 GMT

Submitting to a SP list ..can you tell me how to autoincrement

Re: Employee ID - unique

ErnestoM — Mon, 23 Apr 2012 13:14:29 GMT

Where is the form submitting to? If submitting to a SharePoint form library, these have an ID column which autoincrements and could probably work as a unique employee ID within the library.

I believe that tou definitely want it to generate on submit. If two users open the form simultaneously, and the form opens and assigns them the next available ID, then they'll end up creating duplicates when they submit.

Employee ID - unique

Tinker — Mon, 23 Apr 2012 09:32:55 GMT

Got a form with a field that is suppose to be the employee ID How do I auto generate this - starting from 500000? Which is best - auto generate it on submit or on form load? How can I ensure that 2 end users don’t creates the same Employee ID?