Auto Numbering

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