Skip to main content

Formula for maintaining sequential row numbering when reordering records

  • April 11, 2017
  • 2 replies
  • 22 views

Forum|alt.badge.img+2

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 replies

  • Known Participant
  • April 11, 2017

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.


Forum|alt.badge.img+2
  • Author
  • New Participant
  • April 11, 2017

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.


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