Cascading options xls form

[Bertha]

Trying to import an xls form for cascading select questions and i get this error
Import Failed!
Name: Subnational.xlsx
KeyError: 'label'

Cant seem to figure out why

[Kal_Lam]

@Bertha, it’s always good to validate your xlsform with this online validator first to see if there are any syntax issues. The online validator should be able to help you identify the syntax issues from your xlsform.

[Bertha]

Thanks so much.

[Bertha]

So, I have been able to upload, but i cannot edit from the GUI. Kindly advise
Error:
Error loading survey:

cascading choices can only reference one choice list

[Kal_Lam]

@Bertha, seems like you will first have to go through the support article Adding Cascading Select Questions to understand how a cascading select question can be designed. Once you are acquainted with the design, you could download your survey project that should hold the cascading select question and play around to learn how the cascades are coded.

Maybe you could also go through the workaround discussed previously:

Weird behaviour in cascading select

Hi @sumankhanal, Welcome to the community! Seems like you have some coding error within your xlsform. I tried at my end with the information you provided and i got it correct. For details, please see the images below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: Please note, you may not see all the choices in the image as i have hidden it to save space. But you should find all the choices in the reference xlsform shared at the end of this post. [Image 2] …