Forum Discussion

VivekVishwanat1's avatar
VivekVishwanat1
Qrew Trainee
3 years ago

Role and Condition based "Add" record Permission?

Hi All, * I have a table "A". * Table "A" is having a checkbox field "C". Current User can Add a new record only if Current User Role = Admin or field "C"=Checked.  --> How to Achieve this in Qui...
Formulas and functions
roles and permissions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
There is a relatively new function called UserRoles

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=201&rl=5i

So, if the Admin Role was 12 (you see that in the URL when you edit the Role) the formula would be

Contains(UserRoles ("ID", "12") and  [Field C] = true

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
VivekVishwanat1's avatar
VivekVishwanat1
Qrew Trainee
3 years ago
Thanks Mark

I implemented the same formula in "Build custom data rules for this table" . It is working.

I can now restrict "Record Add" w.r.t User Login & Condition. 

:)






------------------------------
Vivek Vishwanath
------------------------------