Discussions

Expand all | Collapse all

Role and Condition based "Add" record Permission?

  • 1.  Role and Condition based "Add" record Permission?

    Posted 19 days ago
    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 QuickBase?
    (User should not have permission to Add a new Record in the table, If Role<>Admin and "C"<>Checked)

    Thanks
    Vivek

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


  • 2.  RE: Role and Condition based "Add" record Permission?

    Posted 18 days ago
    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
    ------------------------------



  • 3.  RE: Role and Condition based "Add" record Permission?

    Posted 18 days 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
    ------------------------------