# Multiple Filters with "Chip Component"

**URL:** <https://community.glideapps.com/t/multiple-filters-with-chip-component/61847>\
**Category:** Ask for Help\
**Created:** [May 17, 2023, 1:29pm UTC](https://community.glideapps.com/t/multiple-filters-with-chip-component/61847 "2023-05-17T13:29:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\
**Post date:** [May 17, 2023, 1:29pm UTC](https://community.glideapps.com/t/multiple-filters-with-chip-component/61847/1 "2023-05-17T13:29:02Z")

</div>

Hi there,  
I’m trying to filter a database using the chip component for an event management app  
I want to filter events by year and if it’s paid or not, so it must be a multiple-selection filter.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a706cbefc92c4ca55130c08b0fc8141e50377ff.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f2fcd5412367932fcd4b4d0bd916359e89736a90.png)

⬇I tried with arrays, and if then else but I don’t know how to achieve my goal 🤷‍♀️

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/58bebef6352f2b9029a624ecae7407aecb8c346b.jpeg)

---

<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:** [May 17, 2023, 2:08pm UTC](https://community.glideapps.com/t/multiple-filters-with-chip-component/61847/2 "2023-05-17T14:08:19Z")

</div>

Firstly, an observation. Your Event column is User Specific.

![CleanShot 2023-05-17 at 21.59.19@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eafffc8440a5b2084d27c1cf473d81333d222899.png)

This means that the data in that column will be different for every user of your App. That may or may not be what you intend. I don’t know.

Okay, the filtering. Several ways to approach it. Here is what I would suggest:

- Firstly, it looks like you’re using a Single Choice component for both Year and Payment Status. This makes things unnecessarily complicated. So I would suggest splitting that into two components - one for the Year and one for the Payment Status. Each should write to a separate User Specific column.
- Next, add two Single Value columns (like you have now) - one for each, that applies the selections to all rows.
- Next, I’m assuming that the Year should be multi-select, and Payment Status should be either/or (single select).
- Create a Split Text column on your Year selection to turn that into an array.
- Create a relation column that matches the array column with the Year column.
- Next, create an if-then-else column:  
– If Single Value Status is not Status, then null (leave empty)  
– If relation is empty, then null  
– Else true
- And finally, apply a filter to your Collection to only show items where the if-then-else column is checked.