Population of a dropdown filter ?

[koze85]

Hello I have a project which its records have among others a County and a City field
Every "user" has a County and a city
Now I was wondering is it possible to have 2 filters County and City as dropdowns and the city filter to be populated after the county filter has been selected ??

Now I have 2 filters but they always have all the possible results of my table
is it possible to sort or populate a filter?

Thanks a lot

 

[tanolalano]

You may look in the Help>tutorial. Yuo will find a video in the User profile category. Cascading dropdowns.

 

[koze85]

You misunderstood me I didnt mean in the from view... in the list view I want the filters to function like that

 

[dimoss]

Hi

tanolalano answered correctly. You have to use one list for 'Countrie' and one for 'Cities'. Then you will use one dbjoin for Countries and one cdd for Cities (as a child of Countries). You will make both filters and when on filters side when you select Country it will renders the Cities which belongs in this Country.