Filtered User Dropdown
I have a few user dropdown selections for say selecting a manager that I would like to filter who is shown in the list based on what is selected for users in another field, for instance a title f...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis can easily be done using a conditional drop-down.
To make this work you need a table of employees which has the employee name and their title. I presume you have that now. And I presume that is where the selection of the employee is coming from.
Then you need to have a table of titles. In theory it can also be a multiple-choice list of titles but the more proper way is to have a table of titles.
You then set the field properties for the related person field to be conditional on first having selected a title.
Here is a link to some help text on conditional drop downs. https://help.quickbase.com/user-assistance/conditional_dropdowns.html
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
To make this work you need a table of employees which has the employee name and their title. I presume you have that now. And I presume that is where the selection of the employee is coming from.
Then you need to have a table of titles. In theory it can also be a multiple-choice list of titles but the more proper way is to have a table of titles.
You then set the field properties for the related person field to be conditional on first having selected a title.
Here is a link to some help text on conditional drop downs. https://help.quickbase.com/user-assistance/conditional_dropdowns.html
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------