Create an Alphanumeric Row ID and Increment '+1' as I add records


I am new to Airtable, so apologise if this is basic.
I have records:

CR001 record detail
CR002 another record detail

is there a way to auto fill CR003 if i add a new record?

Thanks, Simon

Yes - we use this all the fine for record names.

Our solution may not be the most elegant you get but here it is

1: create a column called autonumber. - this will start a count at the first record of one

2: decide where you want the record number to start - let’s say 900000

3: create a formula that adds the relevant number to your field - so you get a record called 900001,900002 etc - let’s call this customer number

4: the tables name field is another formula - concatenation - so for Employee records concatenate(“employee”, {customer number})

Step 2 and 3 are optional but I like having the same
Length fields and it needs a starting number high enough to make this happen.

1 Like

Hi, thank you.
I’ve got it to work, and agree a bit clunky.

Pity i couldn’t set the character length to the ‘autonumber’ to ‘0000’ and then it would work quite well :slight_smile:

While it would be nice if the autonumber field type would allow for varying lengths, this could be done with a formula field:

RIGHT("0000" & Autonumber, 4)