Forum Discussion

JenniferJennif1's avatar
JenniferJennif1
Qrew Trainee
7 years ago

Can the selections from a multiple choice Text field be narrowed based on logged in user's role?

I have a Tasks table with a field called Task Name set as a Text - Multiple Choice field. In the Users section I have defined two different Roles. When a User clicks on the Task Name field to select a...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
Matthew, how does this work when a user views a record which someone else in another Role has entered.  I would be concerned that the drop down would be blank when viewed.
MCFNeil's avatar
MCFNeil
Qrew Captain
7 years ago
Instead of restricting the view, just group the dropdown by the role.  So you'd have all of one at the top, and the other at the bottom.

Just curious, if a formula text field, is using a value from a restricted lookup, does it still show up, or would it be blocked?  Maybe you can convert the dropdown to a formula text field and display that.