Was looking for a way to generate serial number/counter using calculated field, but there doesn't seem to be a way to do this today. Came across a comment by @Kevin Quosig that exactly explained what we were looking for, just wanted to see if anyone else was looking for the same or has a way do this today?
Here's the original comment by @Kevin Quosig
have a special field type of "Serial Number" that has parameters such as
- starting number
- increments (some people need jumps of 1, 5, 10, etc.)
- object to apply to (portfolio, program, project, task)
- number of digits (some folks need a fixed number of digits)
- Leading zeros (if the number of digits needs to be absolute like 0005)
- prefix (to account for alphanumeric internal systems such as A12345 or XY12345)
- suffix (same as prefix above)
- separator (both pre- and post-, to account for A-12345, 12345-B, or A-12435-B)
Needless to say I too need incremental, auto-generated numbers such as:
- Incremental project numbers.
- Incremental Work Order numbers (which in our case are based on Tasks)
- Incremental PO numbers (which are based in a custom form logic)
The omission of such a feature seems out of touch with corporate business users and needs. It's much easier when doing accounting to cite the number than an arbitrary title field which could be too close to the name of another field.
English-language in day-to-day dealings amongst workers and project managers is nice, but managers, directors, HR, and Finance need numeric identifiers that follow some logic.
POST: auto number field - docket numbers
https://experience.workfront.com/s/idea/0870z000000PSAoAAO/detail
