How do I use a table of useremails to set certain tables to edit vs read only for everyone else

[tcanelli]

I have a table that has all employees and another table that list the directors and primary and backup liaisons.

I will be using our company domain to authenticate login access but want to limit who can update records based on this second table, so that only the director and primary/backup liaisons can update records for their department. Department is a field in both tables.

I’m really stuck on how to do this.

I know I can take the individual email addresses and list them in the Date > Table > are updates allowed section but I think there may be a better way.

Attached is a screenshot of the columns for the table I want to use for the security filters. They can see all employees regardless of department, but should only be able to update records for their department. Hope that makes sense.

Thanks