How do I number records automatically?
Every table has a built-in Auto Increment number. For a format such as INV-00042, build it in an Equation field with CONCAT and LPAD.
- Verified Nov 22, 2026
- Classic builder
On this page
Every table already numbers its records: the built-in Auto Increment field gives each new record the next whole number, so you don't need to add anything. For a formatted number such as INV-00042, add an Equation field with Text output that builds it from Auto Increment.
Add a prefix or leading zeros #
- Add an Equation field In the Data Builder, open the table's Fields tab, click Add New Field and choose Equation in the Equation group.
- Write the format Type
CONCAT('INV-', LPAD({Auto Increment}, 5, '0')).LPADpads the number to 5 digits with zeros. Pick Auto Increment from the list that opens when you type{. - Save Set Output Type to Text and click Save. Every record gets its formatted number.
Good to know #
- The number counts across the whole table. It does not restart per customer, per project or per year.
- Deleting a record leaves a gap. Where every number must be used, such as legal invoice numbers, keep your own number in a Number or Text field.
- Nobody can type or change an Auto Increment value. See Auto Increment (record number) field.
Was this page helpful?
Something wrong or missing on this page? Tell us.