# Province selection based on country

**URL:** https://community.glideapps.com/t/province-selection-based-on-country/22006
**Category:** Ask for Help
**Created:** [January 30, 2021, 8:40pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006 "2021-01-30T20:40:39Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)
#### Post date: [January 30, 2021, 8:40pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/1 "2021-01-30T20:40:39Z")

</div>

I am using a form to get some input. Among other things it uses a table like below to get the country and province from the user :-

|Canada|Toronto|  
|Canada|Vancouver|  
|Australia|Melourne|  
|Australia|Tasmania|

For Country and province I am using the choice list component. How can I design a filter to uniquely select provinces based on the country already selected on the form. So basically I want to display the provinces relevant to the country in the province list so that one may be selected.  
Thanks.

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 30, 2021, 11:36pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/2 "2021-01-30T23:36:04Z")

</div>

There are quite a few approaches. Have a look at this thread, I think it’s what you are looking for.

> [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932):
>
> [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 
> 
> > **Version 1**
> >
> > \<a href="https://www.youtube.com/watch?v=rtbFccDKuH0"\>https://www.youtube.com/watch?v=rtbFccDKuH0\</a\>

Note: Above method only works with details screen. You could create your own form in a new details screen.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 31, 2021, 12:25am UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/3 "2021-01-31T00:25:11Z")

</div>

You should have a Sheet of choices with Country and Province as columns.

Then only show the country choice at first, show the Province choice when the Country choice is not empty.

Filter the choice values of Province by Country is Screen’s country value.

---

<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: [January 31, 2021, 1:31am UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/4 "2021-01-31T01:31:12Z")

</div>

> [@Ap\_Seh](#):
>
> |Australia|Melourne|  
> |Australia|Tasmania|

I know that’s just an example, but…  
Melbourne (not Melourne) is a City, not a province/state 🙂

---

<div class="post-metadata">

### Author: ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)
#### Post date: [February 2, 2021, 4:05pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/5 "2021-02-02T16:05:07Z")

</div>

Hi Darren,

Sorry, I think it’s just a typo. And right it’s a city. Thank you.

---

<div class="post-metadata">

### Author: ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)
#### Post date: [February 2, 2021, 4:28pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/6 "2021-02-02T16:28:08Z")

</div>

Super good ! It worked !! I was making a small mistake but i was unable to detect it even after hours of work. Your mail helped me solve it. Also this uses the choices element for country and province which I think is better than inline for such selections.

Thanks loads !

---

<div class="post-metadata">

### Author: ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)
#### Post date: [February 2, 2021, 4:29pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/7 "2021-02-02T16:29:13Z")

</div>

Thanks loads or this wonderful link. It’s a big one and quite informative. I’ll try your approach after I go through this in detail.  
Thanks loads !

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/province-selection-based-on-country/22006/8 "2024-01-17T16:53:42Z")

</div>


