SOLVED

Creating a unique id field

Copper Contributor

I really need an new field that displays an auto generated ID.

 

I don’t want it to be the built in ID number, I need it to be a reference number that ‘concatenates’ (I think that’s the right word??) from a couple of other fields… For example the First 3 letters of the client name plus a date in a 6 digit format…

 

So, the ID field might look something like this: CLA160420. In this example, The client name is Clarins and the date is 16th April 2020

 

Can anyone give me an idea of how to achieve this?

1 Reply
best response confirmed by andrewmice (Copper Contributor)
Solution

Hi,

You can create a Calculated Column with the below formula to concatenate and display as per your need.

Formula is =CONCATENATE(LEFT([ClientName_Field],3),TEXT([Date_Field],"ddmmyy"))

Please change the fields name as per your List Columns.

 

Also, please refer to this link for common formulas for Calculated Column which would be helpful - https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

 

@andrewmice 

I hope this is helpful, please like it or mark it as a solution if it answers your query.

Thanks.

1 best response

Accepted Solutions
best response confirmed by andrewmice (Copper Contributor)
Solution

Hi,

You can create a Calculated Column with the below formula to concatenate and display as per your need.

Formula is =CONCATENATE(LEFT([ClientName_Field],3),TEXT([Date_Field],"ddmmyy"))

Please change the fields name as per your List Columns.

 

Also, please refer to this link for common formulas for Calculated Column which would be helpful - https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

 

@andrewmice 

I hope this is helpful, please like it or mark it as a solution if it answers your query.

Thanks.

View solution in original post