The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Autogenerated Numbers

posted May 12, 2019 10:21:30 PM

Topic Labels: Formulas

0 1646 1

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?

1 Reply 1

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