# Filter choice options from multiple Boolean
**URL:** https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535
**Category:** Ask for Help
**Created:** [October 24, 2021, 7:19am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535 "2021-10-24T07:19:14Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 7:19am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/1 "2021-10-24T07:19:14Z")
Hey
Feel like I might be close but the logic is eluding me. đ¤¨
I have a list of events in a drop down choice list. The choice lists below this one contain names that are filtered according to the first selection. I have managed to filter the gender and age but cannot figure out how to also filter according to the specific events that have been checked in the Glide table.
Ideally, only the names of the students taking part in the selected event would be shown in the drop down list.
Is this possible?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 24, 2021, 8:40am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/2 "2021-10-24T08:40:21Z")
Where are you writing the choices from your 1st screenshot to? How do they relate to the 2nd one?
---
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 9:10am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/3 "2021-10-24T09:10:51Z")
The gender is filtered through a name relation, as shown here: 
and the year level is filtered as per the steps in these pics
.
Works well, but I am hoping to use the checkbox info as well.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 24, 2021, 9:12am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/4 "2021-10-24T09:12:33Z")
Iâm not sure if I understand the full structure of your data. Letâs get a simple question done first. When I click the choice under â1stâ in your first screenshot what options do I have?
---
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 9:19am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/5 "2021-10-24T09:19:11Z")
A list of names drops down. These are filtered according to the option selected in the âSelect Eventâ drop down.
The app is for adding points in a competition with multiple events. The â1stâ choice is the person who came first, the â2ndâ is the person who came second etc.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 24, 2021, 9:50am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/6 "2021-10-24T09:50:01Z")
So letâs say I select âYear 4 Girls Long Jumpâ then the choice component would only show those that is a member of âYear 4 Girls Long Jumpâ right? Then the 4 choices are basically to record the event results?
Next, I believe you havenât shown this in your screenshots, how are you letting the users âfilterâ the app? What does that flow look like?
---
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 10:16am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/7 "2021-10-24T10:16:25Z")
> [@ThinhDinh](#):
>
> So letâs say I select âYear 4 Girls Long Jumpâ then the choice component would only show those that is a member of âYear 4 Girls Long Jumpâ right? Then the 4 choices are basically to record the event results?
Yes, thatâs correct.
The events and all the competitors in each event are set by the user in the days before the event begins. The user can set up nominations by going in the athlete list, selecting a student, and then assigning them their events.
And then, once each event is finished, results are entered. Points are assigned accordingly for champions and over house winners.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2021, 10:19am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/8 "2021-10-24T10:19:31Z")
Just looking at this, what I think you might need to do is coerce all those boolean event columns into a single column that you can use as a filter for your student choice components.
You could do this using two extra columns in that same table:
- Firstly, a single value column that would take the value of your user specific column that has the event selection, and cast that across all rows.
- You then add an if-then-else column that looks at that single value and returns the value of the associated boolean column. Something like:
â If single value is âLong Jumpâ, then long jump boolean
â Else if single value is âHigh Jumpâ, then high jump boolean
â etc, etc
You should then be able to use that if-then-else column as a filter, returning only those rows that have a true value.
---
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 10:26am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/9 "2021-10-24T10:26:36Z")
Thanks. I had managed to get all the booleans in a single column and used it as a filter but it was not dynamic. I want it so that any user can change event types without breaking the logic.
Iâll try it as you suggested, cheers.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2021, 10:29am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/10 "2021-10-24T10:29:29Z")
If you do it as I described it should be dynamic, as itâll be driven by the value of the user specific column, which is in turn set by the first choice component.
---
### Author:  [@Dan76](https://community.glideapps.com/u/Dan76)
#### Post date: [October 24, 2021, 10:49am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/11 "2021-10-24T10:49:39Z")
Works! This is brilliant, thanks. đ¤Š
Used the âincludesâ condition instead of an absolute âisâ. Hope this doesnât lead to the wrong data being displayed in some situations, but the other filters should hold it all in place.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2021, 10:56am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/12 "2021-10-24T10:56:44Z")
> [@Dan76](#):
>
> Used the âincludesâ condition instead of an absolute âisâ. Hope this doesnât lead to the wrong data being displayed in some situations,
Just a tip for the future to help avoid this possibility. Use two columns for your choices. A human readable value for display, and then an ID or something for the actual value thatâs written to the user specific column. Then you can be more explicit when referring to the column and not have to worry about typos tripping things up.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [October 25, 2021, 10:56am UTC](https://community.glideapps.com/t/filter-choice-options-from-multiple-boolean/33535/13 "2021-10-25T10:56:58Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.