
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āFeb 15, 2022 08:55 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āFeb 15, 2022 11:50 AM
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))
