Hello, i am asking about a way to make a selection based on Users that have a Certain Role into the lookup, so essentially i want to make a Dropdown Field that shows all the users that have a certain role, i did some research on my own and found out that there is a built in Role to users Lookup called "User In Role" now i am trying to make it so that the dropdown only shows the Users that has the Role Sales
Right now i am unable to show the dropdown i researched some more and found out that the Display Value is Null, and i cannot select a Lookup as the Display Value, how do i set it so that i can Display the User as Display Value and Filter it by the Role?
Like
It sounds like a better fit for this would be to create your lookup on Contact (instead of User In Role) but to filter that lookup using the Object Business Rules' "Static Filter" so that someone can only select Contacts which have a record in User In Role with the Role "Sales".
See below for how this would be set up, using "System administrators" role instead for demo purposes:
