Specifying a starting number for an autonumber


#1

I’d like to be able to specify a value to start the autonumber, and even the interval. Of course, I can start at any number I want, as long as I create and then delete as many rows as needed :grin: but a better solution would be welcome!!


#2

@Polen, I agree. This is such a basic and obvious feature to have.

This is important when on-boarding to Airtable from another system. We used to have a manual log (e.g. for purchase orders). With Airtable we can make this on-line, so we want to continue from the next number. This should be simple - but is not.


#3

Was there ever a solution for this? I have just started using this tool. It seems cool but I’m almost 7600 records in. I can’t have autonumber start over at 1


#4

You can use the autonumber field without worrying much-- simply hide it and instead have a calculated field that is 7600 (or whatever number) + {autonumer} (or whatever you called it). That’s one way around it.


#5

Here’s a suggestion. Make 3 columns:

  1. A formula column
  2. An autonumber column
  3. Your desired starting number OR adjustment factor

Then, use column 1 (the formula) to add your column 2 auto number to your column 3 starting number (or adjustment factor).

It’s not as streamlined as your initial feature request, but it IS a work around that should accomplish what you need. (This may vary if you are trying to increment differently than +1, but a formula should still be possible to make this work)


#6

Thanks for the suggestion. This let me to reset autonumbers during testing without breaking formulas :+1: