Auto Numbering

[Darren_Murphy]

@Jeff_Hager

I think to get the left padded zeros, you could take the number, divide by 1000, create a template to lock in the value and replace the decimal with nothing.

Here is how I would do it:

“Padding” is just a simple ITE…

So putting all that together, 4 columns required:

1. Rollup to determine the current max order ID
2. Math column to increment that by 1
3. ITE column to determine how many zeros required for padding
4. Template column to join 2 & 3