# Auto Increment (record number) field

> Every table numbers its records in the built-in Auto Increment field. See where it appears, how the numbers are given, and what changed for older fields.

Source: https://tadabase.com/docs/data/auto-increment  
Status: Verified Nov 17, 2026. Checked against the current product

Every table has a built-in **Auto Increment** field: a whole number Tadabase gives each record when it is created. Use it as a readable record number, or to sort records in the order they were added. You do not need to add it, and you cannot add a new one.

## The built-in fields of every table

Tadabase adds three fields to every table. You cannot edit or delete them.

| Field | What it holds |
| --- | --- |
| **Auto Increment** | The record's number, a plain whole number that is different for every record in the table. |
| **Record ID** | The record's encoded ID, the identifier used in record links and the API. |
| **Created On** | The date and time the record was created. |

On the table's **Records** tab, the Auto Increment column shows the number icon and no name in its header. In workflows, **Auto Increment** is listed with the system fields when you map values, and it is included when you export all fields of a table.

## How the numbers are given

- A record gets its number once, when it is created. Newer records have higher numbers.
- Nobody can type or change the number, in the builder, on a form or in a workflow.
- Deleting a record leaves a gap. The other records keep their numbers.
- The number is unique within one table. Two different tables can both have a record number 15.

> **Need gapless or formatted numbers?:** Because deletes leave gaps, do not use Auto Increment where every number must be used, such as legal invoice numbering. Store such numbers in your own **Number** or **Text** field instead.

## Older Auto Increment fields

Before January 2024 you could add your own Auto Increment fields from the field menu, with a **Starting At** number. That option was removed and replaced by the built-in field on every table, so **Auto Increment** is no longer listed in the **Add Field** window.

Apps that already had such a field keep it. It keeps working: each new record gets the next number after the field's last number, counting on from the **Starting At** value set when the field was created.
