Cascading dropdown list functionality needed

If you aren't speaking german, you can ask for support or post your request here.
Antworten
dkruger
Beiträge: 7
Registriert: 16. Feb 2024, 18:10

Cascading dropdown list functionality needed

Beitrag von dkruger »

What would be the best way to realize the following functionality as part of the Registration form, amongst others: Have a dropdownlist containing 9 Provinces. Upon selecting a Province, a second dropdown list needs to be populated with a list of Districts belonging to that Province only. Upon selecting a District, a third dropdown list needs to be populated with Cities/Towns within that District only. Upon selecting a City or Town, a forth dropdown list needs to be filled with the Suburbs of that City or Town only, also displaying the Postal Code for that Suburb. All of this information is available in DB tables, and the cascading dropdown lists needs to be ideally populated using an appropriate SQL query, to filter the datasets accordingly - we are talking about 9 Provinces, 52 Districts, over 8,000 Towns, with up to 100 suburbs per Town. Any suggestions will be highly appreciated.
Benutzeravatar
fasse
Administrator
Beiträge: 6050
Registriert: 12. Nov 2005, 16:06

Re: Cascading dropdown list functionality needed

Beitrag von fasse »

Depending Drop-Downs are not supported within our structure for profile fields.
dkruger
Beiträge: 7
Registriert: 16. Feb 2024, 18:10

Re: Cascading dropdown list functionality needed

Beitrag von dkruger »

I understand, but would it be possible to achieve this by developing a custom plugin ? Would that be the best approach, or do you have any other suggestions ?
Antworten