Auto Number fields provide a method to automatically generate unique sequence numbers when creating new records. This field type is particularly useful when you need to assign a sequential, non-repeating identifier to each record.
To set up an Auto Number field in your table, follow these steps:
In the table view, click the “Add Field” button.
Name the new field and select “Auto Number” as the field type from the dropdown menu.
Once created, this field will automatically assign a sequential number to each new record. These numbers are unique and won’t be reordered even if records are deleted or other operations occur.
When setting up an Auto Number field, you can choose a starting value. For example, if you want to start numbering from “1001,” you can specify this starting value in the field settings.
Auto Number fields are unique, sequential, and cannot be modified. Even after a record is deleted, its number will remain occupied and won’t be reused.