Forum Discussion
MarkShnier__You
2 years agoQrew Legend
One option is to use the UserRoles function. https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=201&rl=e73 It returns the name and the number if all the Roles a user us in.
You can make a formula checkbox field called [User is in a High Level Role?]
var test MyRoles = ToText(UserRoles(""));
Contains($MyRoles, "ADMIN")
or
Contains($MyRoles, "ANNETTE")
or
Contains($MyRoles, "GARRYD")
then you can have a filter on the report that says,
any
[User is in a High Level Role?] Is checked
or
project manager is the current user
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- BuildPro2 years agoQrew Captain
Mark,
I am getting an error message when I paste your formula in my app.
------------------------------
BuildPro
------------------------------- MarkShnier__You2 years agoQrew Legend
change the word test to text
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- BuildPro2 years agoQrew Captain
Perfect! thank you
------------------------------
BuildPro
------------------------------