Hi everyone — hoping for some guidance on best practices in Airtable.
I have a table with a column that represents a numbered list (1–100). The order matters. When I insert a new record after, say, item #51, I’d like all rows below it to automatically renumber, so the list becomes 1–101 without manually updating each value.
In other words:
-
Current state: rows are numbered sequentially
-
Action: insert a new row in the middle
-
Desired result: all following rows shift +1 automatically
I’m trying to understand:
-
Whether this can be done natively (formulas, views, sorting, etc.)
-
Or if it requires automations or scripting
-
And what the recommended pattern is for maintaining ordered lists like this in Airtable
I’m open to restructuring the field (e.g., using a sort/order field instead of manually entered numbers) if that’s the right approach.
Any examples, tutorials, or best-practice patterns would be greatly appreciated. Thanks in advance!
