Forum Discussion

Qrew Cadet

5 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

BrittanyScheid

Qrew Cadet

Thanks! One question, is there a function/way to check the role assigned to a specific user? Like could I run a function on the Reviewer field (which is a user field) to find out what role they are assigned to? Thanks!

------------------------------
Brittany Zane
------------------------------

MarkShnier__You

Qrew Legend

5 years ago

Hmmmmm, no I do not think there is a way. The only way, is to have a table of users to use in relationships to lull down the user. Then you can add any other fields to that table to be looked up down to the detail records.

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

DanielJohnson2
Qrew Trainee
4 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
  Qrew Legend
  4 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
  ------------------------------