Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
When creating multiple custom access rules for a role, all conditions must be met. Is there a way to specify an OR instead of AND when creating access rules?
There are two workarounds for this - depending upon what you want to do.
SCENARIO ONE: OR conditions are in the same field.
Say you want one person to see all records where the status is "on hold" OR is "Open." Tackle this within a single access rule. To do so, create a rule.
Within the first dropdown select the Status field.
In the second dropdown select "is".
In the final criteria dropdown, select <other>. A box appears.
Type: On Hold OR Open
OR must be capitalized. (To learn more, please see our Using AND and OR in a Single Filter help topic.)
SCENARIO TWO: OR conditions are in separate fields.
The workaround for this is to create two roles. Create one custom rule in the first role and create the second custom rule in the second role. Then share the application with the user or group twice: once in each role.
This method works because permissions are additive. When a user accesses an application in two roles, QuickBase grants all rights that either role allows. To learn more about how this works and learn what else you need to consider when one user is in two roles, please see our Reorder Role Priorities help topic.