Record number field

You can add an autonumber field which will give you that functionality.

Thanks for your answer.

The autonumber field doesn’t provide the functionality I’m looking for.

When you reorder records with autonumber, the numbers don’t update accordingly.

Hey Javier,

Yeah, the auto-number field could use some improvements.

Here’s an option that Kamille created

You could also use a formula field to generate a unique code for each item. You could use the Record ID and then use another formula field to extract out a portion of the Record ID as your item ID.

Correct. Autonumber only records record count, not record order.

Because Airtable is more database than spreadsheet, records have no inherent knowledge of other records. Order is maintained as you drag records around, but Airtable only makes the order available to scripts that request records from a specific view. While it’s not possible to trigger an automation—which could run a script to number the records based on order—simply by changing the record order, you could trigger such an automation using other means. You could also run a similar script manually from the Apps sidebar.