# 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.

Source: https://tadabase.com/docs/faq/how-do-i-number-records-automatically  
Status: Verified Nov 22, 2026. Checked against the current product

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](https://tadabase.com/docs/data/auto-increment).
