Avatar of jalongoria
jalongoria
Flag for Germany

asked on 

MS SharePoint 2013: Concatenated Incrementing Serialization using Calculated Field

All,

Having an issue I can't seem to resolve. I have a SharePoint list I've established that functions as a living log. The purpose is to issue a basic tracking number (six-character prefix+digit combination) and some basic details about execution for backtracking in an audit.

I have established a calculated column called "Order", using the 'single-line-of-text' data type with the following entered in the 'Formula' field:

=CONCATENATE("TCB",REPT("0",3-LEN(ID+1)),ID+1)

Open in new window


The purpose is to serialize, automatically, the tracking number issued based on the ID generated by SharePoint for the line entry.

Unfortunately, the column is generating unexpected behavior. Instead of incrementing the order number by one digit, it merely keeps repeating the same digit with every line entry upon clicking "Save".

That is to say, instead of a sequential list of:

TCB001
TCB002
TCB003
TCB004

Instead, I receive:

TCB001
TCB001
TCB001
TCB001

On every single line item entry. Does anyone know where the flaw may lie? Thank you.
Microsoft SharePoint

Avatar of undefined
Last Comment
jalongoria

8/22/2022 - Mon