User Table & Public User Table

Ask for Help
1

Hello I’m working on a project management app where users are grouped into companies/clients and the projects are referred to them. For this reason I need a directory of users where the company admin could set the level of access (let’s say, admin, write, see). I want the admin of a company being able to add and edit the users level of access but at the same time I don’t want to remove row owners to make them able to access the users data.

Any solution to that? I’ve used a public user table that replicates the user table, but I don’t know how to let company admin make edits once the data are confirmed (as what he sees is a copy of users table)

2

You can have multiple row owner columns in a table. One could be for the user and one for the admin.

3

and is it possible to have multiple row owners? An array for the same company?

4

You can use Roles as row owners, and give multiple users the same role.

1 Like
5

Sorry, I didn’t understand that one…How does a row owner works on a field that’s not an email?

6

Review the following:

And also:

2 Likes
7

I should reiterate. You can assign multiple Columns as row owner columns.

1 Like