Discussions

 View Only
  • 1.  How to display specific role users in List- user field

    Posted 06-18-2014 14:14

    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.



  • 2.  RE: How to display specific role users in List- user field

    Posted 06-18-2014 14:53
    Alas, there is not a way to get Role information to be used in a formula.


  • 3.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 15:52
    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.


  • 4.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 15:55
    Correct, the formula functions do not currently have the ability to return a list of the Role(s) the current user is in. 


  • 5.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 15:58
    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?


  • 6.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 16:08
    There is an API for Get Role https://help.quickbase.com/api-guide/getroleinfo.html but I have never tried to use it.


  • 7.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 16:19
    That was the one I was thinking of, I have never used it either. Thanks for the info.


  • 8.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 19:05
    One trick that I have had to use is that Dynamic Form Rules DO know what role your user is in. So you can do some sneaky stuff using that. Depending on exactly where you need to be able to access that information, you may be able to get around it. I have a use case where I use form rules to check a box if the user is in one of a subset of roles, and I can use that check box in conditions downstream. Of course that requires that I know my user is going to be in an Add Form on that particular table prior to the point where I need to know what role they were in.


  • 9.  RE: How to display specific role users in List- user field

    Posted 12-13-2018 16:49
    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