SOLVED

Creating a unique id field

%3CLINGO-SUB%20id%3D%22lingo-sub-1295047%22%20slang%3D%22en-US%22%3ECreating%20a%20unique%20id%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295047%22%20slang%3D%22en-US%22%3E%3CP%3EI%20really%20need%20an%20new%20field%20that%20displays%20an%20auto%20generated%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don%E2%80%99t%20want%20it%20to%20be%20the%20built%20in%20ID%20number%2C%20I%20need%20it%20to%20be%20a%20reference%20number%20that%20%E2%80%98concatenates%E2%80%99%20(I%20think%20that%E2%80%99s%20the%20right%20word%3F%3F)%20from%20a%20couple%20of%20other%20fields%E2%80%A6%20For%20example%20the%20First%203%20letters%20of%20the%20client%20name%20plus%20a%20date%20in%20a%206%20digit%20format%E2%80%A6%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20the%20ID%20field%20might%20look%20something%20like%20this%3A%20CLA160420.%20In%20this%20example%2C%20The%20client%20name%20is%20Clarins%20and%20the%20date%20is%2016th%20April%202020%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20give%20me%20an%20idea%20of%20how%20to%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1295047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1295118%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20unique%20id%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295118%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EYou%20can%20create%20a%20Calculated%20Column%20with%20the%20below%20formula%20to%20concatenate%20and%20display%20as%20per%20your%20need.%3C%2FP%3E%3CP%3EFormula%20is%20%3CSTRONG%3E%3DCONCATENATE(LEFT(%5BClientName_Field%5D%2C3)%2CTEXT(%5BDate_Field%5D%2C%22ddmmyy%22))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPlease%20change%20the%20fields%20name%20as%20per%20your%20List%20Columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20please%20refer%20to%20this%20link%20for%20common%20formulas%20for%20Calculated%20Column%20which%20would%20be%20helpful%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexamples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexamples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612329%22%20target%3D%22_blank%22%3E%40andrewmice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20is%20helpful%2C%20please%20like%20it%20or%20mark%20it%20as%20a%20solution%20if%20it%20answers%20your%20query.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted
Best Response confirmed by andrewmice (Occasional 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.