Forum Discussion

BrittanyScheid's avatar
BrittanyScheid
Qrew Cadet
6 years ago

Filter Report Based on User Role

Hi there, I'm still relatively new to Quick Base, but I was wondering if there is a way to filter a report based on the user role.  We have two different levels of staff - Reviewers and Team Leads, a...
Formulas and functions
DanielJohnson2's avatar
DanielJohnson2
Qrew Trainee
5 years ago
Hey Mark,

Do you know if it's possible to add multiple conditions to that IF statement in the formula checkbox field? I'd like it to be true for 3 roles.

Thanks,

Daniel

------------------------------
Daniel Johnson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you mean adjusting tjhis formuila here ..

IF(
Contains(UserRoles("ID"),"12"),true,
Contains(UserRoles("ID"),"13"),true,
Contains(UserRoles("ID"),"14"),true)


then sure


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------