Field-level permissions when Current User is Record Owner

Well, there is actually a new function in the last year-ish or so, where for the first time a formula field can detect the Role(s) of the user.

so you can make a formula field called [User is allowed to Edit Part Price] and then have a form rule that says when that field is true (checked) then "Make editable",

the documentation is here
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=gj&rl=cnz

I suggest that you stick to using the Role ID# as you don't want the formula to break just because you renamed a Role.
not tested for Syntax but try this.  You will need to check the Role ID in your app.  They are visible in the URL when looking at a Role.


Contains(UserRoles("ID"), "12"), true // 12 is Administrator
OR
(Contains(UserRoles("ID"), "11") and [Record Owner]=User()) // 11 is Participant


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------