I need to create a unique ID number of each new project in the follow format 00-0000-000000 where the middle four digits are a number that increments by one for each new project. I have a list called variables with a column called proj_number which holds a single entry which is incremented by workflow each time a new project site is requested. Here is my issue:
In order to increment the number it must be a number field which has compulsory formatting and won't stay in a four digit (0000) format so I need either
- A way to increment a four digit string by 1 using a work flow or
- A way of adding 00s to the number column so that is always four digits long.
any thoughts gratefully received.