# Can't Figure Out Particular Combo of Filter and Visibility

**URL:** <https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798>\
**Category:** Ask for Help\
**Created:** [October 5, 2020, 11:42pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798 "2020-10-05T23:42:35Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [October 5, 2020, 11:42pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/1 "2020-10-05T23:42:35Z")

</div>

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](https://drive.google.com/file/d/12CWxK6Kf4xnYiqB3sggK66bKt1U0_R_t/view?usp=sharing) that hopefully shows what I’ve done and what I’m trying to do.

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [October 5, 2020, 11:50pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/2 "2020-10-05T23:50:06Z")

</div>

How about creating a relation of teachers to students and then building your inline list based on that relation? There may not be any filters needed!

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [October 5, 2020, 11:54pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/3 "2020-10-05T23:54:28Z")

</div>

How could I set that up? I mean, I know how to do a relation to make that work. But, I’m not really wanting to have a separate tab with 900 students in it, in addition to the tab that’s collecting data from the form. I’d rather it just be in that Student Laptops tab, which is only having rows added to it when teachers complete the Add a Student form, and then filter students that are tied to the teacher’s email address, with only Admins being able to view all students in any teacher’s class. That’s possible, right?

Seem like I’m missing something simple here…

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [October 6, 2020, 12:00am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/4 "2020-10-06T00:00:56Z")

</div>

I think if you did an inline list of the relation that relates teachers to students, then filter that list by signed in user (the teacher’s email address), then the teacher’s accessing the tab should only see their own students.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 6, 2020, 12:13am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/5 "2020-10-06T00:13:31Z")

</div>

When teachers add a student, are you also collecting the teacher email? If so, then just filter where teacher email is signed in user OR where a User \> isAdmin Boolean is true

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [October 6, 2020, 12:35am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/6 "2020-10-06T00:35:55Z")

</div>

Yes, teacher emails are being automatically collected through the form. So, I have the filter set to where teacher email is signed in user, but when I try to set Visibility to anyone in the Access column with Admin OR where teacher email is signed in user, the student names disappear. Can’t figure out what I’m missing so that each teacher only sees their students, and then also giving admins the ability to view all students no matter what teacher they’re viewing.

Setting the filter to teacher email is signed in user works great. No problems whatsoever. But, when I go into the app as myself (an Admin), I can’t see those students unless I’m signed in as those specific teachers. It seems that when I try to add in the visibility condition, it breaks completely.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 6, 2020, 12:40am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/7 "2020-10-06T00:40:39Z")

</div>

Is the Access column an array column of emails?

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [October 6, 2020, 12:43am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/8 "2020-10-06T00:43:05Z")

</div>

No, it’s just one column titled **Access** with only a few staff (who are not teachers) having that label next to it. All teachers simply have **User** next to them in the Access column.

![pw2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7d756acf7dcb3d23dce1cf0783053a40c3dd125e.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 6, 2020, 1:01am UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/9 "2020-10-06T01:01:16Z")

</div>

> **[Untitled spreadsheet · Glide · Create Apps from Google Sheets](https://www.loom.com/share/7d60c636617e457db97de4708f54fc9f)**
>
> Check out a video I made via Loom

---

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [October 6, 2020, 2:26pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/10 "2020-10-06T14:26:36Z")

</div>

Huge thanks to @Robert_Petitto and @ThinhDinh for helping me figure out how to set this up the right way!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 6, 2020, 2:28pm UTC](https://community.glideapps.com/t/cant-figure-out-particular-combo-of-filter-and-visibility/16798/11 "2020-10-06T14:28:27Z")

</div>

My pleasure to help as always Spencer.
