Cascade selection does not work

Hello community, greetings.

I have a problem with the cascading options of one of my forms that I have not been able to solve. It works well for two levels (state-municipality) but I cannot make it work for three levels (country-state-municipality), simply selecting “Country” does not display the options for “State” and neither for “Municipality”.
This is how cascading options are created in Excel:
This is what results when I open the form:

As can be seen, despite having selected Country, the other options (state-municipality) do not show any of the options that are expected.

This is how the options are configured automatically:

As much as I have gone through it and tried it in many ways, I cannot make it work.
Thank you in advance for your help.

@jaimesj, this post discussed previously should help you solve your issue:

Hello Kal_Lam

Very grateful for the prompt reply. Unfortunately I have not been able to fix my problem with cascading options. I send the excel document to see if they can tell me where the error is …

pais_estado_mun.xlsx (16.0 KB)

I apologize for the inconvenience and thank you in advance for the help.
Kind regards.

Hi @jaimesj
Did you remove the survey sheet of your XLS form?


1 Like

Hi Stephanealoo

No, the survey sheet is in the same file, the one I sent in this post I extracted for display purposes


Hi @jaimesj
The file you shared does not have the survey sheet. Kindly check on your end too,


1 Like