ID's for lines

[Darren_Murphy]

Auto Numbering

Here is how I would do it: [Screen Shot 2020-12-28 at 5.43.18 PM] “Padding” is just a simple ITE… [Screen Shot 2020-12-28 at 5.43.32 PM] So putting all that together, 4 columns required: Rollup to determine the current max order ID Math column to increment that by 1 ITE column to determine how many zeros required for padding Template column to join 2 & 3

I’ve used this method in a few apps now. The only gotcha is that it is subject to a race condition if two or more users happen to be creating a new record at the same time. So definitely not recommended for high volume usage. But if records are added infrequently, then it works fine.