How to display specific role users in List- user field
In my project, there are 4 users with admin role. I want to display these users in List-user field.Actually List - user field displaying all users in the application.
Forum Discussion
- Alas, there is not a way to get Role information to be used in a formula.
- So is there no way to take a current user field and derive the user's role(s) into another field utilizing the native users table in my app? I don't want to recreate information that already exists just to be able to formulate which role(s) a user is assigned to within my app.
- Correct, the formula functions do not currently have the ability to return a list of the Role(s) the current user is in.
- So for any sort of role info (which ones exist in application, which ones a user is assigned to, etc.) you have to utilize API's? or am I missing another method?
- This is course can be done with the new 3A&S technique. Unfortunately I can't provide a public demo as demos with users drain my account quota and can be difficult to maintain over time.
But I have myself listed in a private demo in three roles:
And below is the calculated Roles showing the role name and role ID. I am in using [Roles] field with is a Rich Text Formula Field which implement the 3Q&S technique:
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=709
If you need help implementing this technique feel free to contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt
