I have 2 tables:
- Actors (a database of actors sorted by gender [single select], min.age they can play and max. age they can play)
- Actors wanted (a database where directors can input the gender [single select] and age range they are looking for)
I’m trying to run an automation where when a director enters what she/he is looking for, it filters for all qualifying actors and sends an email to all qualifying actors.
Problem: the filter is showing an error. I’ve tried to only filter by age, only by gender but it always responds with an error like " Invalid filter on Min. Age".
Any idea what I can do to make the filter work?