# Filter based on customer profile inputs **URL:** \ **Category:** Ask for Help\ **Created:** [April 9, 2020, 7:31am UTC](https://community.glideapps.com/t/filter-based-on-customer-profile-inputs/6654 "2020-04-09T07:31:17Z")\ **Posts on this page:** 1\ **Showing post:** 8
**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:** [April 15, 2020, 2:09am UTC](https://community.glideapps.com/t/filter-based-on-customer-profile-inputs/6654/8 "2020-04-15T02:09:35Z")
@AlfredoZGC For the future, this is a separate topic, so start a new one next time. - You will need a sheet that lists all of the Countries. - You will need another sheet that lists all of the Cities and the associated Country. - You will need a sheet that lists all of the Districts and the associated City and the associated Country. Create a template column that joins the the Country and City into one column. - First create a choice component that points to the sheet that contains your Country list. Select a column to save the selected Country. - Next create a relation column that looks at the selected Country column and links it to the Country in the Cities sheet. - Next create a choice component that uses the relation above to get a list of Cities for the selected Country. Select a column to save the selected City. - Next create a template column that joins the Selected Country and City into one column. - Next create a relation column that uses the template created above and links it to the Country/City template column in the Districts sheet. - Finally create a choice component that uses the relation above to fill it with a list of Districts for the selected Country and City. Select a column to save the selected District. FYI: This will not work in Add/Edit/Form mode. This will only work when View mode when viewing a record in the Detail style view. --- _[View the full topic](https://community.glideapps.com/t/filter-based-on-customer-profile-inputs/6654)._