This 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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 01-08-2021 09:35
From: Mark Strassel
Subject: 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 field. So, if user's title field shows as Manager, I want them to show in a form dropdown on a timesheet, but not all the other non-manager people. I would like it to be dynamically filtered this way versus a UserList, so as people's jobs change the dropdown will automatically update. I think it's something like If([Employee – Title] = "Manager") but I cannot get it working yet.
Mark Strassel
Project Engineer, T&D
Sturgeon Electric Company, Inc.
3804 E Watkins Street
Phoenix, AZ 85034
480.940.1986 (Main)
480.448.7228 (Direct)
480.753.7913 (Cell)
mstrassel@myrgroup.com
www.sturgeonelectric.com
Confidential and proprietary information of MYR Group Inc. Unauthorized use, disclosure, or reproduction is strictly prohibited.
Please consider the environment before printing this e-mail.