How to make add multiple email in a row owner column for admin

Ask for Help
1

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

2

Use Roles.

  • Set the Role column in your User Profiles configuration
  • Assign your Admin users a common role value
  • In your secondary Row Owner column, instead of adding email addresses, add the Admin Role value.

See below for a deeper explanation:

3

Still not working for me, can you help check below?

  • by user profile config you mean this?
    image

  • in users table, i made email and role as the row owner

    image
    image1037×302 25.5 KB

  • 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

    image
    image1055×403 25.1 KB

also I want to have another table with role as the row owner

4

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.

2 Likes
5

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

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.