I’ve created a table to keep track of a list of background extras on a film. The way the columns are currently set up is as follows:
[Character Number] [First Name] [Last Name] [Character] [Scene] [Shoot Day] and so on.
Each person is given a character number, and right now I have that column’s field as Auto-number. We already have records input for all characters that will be in the film, and just need to fill in names. The problem is that some people will have multiple characters assigned to them and we don’t know which people or which characters yet. If possible, I’d like to find a formula to assign a subletter to a record’s [Character Number] when a [First Name] and [Last Name] are input into a record that match an already existing one.
This is how the list would look before a new person is input
My post got flagged for some reason and in the time it took to get reviewed I kept digging around and found a way to do it with automation. Now the big problem is the automation cap for the free tier. Is there a work around to allow more than 100 automation actions/month? I don’t think I’d need 5000 and the boss wouldn’t be willing to upgrade anyway.