I need to be able to concatenate one static column with a two-letter prefix, say XY, and then the auto-number. Easy, except that I need Airtable to add a variable quantity of zeros before the auto-number such that the output is a 7-digit string: XY00087
Currently auto-number does not offer fixed digit length…
I’d like this same formula to be future-proof, so that I can revise all past Job Numbers when we need to grow into an 8-digit Job Number schema.
All help appreciated!