Cascading HUGE number of options (Address)

[mkmortera]

I know how to create dynamic options however I am have to create a dropdown of all places in the country (since I dont the expect general public to spell out the correct name of their place, making data cleaning a PITA). The levels are 17 Regions, ~80 Provinces, 146 Cities, 1477 Municipalities and 42046 Towns (Barangay).

The locations are in largest sheet this file: https://psa.gov.ph/classification/psgc/downloads/PSGC%201Q%202021%20Publication%20Datafile.xlsx

Is there a less painful (and time consuming) way to implement this?

And if ever I do how will it affect performance considering that I’m adding 1MB of text in the xlsx, which I guess will be passed on to the webform and increase the page size (Not an actual developer)?

Did anyone ever implemented something like this? How was the experience from the respondent’s side?

Id really appreciate feedbacks.

[Kal_Lam]

@mkmortera, when you have a very long list of cascading select options you could design it through the external csv files. Maybe you could design your xlsform through the select_one_from_file question type as discussed previously:

Select_one choice filter from another select_one

Hi @esmatullaharifi, Welcome to the community! You could design your survey form with the cascading select question to get what you have tried for by following the support article here. As a backup you could also have a look at the post that has a simple workaround that should help you understand the concept of cascading select question: But looking at your xlsform, i see there are more then 800 choices which should affect your data entry performance. Thus a solution for this could be design…

[mkmortera]

Wow, I scoured the docs and never aware of that.

Thank you so much as usual