Hi,
I’m setting up cascading select questions for regions, provinces and municipalities/cities in the Philippines. The problem is that the National Capital Region has no provinces. Only cities. How do I go about setting up the cascading select question?
Thanks for any help.
Vik
Hi @techremote.opc and welcome back!
I would suggest creating a Province labeled something like N/A (Not applicable) or any other term that your users would not confuse.
This way you wouldn’t deal with the tedious work.
You’re right. I haven’t thought about this obviously simple solution. Thanks!
Another option would be to filter the following steps of the cascade by a relevant clause to exclude the Capital region case. I.e. only if ${VariableNameRegion} != “ChoiceNameOfCapitalRegion” and ${VariableNameRegion} != ‘’), the Province and Municipality parts would be active.
The result would be that these variables would be empty in the dataset for the Capital region case. If you don’t want this you might need to follow an approach like hakan_cetinkaya described.
