Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Record number field

Topic Labels: Base design
585 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

Thanks,
Javier

4 Replies 4

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.

2021-11-17_09h35_04

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.