So, I’m working on an app where teachers will be able to view only their students in the app, but I also want to give users in the Access column with Admin to be able view any teacher’s students. I have a form button at the top titled “Add a Student”, which upon completion outputs the data in the Student Laptops tab. It automatically collects the teacher’s email address when signed in. So, every single teacher will be using this button to add the students within their classrooms.
So, when teachers are on their particular page, I’m wanting to use filter so that the teacher only sees their students tied to their email address in that tab. But, for the life of me, I can’t get the right combo to achieve what I’m wanting. I even tried using Row Owners, but I can’t seem to get Admins to view students from any teachers in there. What am I missing?
Here’s my quick screencast that hopefully shows what I’ve done and what I’m trying to do.
Thanks for your help!