Creating auto increment feild ( or column ) in List in Sharepoint 2007

Jamil haddadin

I want to create a Column in a list ( Custom list ) in sharepoint 2007 that is auto increment ID ( the user is not allowed to add it manually ), how can i do this

thx

Ishai Sagi

Jamil - sharepoint has a built-in ID field that is auto incrementing.The user cannot change it, it starts from one and goes up, and if you delete an item (say #4) there will never be another with the same ID (say #4).

not good enough either develop your own custom field, and write code to connect it to a database with locks and transactions to make sure every item gets an unique value, or use a regular field, hide it from the users (see my utility pack on how to do it) and setup a workflow or an even handler to populate the field when an item is added.

Note to forum managers - we need a FAQ section to avoid these kind of questions repeating. this is a FAQ if I ever saw one!.