Skip to Navigation

Reply to comment

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.


The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit