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.
- Verified Nov 17, 2026
- Classic builder
On this page
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.
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.
Was this page helpful?
Something wrong or missing on this page? Tell us.