Admin Access For All

Ask for Help
1

Hi,

I have a screen where if the user is an Admin, they should have access to all records of the same company. If the user is not an admin, they should have access to only the records they created. The admin also needs to have access to the records created by the non-admin. Is there a way to do this with Row Owners? I’d like to avoid filtering as much as possible.

Thanks a lot in advance!

Regards,
Joseph

2

Yes, you can use Roles as Row Owners.

  • Add a Role column in your Users table, and set that as the Role in your User Profiles configuration.
  • Give each of your Admin users a value in that column. eg. “Admin”
  • In any table where you want to restrict access, add two columns and make them Row Owners. One should be an email type and should contain the email address of the user that created the record. The second should be a text type, and should contain the role value of your admin users. eg “Admin”

That’s it.

1 Like