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.