Skip to main content
Question

User field: can I limit choices to users of a specific Role?

  • Nov 12, 2022 8:30 AM UTC
  • 0 replies
  • 210 views

Is there any way to have the users shown in a user field limited to users of a specific role?

Use case:

The app has a role called "approvers"

In a form, I want a "Select Approver" field that would be a "user" type field. The selected user would get a notification.

I know I can make a "custom user set", but every time an approver needs to be added or removed, an admin would have to go in and edit the field. This information is already in the app per the role. It would be much better to simply have a field that allows you to select from this list of users with the approver role. 

Is there any way to accomplish this?

------------------------------
Paul Easton
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The answer is basically no.  I suggest you create a table of users where the key field is user and use that as your pick list using a relationship. You can add fields as required to identify attributes of these special users for example if they are approvers.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------