Im building a database for my business and have gotten stumped trying to make an inventory number that would increase numerically - but only relative to other records with a common field.
Here’s an example:
Currently we manually generate an inventory id that looks something like this: client abbreviation, two digit year, product name abbreviation, and then a quantity.
That looks like this: DD18DO01 which means Dunkin Donuts, 2018, Donuts, and then 01. If we had 3 donuts in our inventory, each donut would have it’s own numerical id at he end (01,02,03,etc…).
I understand how to do this part in airtable, where i’m struggling is in situations where I’d have say: DD18BG01 (BG for bagel), or DD18BC01 (Black coffee) and have each of this different ids increase incrementally in the same table. So if I added a 2 new bagels, I would generate DD18BG02, DD18BG03, etc…
What I seem to be running into is a formula to generate that ID automatically BY product with an increasing number.
Has anyone faced a similar issue?