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
  1. Add a prefix or leading zeros
  2. Good to know

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 #

  1. 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.
  2. Write the format Type CONCAT('INV-', LPAD({Auto Increment}, 5, '0')). LPAD pads the number to 5 digits with zeros. Pick Auto Increment from the list that opens when you type {.
  3. 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.