Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Base design
1198 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

3 Replies 3

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.

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)