Forum Discussion
Creating a unique id field
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?
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-2b4e-45ce-b170-bf7ebf6988b3
I hope this is helpful, please like it or mark it as a solution if it answers your query.
Thanks.
1 Reply
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-2b4e-45ce-b170-bf7ebf6988b3
I hope this is helpful, please like it or mark it as a solution if it answers your query.
Thanks.