I’m using make row owners for user email in user table, I also would like my admins to have access to all rows in this table. I can create a new row owner table for a single admin email.
Question is, If i have multiple admins, how do I go about this? since I can only put one email in row owner column
As a user “Person 1” with role admin, i can view all rows, but I’ve also set Person 3 as Admin, but have no access to all rows (the rest are greyed out). see below
Check for any additional spaces in the Role. Also, I don’t recommend using the same column for the Role in the user profile configuration and the row owner in the user table. If it was working, a user with an Admin role would only have access to person 1 and person 3. Not 2 or 4. What you should be doing is assigning the admin role to only the admins, and then have a separate column set as a row owner column with the word Admin in every user row. That tells glide that only users with a role of admin will be able to see all rows that have a row owner of Admin.
thanks. I’m able to make it work by not making the role as row owner. instead, i created a new column called “owner”. in this new column, I put a role name whom i want to be able to have access to the rows