Dynamic Dropdown Choices based on 2 conditions

I’m trying to make Dropdown choices filtered by a user that is “available” in a list, but also falls under a certain category. I have the DB collecting “available users” and returning them in the dropdown no problem, but I’d like to add a second filter or condition to making the user appear in the choices. Any suggestions?


Maybe you can just add a field in user table as a flag for availability status (yes/no), and other fields for other criterias. Then the DD’s type should be user type and set condition “when … --> choice source (set constraints)…+option caption…” you can set as many conditions as you want

Hope this can help