Auto Number rearranging based on row index?

[Manohar_Manu]

I’m not very sure this is achievable or not.
Basically I want to automatically order all records sequentially all the time even i Reorder them.

I have auto-number field.

when I insert new record anywhere or move existing record I want to maintain the sequence, but that was not happening in Airtable.

Am I missing any formulae or anything else?

[Manohar_Manu]

Yes It make sense, that should work.

Thanks.

[kuovonne]

Rupert_Hoffschmidt:

You will then have to update all records accordingly

Keep in mind that you can update only 10 records at a time using the REST API, with a rate limit of 5 requests per second. If you have a lot of records, that will take a while. Plus, you can get only 100 records at a time to begin with, so if your table might have several hundred records, this whole process could take a really long time.