I’ve tried searching the forums, and while I’ve found posts similar to this, I haven’t quite found the formula that works for me.
I have a Job Number that is based off 3 other fields that I want to automatically generate when the other fields are filled manually.
Job #: 72234-0001-001
Order #: 72234
Line Item: 1
Revision Level: 1
The order number typically does not need zeroes, but the line item fields and rev fields do, the zeros also need to adjust in the event there is lets say 10 line items, the center number still needs to be a 4 digits.
This seems doable, but I haven’t found the correct formula to do this. If anyone knows how to pull this off, thank you ahead of time!!