If your app is on a Private Plan, you can assign roles to the users in your User Profiles table. You can then use these roles with Row Owner columns to make certain records only accessible to certain users.
This allows you to, for example, give many people the role of ‘Admin’ and then make ‘Admin’ a Row Owner for certain rows. Now, only people with the role of Admin will be able to access those rows.
Just to be clear, Roles still segregate data unless you use a Google Sheet =arrayformula() as part of a Glide array column (copying a Role or an email down all rows), correct?
Simply associating a user with the role “Admin” doesn’t automatically give them access to all rows, right?
Not if it was “cut-down” e.g. 1x role and say 3x applicable users. This would address the requirement to have secure admin functionality, without undue complexity, in a single app.
When you say the records are “accessible to certain users”, does this mean that their user info can be viewed by other users with the proper role, or can be modified by other users? I want user information to be viewed but not changeable by other users and I think this might be fixing that problem. Thx.
Row Owners and Roles ensure that only the data that a user has access to is downloaded to their device. Otherwise all data is transferred to a device even if you are setting filters and conditions to restrict what’s visible or editable. You still would have to set the conditions for visibility or filtering as necessary.
I wonder if it’s that you can assign roles and use them for various things in your app (which you really could do before the roles feature), but just not for row owners, unless you go private.