Multiple Roles Permissions w/ Parameters
When Quickbase announced they were going to support Multiple Roles per user a while back, I got very excited. I have SO MANY use cases for my app that NEED this feature. Unfortunately the way it was...
Forum Discussion
It's really disappointing how your problem seems to have gone over the head of just about all the other people who replied. I am experiencing your exact problem now, and see it as a huge, huge shortcoming of using multiple Roles with precedence (ordering).
Basically, role precedence only applies for Pages and Forms (and to some degree Reports). But instead of applying the Field access from the single role with the greatest precedence, Quickbase combines all the Field access settings from each Role for the user. This makes Roles fairly useless for controlling access to fields for any user in more than one role.
I think for anybody saying they like the way this works currently, you simply have never tried to set up Access to an app the way that me, the original post, and other people are trying to do. Roles worked wonderful for me for several years, until now, when I finally needed to get more tricky with Access to a particular app.
Please Quickbase, wake up on this one.
Basically, role precedence only applies for Pages and Forms (and to some degree Reports). But instead of applying the Field access from the single role with the greatest precedence, Quickbase combines all the Field access settings from each Role for the user. This makes Roles fairly useless for controlling access to fields for any user in more than one role.
I think for anybody saying they like the way this works currently, you simply have never tried to set up Access to an app the way that me, the original post, and other people are trying to do. Roles worked wonderful for me for several years, until now, when I finally needed to get more tricky with Access to a particular app.
Please Quickbase, wake up on this one.