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?
Autogenerated Numbers
+18Hi @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,
Nathalie
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.