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.