Skip to main content

Hi,


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?

Hi @maddie_shackell,


Welcome to Airtable!! :smiling_face_with_three_hearts: ❤


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,

Nathalie

Reply


Terms & Conditions