Help

Display Assignee only under certain conditions

Topic Labels: Base design Data Formulas
310 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shannon_Bradley
7 - App Architect
7 - App Architect

Hello everyone! I'm sure this solution is something really easy staring me right in the face but I just can't see it. I have a  base with several tables that I am linking to, and trying to set up. To start:

Shannon_Bradley_0-1694477193433.png

The Position Table has a large number of jobs in it. My HR crew list links each crew member with all of the positions that they are qualified for (and I have here the results showing as a Lookup)

What I am trying to do is set things up so when choosing an Assignee it will ONLY display the people that are qualified based on who is linked to the Position field. So I can have this:

Shannon_Bradley_1-1694477611807.png

And easily select the people for the Position filtered by qualification. Not sure why I can't think my way through this!

1 Reply 1
Shannon_Bradley
7 - App Architect
7 - App Architect

Updating: The new Dynamic conditional filtering for paid accounts CAN do this, but I would like to know if anyone figured out a way for the smaller pay level accounts?