Creating a unique Id in a set format based on information supplied

%3CLINGO-SUB%20id%3D%22lingo-sub-2492207%22%20slang%3D%22en-US%22%3ECreating%20a%20unique%20Id%20in%20a%20set%20format%20based%20on%20information%20supplied%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492207%22%20slang%3D%22en-US%22%3EHello%20I%20need%20to%20create%20a%20unique%20I%E2%80%99d%20that%20will%20for%20a%20new%20row%20created%20on%20a%20share%20point%20list%20based%20on%20the%20information%20selected%20when%20creating%20a%20new%20row.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20drop%20down%20box%20to%20select%20a%20content%20type.%20The%20options%20for%20this%20are%20SVC%20or%20SOCAT%3CBR%20%2F%3E%3CBR%20%2F%3EDepending%20on%20which%20of%20these%20is%20selected%20I%20need%20to%20create%20a%20unique%20I%E2%80%99d%20in%20the%20following%20format.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20SVC%20it%20needs%20to%20return%20the%20following%3CBR%20%2F%3EHL%2Fxxxx%2Fmm%3CBR%20%2F%3Exxxx%20being%20a%20unique%20number%20starting%20at1000%20and%20increment%20if%20for%20every%20new%20SVC%20selected.%3CBR%20%2F%3Emm%20being%20the%20year%20that%20the%20year%20e.g%2021%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20SOCAT%20it%20need%20to%20return%20the%20following%3CBR%20%2F%3EHLSC%2Faaaa%2Fxxx%2Fy%3CBR%20%2F%3Eaaaa%20being%20a%20number%20from%20a%20drop%20down%20box%20selected.%20xxx%20being%20a%20unique%20I%E2%80%99d%20starting%20at%20500%20and%20increment%20if%20every%20time%20a%20SOCAT%20is%20created.%20B%20being%20a%20letter%20selected%20from%20another%20drop%20down%20box.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20would%20be%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2492207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hello I need to create a unique I’d that will for a new row created on a share point list based on the information selected when creating a new row.

I have a drop down box to select a content type. The options for this are SVC or SOCAT

Depending on which of these is selected I need to create a unique I’d in the following format.

For SVC it needs to return the following
HL/xxxx/mm
xxxx being a unique number starting at1000 and increment if for every new SVC selected.
mm being the year that the year e.g 21

For SOCAT it need to return the following
HLSC/aaaa/xxx/y
aaaa being a number from a drop down box selected. xxx being a unique I’d starting at 500 and increment if every time a SOCAT is created. B being a letter selected from another drop down box.

Any help would be appreciated
0 Replies