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

Autogenerated Numbers

Topic Labels: Formulas
739 1
Showing results for 
Search instead for 
Did you mean: 


I am wanting to create autogenerated Job numbers for new projects. The sequence for job numbers is JXXX (where the x’s denote a unique job number.

Does anyone know how to do this on Airtable?

1 Reply 1

Hi @maddie_shackell,

Welcome to Airtable!! :smiling_face_with_three_hearts: Heart

Assuming you already have a column with an Autonumber (let’s call it AutoID), you’re formula would look like this;

CONCATENATE("J",RIGHT("000" & {AutoID}&"",3))

Enjoy your day,