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

Adding a numerical ID when a record is created

Topic Labels: Automations
Solved
Jump to Solution
306 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I am trying to set up a work request form, and am stuck on one part. I’m not sure whether I need to use formulas or automations, but I’ve scoured help videos and articles to no avail trying to find what I’m looking for.

I would like to have a numerical Work Order ID (basically a consecutive numerical number) added to a record field as soon as the record is created.

Ideally, I’d love for it to take this form (Year-####), as that’s the current system we use, but I’d settle for just a unique numerical number for each new record created.

I’m sure this is simpler than I’m making it out to be, but any help would be appreciated. Thank you!

1 Solution

Accepted Solutions

Hi Kristen. Here’s Airtable’s autonumber field. You can combine that in a formula field with the YEAR function. However, it’s a basic solution. You may want to format the autonumber field itself to be a set number of digits (maybe with prepended zeros).

YEAR(TODAY())&'-'&{Autonumber field}

See Solution in Thread

2 Replies 2

Hi Kristen. Here’s Airtable’s autonumber field. You can combine that in a formula field with the YEAR function. However, it’s a basic solution. You may want to format the autonumber field itself to be a set number of digits (maybe with prepended zeros).

YEAR(TODAY())&'-'&{Autonumber field}

Thank you! This is exactly what I needed.