SharePoint2010: Working With Calculated Field/Column in SharePoint 2010 Lists
Although each SP lists has a unique naming convention for each list item. It is called GUID i.e. Globally Unique ID. We can address any item using this id but there are certain scenarios where one needs an auto generating column i.e. a number field that automatically increments after each new item. for instance someone may need a custom ID that constitutes of different pieces of information based on different other columns in the same list. To do that there are certain approach as given below:

- First approach is to reuse the every list's default "ID" column that is incremental and keeps track of the records. One can simply use this column.
- Second approach is to use a column of type "calculated" and then write a formula as illustrated in the image. For further aid, refer to MSDN http://msdn.microsoft.com/en-us/library/bb862071.aspx :

- Jim Adcock has given a ver good example on his blog: http://dlairman.wordpress.com/2011/01/10/add-a-unique-auto-incrementing-column-to-a-sharepoint-list/
- Another Approach can be to create a workflow via SharePoint 2010 designer which would update the list item itself.
Comments
Post a Comment