Skip to Navigation

Reply to comment

And/Or Condition Level

Because I had more than 10 users assigned in various ways to a project (and those users would be in different roles), and therefore couldn't base it off a single UserList combination function (which would only take the first 10 users, I had to use a different workaround.

I needed AND/OR scenarios for access, I used a formula text field to return a value, and then in role permissions for "view" I am able to use [Condition Level] is equal to "Level1 OR Level2 OR etc..."

I've pasted the exact formula below:

Field = Text (Formula) field named "Access Condition Level"
 Formula Used:
[Full Internal Access]=true and [Restricted]=true, "Restricted",
[Full Internal Access]=true and [Restricted]=false, "Unrestricted",
Includes([Project Leads], ToUserList(User())), "LeadAccess",
Includes([Project Support], ToUserList(User())), "SupportAccess",
Includes([Ops Level Access], ToUserList(User())), "OpsAccess",

Then in the Permissions under View I specified Users that could access a project based on what that field returned.

Role A: Unrestricted OR LeadAccess OR SupportAccess
Role B: Restricted OR Unrestricted OR LeadAccess OR SupportAccess
Role C: Restricted OR Unrestricted OR OpsAccess Etc. Hope that helps.


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