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

[Simon_Warren]

Hi,

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

[Russell_Findlay]

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.

[Simon_Warren]

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 :slightly_smiling_face:

[Justin_Barrett]

Simon_Warren:

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

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)

[Petrowatch]

Autonumber defaults to 1, 2, 3, 4 and there's no way i can see to edit it.

[Petrowatch]

Nevermind, i'll just do it in Excel since its a new table