I have a request that seems simple but I can’t figure out how to set up.
My company makes YouTube videos, so we have a database with a master table of all our videos. These videos are categorized into channels, which currently there are only two of — so some videos belong to Channel A, while others belong to Channel B. Simple enough.
The function I want to create is a numbering field that automatically assigns a number to each new video. The catch is, I want to customize these numbers so that videos from Channel A count up A-101, A-102, A-103, etc., while videos from Channel B count up with an independent sequence B-101, B-102, B-103, etc.
The Channel gets assigned upon creation, because I keep the database grouped by channel (so that users are forced to click either Channel A or B to create a new record).
It seems like it should be easy enough to either count the matching records, or lookup the value from the previous record and add 1 — but I just can’t figure it out.
Sample database with a manual field for “Video #” — that’s the one I want to automate.