# Filter Inline list with 3 Conditions

**URL:** <https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120>\
**Category:** Ask for Help\
**Created:** [April 29, 2020, 7:37pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120 "2020-04-29T19:37:15Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [April 29, 2020, 7:37pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/1 "2020-04-29T19:37:15Z")

</div>

How to Filter a list with a few logical operators? like (and and )or

I want to filter by signed User and date Or if no sign up then don’t filter

---

<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:** [April 29, 2020, 7:44pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/2 "2020-04-29T19:44:40Z")

</div>

Just add additional conditions!

 ![Glide_·_Create_Apps_from_Google_Sheets-2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/04607dd3d013a25c5d7bb39fa85888ab8e537546.png)

---

<div class="post-metadata">

**Author:** ![Petr\_Shemyagin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petr_shemyagin/32/59902_2.png) [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)\
**Post date:** [April 29, 2020, 7:57pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/3 "2020-04-29T19:57:56Z")

</div>

Hello. I understand what you are talking about. It seems to me that it is impossible now.

I can suppose this solution:  
Make two inline lists, one of them will be visible only for signed user and it will be filtered specifically for them. The other one will be visible for those who is not signed and it will not be filtered.

Maybe there are more elegant solutions but it is the one that I came up with right now.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [April 29, 2020, 7:59pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/4 "2020-04-29T19:59:28Z")

</div>

Hey Robert,

If you add another condition it will have the same operator as the previous one.  
As you can see in my question i need to use both “or” & “and”.

Is there a way to do that?  
I I should use a sheets formula?

---

<div class="post-metadata">

**Author:** ![louisdv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/louisdv/32/5723_2.png) [@louisdv](https://community.glideapps.com/u/louisdv)\
**Post date:** [April 29, 2020, 8:00pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/5 "2020-04-29T20:00:31Z")

</div>

Yes, I do it that way also.  
I have an app with 2 types of users and I need to make each time 2 inline lists with visibility conditions for each.

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [April 29, 2020, 8:01pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/6 "2020-04-29T20:01:20Z")

</div>

Thanks a lot

---

<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:** [April 29, 2020, 8:03pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/7 "2020-04-29T20:03:38Z")

</div>

Ah…gotcha. Yeah…You might need to use a template column that combine the “ands” and then use that as one of your conditions. Then use the OR in the actual filter.

If that doesn’t work, create two lists and set the visibility conditions to only display for signed in user or not.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 29, 2020, 8:05pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/8 "2020-04-29T20:05:14Z")

</div>

Read from this post to the end of the thread.

> [@BUG in visibility](https://community.glideapps.com/t/bug-in-visibility/3831/14):
>
> It’s kind of limiting, but I think that’s how it’s designed right now. How are you attempting to check your conditions: (When Color is Blue AND When Switch1 is TRUE) OR When Order isn’t EMPTY It is it like this: When Color is Blue AND (When Switch1 is TRUE OR When Order isn’t EMPTY) I suppose it’s limited to only ANDs or ORs because there is no way to differentiate order of operations with parenthesis. In programming languages, the OR always takes priority it it’s True and no paren…

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [April 29, 2020, 8:17pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/9 "2020-04-29T20:17:50Z")

</div>

It crossed my mind the issue is that you cant use logical operator in a template column  
So no Combinations as you proposed.

Im trying the second idea.  
I made a new tab and made it detail layout.  
Added a list to this layout  
The source of this list is a sheet the using the ARRAYFUNCTION to copy columns and data from other sheet.  
The problem is when i try to condition the visibility of the list he retrieves the properties from a category sheet and not the one I intended to(items). How to fix it?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 29, 2020, 8:25pm UTC](https://community.glideapps.com/t/filter-inline-list-with-3-conditions/8120/10 "2020-04-29T20:25:28Z")

</div>

> [@Double feed button discovery](https://community.glideapps.com/t/double-feed-button-discovery/7871/2):
>
> Enabling favorites will do this automatically, but if you want your own version to work the way you want, then check out [https://6pbvq.glideapp.io/](https://6pbvq.glideapp.io/). For you it comes down creating a sheet and then creating a user specific column in that sheet to hold the choice component value. You will display this sheet as your tab. Based on the the selected choice value you will show one of 2 lists. One that’s filtered and one that’s not. My example app uses a complicated set of relations, lookups and fo…
