Nov 11, 2021 10:47 AM
Hi, I’m new to Airtable, and I’m trying to make a field that registers the record number “1, 2, 3…”. I need it to be able to order items and map this order to a third-party app.
Any idea how to do it?
Nov 11, 2021 12:25 PM
You can add an autonumber field which will give you that functionality.
Nov 17, 2021 06:17 AM
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.
Nov 17, 2021 07:35 AM
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.
Nov 17, 2021 08:54 AM
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.