# How to use multi-select filters on an edit screen?

**URL:** https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166
**Category:** Ask for Help
**Created:** [March 29, 2024, 4:47pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166 "2024-03-29T16:47:27Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![mudit](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mudit](https://community.glideapps.com/u/mudit)
#### Post date: [March 29, 2024, 4:47pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/1 "2024-03-29T16:47:27Z")

</div>

I am trying to edit a single cell in a table via an edit screen. On the edit screen I want to get a list of options for “Meal” based on selection of a “health\_tag\_filter\_u” (multiple health tags are linked to each Meal). The “health\_tag\_list” is part of the “meal” table containing health tags for each meal in an array format. This edit screen is on another table/sheet where I am storing “health\_tag\_filter\_u”.  
This works in case of single selection but not in case of multi-selection. Please help for implementing this in multi-selection.

 ![Screenshot 2024-03-29 at 9.28.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/962517c10eab2de2e94f37c3f74ea162ef3789f4.jpeg)

---

<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: [March 29, 2024, 5:12pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/2 "2024-03-29T17:12:31Z")

</div>

I think the problem is because the health\_tag\_filter\_u is formulating a comma delimited list of values, which isn’t an array. ‘High Fiber’ works as a single value, but ‘High Fiber, Vegan’ is also a single value, which doesn’t exist in health\_tag\_list in the meal table. Since Forms do not run computed column values until they are submitted, I think you may need to create a custom form to handle this. That way you can write your filter choices directly to a user specific column in a table, then use a Split Text column to convert it to an array, and finally use that to filter your meal choices.

There is another option where you could use a New Screen instead of a Form Screen. Add a choice component for you filter that writes to a user specific column in either the user profile or in the parent table, then use the Split Text column to convert the choices into an array. Then add a Form Container that would only contain your meal choice component, and set the meal choice filter based on the Split Text array in the parent table or user profile.

---

<div class="post-metadata">

### Author: ![mudit](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mudit](https://community.glideapps.com/u/mudit)
#### Post date: [March 29, 2024, 6:58pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/3 "2024-03-29T18:58:36Z")

</div>

Thanks a lot @Jeff_Hager ! As suggested, I created a custom form and I am able to filter using multiselect - by using split text to first create an array and then relating it to the health tag field in the meal table. Then I use this relation as the source for the Meal choice component.

I would like to use 4 such multi-select filters in the same form. But relation only allows single variable matching - that will give me 4 relation columns. How can I find the common elements in those 4 columns? Or is there any other way to implement this?

---

<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: [March 29, 2024, 7:00pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/4 "2024-03-29T19:00:57Z")

</div>

You can use a Query column instead of a Relation.

---

<div class="post-metadata">

### Author: ![mudit](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mudit](https://community.glideapps.com/u/mudit)
#### Post date: [March 29, 2024, 7:26pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/5 "2024-03-29T19:26:03Z")

</div>

Since I am using multi-select option, I will have to relate the 2 tables on 2 array columns. Can we use a query column to match array columns of 2 tables?

---

<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: [March 29, 2024, 8:42pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/6 "2024-03-29T20:42:53Z")

</div>

I think so. A Query column is kind of like a relation, but instead of matching a single column in each table, you query an entire table and set as many filters as you want. I believe normal filters work well with arrays, so it should be the same within the query column.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [April 5, 2024, 8:43pm UTC](https://community.glideapps.com/t/how-to-use-multi-select-filters-on-an-edit-screen/72166/7 "2024-04-05T20:43:08Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
