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...
Forum Discussion
Chiming into an old thread for future people searching for similar solutions. Building on Mark's posts, I have a table with a couple dozen user guides. Some user guides are for general audiences, some restricted to admins etc.
Created a multi-text selection field where the options were <Role ID # > - <Role Name> eg 10 - Viewer. Then a checkbox formula field using this formula:
If(Contains(ToText([Role ID]),ToText(UserRoles("ID"))),true)It works to set the report filters to where the checkbox formula is checked, but I prefer to set it at the table permission level with a custom rule on what users can view.
Don't know that I would go to this kind of trouble for a big table - but for small ones, really works nicely as a quick row-level security by user role workaround.
------------------------------
Malcolm McDonald
------------------------------
