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

Request Codes (AutoNumber Reset)

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

Hi guys,

Anybody know a way to create proper request codes / references for each row.

For example, my current system is to concantenate a Letter (‘S’ for example) with the product name, then place the year of the request, then add the autonumber ID for reference.

So it comes out looking like: S-MOT-22-1.

However, I would like the last number in this field to reset and start counting again at every new year, and maybe even with every product type.

Ex:
S-MOT-22-1 for the first MOT request of Jan 1 2022

&

S-MOT-23-1 for the first MOT request of Jan 1 2023

1 Reply 1

Lets have a column that is the Date that the record was created and a column for the Product Name

Then we concatenate the following: CONCATENATE("S-",{Product Name},"-",RIGHT(LEFT({Date Created},4),2))

Capture

Capture