# Filtering list by current form data

**URL:** <https://community.glideapps.com/t/filtering-list-by-current-form-data/22096>\
**Category:** Feature Requests\
**Created:** [February 2, 2021, 12:45am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096 "2021-02-02T00:45:06Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [February 2, 2021, 12:45am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/1 "2021-02-02T00:45:06Z")

</div>

Hey Gliders!

There is currently no way to filter a list (that’s in a form) by a form column’s data. In other words:

I want to filter the list by ‘Name’ is included in ‘Form data’.

However, There are only three things I can filter by:

- List Item data
- Logged-in-user data
- Current screen data

Current screen data looks at the screen behind the form, and not the form itself.

Hopefully-this-gets-made-into-a-feature,  
Pablo

---

<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:** [February 2, 2021, 11:15am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/2 "2021-02-02T11:15:21Z")

</div>

I’ve read through that 3 times, and I’m struggling to get it.  
Can you show a real use case example?

(Not suggesting that it can or cannot be done, I just want to understand)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 2, 2021, 11:26am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/3 "2021-02-02T11:26:34Z")

</div>

I think the goal here is to filter a choice component based on a previous choice on the same form (for example, in a form screen, choose your country, next choice is filtered to show possible states/provinces based on the country selection).

I think the issue here is that form data isn’t saved anywhere until the form is submitted. Those choices can’t be used because their answers don’t really “exist” until the form gets submitted and the values are saved to columns. This is why a “pre-form” is used so much for this sort of thing.

The alternative could be to not use a form at all and use the Add Row action to submit filtered choices on the same screen.

---

<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:** [February 2, 2021, 11:34am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/4 "2021-02-02T11:34:23Z")

</div>

Okay, I think I get it.

But if you’re rolling your own forms and temporarily storing input data in USC’s, then this is a total non-issue, right?

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [February 2, 2021, 11:35am UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/5 "2021-02-02T11:35:45Z")

</div>

I started a similar thread. Perhaps it has useful information.

> [@Filter not triggered when screen value changes](https://community.glideapps.com/t/filter-not-triggered-when-screen-value-changes/21956):
>
> I try to filter an inline list by the choosen choice of a choice box and I don’t get it. Is this possible? So when the user changes the choice box the list items should change too.

---

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [February 2, 2021, 4:54pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/6 "2021-02-02T16:54:35Z")

</div>

Not really. I want a search bar to search for users, and then it filters the users by Search is included in Item User Name, and then clicking on the user will set column for the form.

This would help  
a) filter the search  
b) set columns for the form, not the item

---

<div class="post-metadata">

**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\
**Post date:** [February 2, 2021, 6:17pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/7 "2021-02-02T18:17:48Z")

</div>

> [@kyleheney](#):
>
> I think the goal here is to filter a choice component based on a previous choice on the same form (for example, in a form screen, choose your country, next choice is filtered to show possible states/provinces based on the country selection).

You can certainly hide/show components based on a choice in a form that is yet to be submitted, haven’t tried filtering yet (only as I have no sensible data to try with).

I have a form with a choice selector. I have visibility options on 2 choice components which then populate different fields in the database, depending on what is selected. This is probably unhelpful though.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 2, 2021, 6:19pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/8 "2021-02-02T18:19:16Z")

</div>

Yes, the visibility isn’t an issue, but it sounds like the ability to filter based on another choice inside the form is where @Pablo_books is having an issue.

---

<div class="post-metadata">

**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\
**Post date:** [February 2, 2021, 6:32pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/9 "2021-02-02T18:32:46Z")

</div>

The only way I can achieve anything similar is to have a search on a list of data, the action is open form and then use the screen data within the form, although I am sure @Pablo_books has already gone down that route.

---

<div class="post-metadata">

**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\
**Post date:** [February 3, 2021, 7:02pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/10 "2021-02-03T19:02:47Z")

</div>

> [@kyleheney](#):
>
> I think the goal here is to filter a choice component based on a previous choice on the same form (for example, in a form screen, choose your country, next choice is filtered to show possible states/provinces based on the country selection).

If I’m interpreting your post correctly, you’re referring to cascading filters, i.e., filtered forms. That’s perfectly doable and resulting choice(s) can be submitted. What’s strange is that visibility settings in a form can’t benefit from the same mechanism that makes that possible.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 3, 2021, 8:52pm UTC](https://community.glideapps.com/t/filtering-list-by-current-form-data/22096/11 "2021-02-03T20:52:51Z")

</div>

Ahh I get it now. My post is likely useless at this point!
