How to Add "filter" of List Page from User Profile

[DALEX1]

OK, before you respond… I’ve just read this back and now I think I get it… What I am requesting effectively is an “if” clause before the filter clause… and I can’t put an “if” inside the filter…

So, if USER ACCESS = “Read Only” then filter by “Show on App” = “Yes”… is what I want… but filters don’t do that alone.

So I was thinking visibility rather than filtering and I now get the distinction…

The logic had escaped me. So my bad and sorry for wasting your time (but at least someone in the community will get a laugh from reading this…)

I will look at other options and try the if then else you suggested…

[ap352]

Just FYI a common mistake I was making: There are three distinct steps to enabling user profiles ( User Profiles - Glide Library (glideapps.com). Once I fixed step 3 below I was able to see the signed in User in the Filter dropdown.

1. Go to Settings > Privacy > Public with email / one of the email options
2. Have a sheet with Name, Email, Image
3. [Step I missed] You have to actually go and link your Users sheet to the Profile page in the app. You can do this by Menu > Click on profile > Set the Source to the Users sheet