troubleshooting Question
MS SharePoint 2013: Concatenated Incrementing Serialization using Calculated Field
jalongoria
asked on
asked on
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:
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.
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)
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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
This award recognizes a member of Experts Exchange who has made outstanding contributions to the community within their first year as an expert. The Rookie of the Year is awarded to a new expert who has the highest number of quality contributions.