HR Interface with permissions

The basis of this is to filter based on a User field.

You would filter the record where the User field is or includes the Current User.

This criteria is only available on Interfaces, so this specific filter won't work on the base.

Appreciate that Matt - I can see how to implement that. I'm not sure about the "Only managers should be able to access their team’s reviews" bit, as this is fairly critical in a HR system too

There are a few ways you can implement that, but it all depends on the structure of your data and your requirements.

Option A

If you have a 2nd field that identifies who the employee's manager is.
In this case I would have the filters where either Current User = Employee OR Current User = Manager.

Option B

(Easier but not very elegant) Just make a separate Interface for managers, where data isn't filtered based on user.
There are two main advantages of this approach. 1- If you have a more complex structure, where the manager of a manager needs to view things. 2- you can cater to different use cases because the manager's requirements are different than the employee.

Keep in mind, in Option A you can always tag multiple managers in the employee's record. So let's saw what you need is General Manager, Sales Manager, District Manager, you would tag all 3 of them.

We have all the info in to be able to drive option A - I'm just trying to get my head around how to set the filter up in the way you've said it. Maybe we don't have the platform configured as we need to. I probably need to see the data configured in a table to get a sense of how it would work and I appreciate that might be too much trouble for you. here is how we have ours configured at the moment. I just cant map that into filters in an interface in a way that makes sense to me

For this to work you'll need to change the Employee and the Manager fields type to User.
I can see Manager is a lookup, so you'll need to change it on the source table.

Next, when you filter, you'll choose Specific Records.
Here you would set it where:

Employee Name is Current User
OR
Manager Name is Current User

Yeah I assumed as much, but I can't have these fields as users as they all pull from our master list of employees, which has tons of other info about those employees (salary, date of birth etc) and the primary field can't be a user within Airtable (unless they changed this recently).

Seems a bit of design flaw but as such back to square one

Try this, add a new column to your Master List. Let's call it User, and have this type User.
Then on the new table, have a lookup that references that new column.

Now adjust your filters to filter based off of that.

I set up a filtered view connected to a user field, then used that in an interface so each person only sees their own stuff without changing base-level permissions.