# Choice Component with Filtering and Screen Feature

**URL:** <https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927>\
**Category:** Ask for Help\
**Created:** [November 26, 2020, 2:21am UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927 "2020-11-26T02:21:04Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 26, 2020, 2:21am UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/1 "2020-11-26T02:21:04Z")

</div>

Hope you are well. I am doing filtering for an app using relations and the Screen feature. The filtering works only when every Choice I am filtering on has a value. If any of the choices I am filtering on is blank then the filtering does not work.

So for example if I filter on three choices and one of them is blank nothing is displayed. Is there way for you to not require a value in the Choice component? I watched a tutorial that has “Any” as part of the data for the Choice component, but I do not want to use this. Just want the Choice to be blank if not selected.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 26, 2020, 11:00am UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/2 "2020-11-26T11:00:32Z")

</div>

> [@Candy\_Phillips](#):
>
> Just want the Choice to be blank if not selected.

I believe that’s the default behaviour.  
Can you provide a screen shot of your filtering setup?

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 27, 2020, 2:42pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/3 "2020-11-27T14:42:53Z")

</div>

Hello Darren,

Thank you for the quick response. I hope it’s not the default or there is a work around. Please see the screen shot attached.

Candy

 ![Filter screen shot.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/940dbe47b57caefcbbb8801f2be87151ac5f7e37.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 27, 2020, 2:56pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/4 "2020-11-27T14:56:54Z")

</div>

I’m not sure if this will get you what you want, but what happens if you change all those filters to use `OR` instead of `AND`?

When you use AND, you won’t see anything unless they’re _ALL_ true.  
With OR, only one of them needs to be true.

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 27, 2020, 7:10pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/5 "2020-11-27T19:10:32Z")

</div>

Hi Darren,

When I use OR it returns the results for each filter and does not return the And value combination of the filter.

For example if I use OR with Choice component Island and select the island of Nassau and Choice component bedrooms selected is 6, it returns every object that has the island Nassau plus every object that has 6 bedrooms instead of only the results that have both the island is Nassau and 6 bedrooms which is what is required.

Candy

---

<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:** [November 27, 2020, 7:38pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/6 "2020-11-27T19:38:25Z")

</div>

I would recommend checking out this thread.

> [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932):
>
> [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 
> 
> > **Version 1**
> >
> > \<a href="https://www.youtube.com/watch?v=rtbFccDKuH0"\>https://www.youtube.com/watch?v=rtbFccDKuH0\</a\>

You will need to restructure your filtering to work differently. Almost backwards, where you create a series of true/false columns in the data to be filtered. Then you can set your filters to look for all True values to determine if the row should be displayed.

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 27, 2020, 8:33pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/7 "2020-11-27T20:33:50Z")

</div>

Thank you! Will check out the tutorial.

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 30, 2020, 5:09am UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/8 "2020-11-30T05:09:02Z")

</div>

Hello. Hope you are doing well. I watched the tutorial and the filtering on True values works! Thank you very much!

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 30, 2020, 5:10pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/9 "2020-11-30T17:10:16Z")

</div>

Hello all,

Hope you are well. Ok the filtering works depending on whether the values are true however after about 5 to 10 seconds the results disappear off the screen and there are no results. 🙁 I am testing on an IPhone. Does anyone know why this is happening and how to correct it?

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [November 30, 2020, 7:52pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/10 "2020-11-30T19:52:34Z")

</div>

Hello. Apologies. The filtering works. I had a second test filter on another tab and it looks like this was causing the problem. Thanks much 🙏🏾

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [December 4, 2020, 1:58pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/11 "2020-12-04T13:58:08Z")

</div>

Hello all. Hope you are well. I have been testing the app a lot by previewing different users. Sometimes the correct filter results come up and sometimes it does not unless I click the hamburger menu to the top right and click the user’s profile? When I click the users profile from the hamburger menu the correct results appear. I am using If Then Else to test if the users Choice matches whatever property column type and if the result is True, then display and if the choice is empty to also display everything. I added column specific to the choice components to see if it would make a difference but it has not and I am also filtering on “email is signed in user”. Thanks for your help. 🙂🙏🏾

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [December 4, 2020, 11:11pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/12 "2020-12-04T23:11:19Z")

</div>

Hello,

Hope you are well. I am vigorously testing the filtering with different users and sometimes it works and sometimes it does not work. 🙁I am using If Then Else columns to check if there is a match between the column entry in the Profile sheet and Rental Listing Column sheet. True if there is a match and also True if Choice component is empty. I also have checkbox components that I am testing True if a match and True if False so listing still displayed. For some reason True is not displaying when the checkbox is unchecked in The Data sheet. True is only displayed when the checkbox is checked.

---

<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:** [December 4, 2020, 11:42pm UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/13 "2020-12-04T23:42:50Z")

</div>

> [@Candy\_Phillips](#):
>
> I am using If Then Else columns to check if there is a match between the column entry in the Profile sheet and Rental Listing Column sheet.

So you have a relation and then an If Then Else?

> [@Candy\_Phillips](#):
>
> I also have checkbox components that I am testing True if a match and True if False so listing still displayed.

What is this part for? You have added a condition to the visibility condition?

---

<div class="post-metadata">

**Author:** ![Candy\_Phillips](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/candy_phillips/32/15840_2.png) [@Candy\_Phillips](https://community.glideapps.com/u/Candy_Phillips)\
**Post date:** [December 5, 2020, 12:22am UTC](https://community.glideapps.com/t/choice-component-with-filtering-and-screen-feature/18927/14 "2020-12-05T00:22:33Z")

</div>

I’m doing some of what Robert P. is doing in his dynamic filtering video. Because I am using two sheets for comparison I am not using the Single Value column, instead selecting User-\> Field1 or Field 2 etc from the Profile sheet to compare with the Value in the Rentals sheet. For example if Property Type in the Rental sheet matches User-\>Property type in the Profile sheet. If these match then True is the value and if the User-\>Property Type field is empty then also True is the value to display unfiltered results. Then I filter by the If Then columns if True in the features of the Inline list.
