Hey Airtable Friends!
I have a problem I can’t solve, but I feel like it has to be doable. I would love some help!
Situation: We’re a mortgage company and we keep a database of our Loan Officers and what states they’re licensed in. Those licenses need to be kept up by the employee, so they come and go very often. Each state their own license syntax, so in Airtable, we have 50 text fields, for the 50 states and when a license gets added or removed, someone goes in and types in the license number for the Loan Officer in the corresponding state field, or deletes it from the state field (if it’s removed).
Problem: We very often need to see who all we currently have licensed in X state. But it’s very annoying to sideways scroll through 50 fields - So, how we currently do it is someone adds or removes a license, then they scroll over to a multiple select field and add the state from a drop down. That way we can go to ‘John Smith’ and see that he’s licensed in states, X,Y and Z.
What I can’t solve: I want a way to for the multiple select field to be populated by whether or not a state’s license field is empty or not. So for example, I enter in a California license for ‘John Smith’ in the California License Text Field, and in the multiple select field, CA gets added. In logic that would be:
IF: CA License Field if not Empty
THEN: Select CA from Multiple select.
But for all 50 states.
Is that doable?
Any help would be appreciated.
Thank you!