# Dynamic filter

**URL:** <https://community.glideapps.com/t/dynamic-filter/38851>\
**Category:** Ask for Help\
**Created:** [February 22, 2022, 4:57pm UTC](https://community.glideapps.com/t/dynamic-filter/38851 "2022-02-22T16:57:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@Charlie1](https://community.glideapps.com/u/Charlie1)\
**Post date:** [February 22, 2022, 4:57pm UTC](https://community.glideapps.com/t/dynamic-filter/38851/1 "2022-02-22T16:57:09Z")

</div>

Hi all,

I am trying to create a dynamic filter based on 2 columns. I have a “Bars” table with columns Bar, City, Country and another “History” table that records all of the bars that I went to.  
What I am trying to do is to select the bar based on the country and the city. Selecting the country, the city and the dropdown should automatically show me all the bars in that country and that city.  
Is there a simple way to do that ?

Thanks !

Charlie

---

<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 22, 2022, 5:02pm UTC](https://community.glideapps.com/t/dynamic-filter/38851/2 "2022-02-22T17:02:13Z")

</div>

> **[Screen Values](https://docs.glideapps.com/all/topics/values/screen-values)**

---

<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:** [February 22, 2022, 5:09pm UTC](https://community.glideapps.com/t/dynamic-filter/38851/3 "2022-02-22T17:09:46Z")

</div>

Just want to add…you are writing three choice components to the same column. For this to work correctly, you are going to need to also write the country and city to your history table as well. Otherwise your three choices are going to conflict with each other since you are setting them to the same bar 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:** [February 23, 2022, 5:10pm UTC](https://community.glideapps.com/t/dynamic-filter/38851/4 "2022-02-23T17:10:15Z")

</div>

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