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 : 



  • Another Approach can be to create a workflow via SharePoint 2010 designer which would update the list item itself.

Comments

Popular posts from this blog

SPFx: Develop using SharePoint Framework without Installing all the dependecies.

SharePoint Online: Elevated Permissions....with love

Powershell: Filling up an Existing Excel Sheet with data from SQL Server