Formula for maintaining sequential row numbering when reordering records


#1

Sorry for the noobery here but, using “auto number” was working great in my application until a client started re-ordering records. Obviously the auto generated numbers come with the record when you drag them around. How would I write a formula to keep this column set to 1,2,3,4,5,6,7 etc. I tried a few like {record * 1} but I don’t know what I’m doing.

I’m just looking for way to make a field behave like the item index or numbers on the far left of Airtable.


#2

If you can, I’m not sure how. I haven’t really tried yet, so I won’t speak with any real certainty. However, you can convert the field type to text and convert it back to auto number. It’s sort of clumsy, but it works.


#3

Thanks for your response, yes that works. Client is super picky and lazy though, haha.