Friday

HOWTO: Creating a Unique ID in a SharePoint List

Today, I needed to create a unique ID for items in a SharePoint list.
I need to have a Unique ID containing Alpha-numeric characters for each item employing the ID of the item.
I wanted the Unique ID to look like CE[ID] where CE is the text string and ID is the item ID.

Solution

  1. Create a column, give it a name (say MembersID)
  2. Select "Calculated" and enter the following formula
=CONCATENATE("CE",[ID])


2 comments:

Louise said...

This approach doesn't work: It throws an error in SP2010. I believe it's because the value [ID] doesn't exist until the record is saved.

tieubinhbinh said...

Thanks, so helpful!