Autonumber field

The Autonumber field automatically generates unique and incremented numbers for each row. This field is often used as a primary key to uniquely identify each entry in a table.

Overview

The Autonumber field in Baserow automatically assigns a unique number to each new row. Numbers are assigned in ascending order based on the row’s creation date and time.

Users cannot manually change the autonumber values, ensuring data integrity. It works seamlessly within formulas to reference row numbers or create calculated fields.

Add an autonumber field

To add an autonumber field,

1. Click the plus sign + to the right of your existing fields.
2. Select the Autonumber type and name the field. You can add a unique field name in the customization menu.
3. Click Create.

Re-number an autonumber field

Autonumbering always begins with 1. Sorting rows doesn’t affect the autonumber sequence.

Deleting rows creates gaps in the sequence, which are not automatically renumbered.

To re-number rows:

1. Delete and recreate the autonumber field.
2. Convert the field to a different type and back to autonumber.

Related content

• Field overview
• Create a field
• Field configuration options
• Working with timezones
• Date and Time Fields

---

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.