Help

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

3790 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon_Warren
5 - Automation Enthusiast
5 - Automation Enthusiast

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

5 Replies 5
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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