Can't view my cascade list

[youssouphasarr]

help me.ADMIN14.xlsx (361.7 KB)

[Kal_Lam]

Have you gone through our support article Adding Cascading Select Questions. It should help you solve your issue.

In the meantime would also advise you to have a look at a simple workaround that should help you better understand the concept of a cascading select question. You could follow the same here:

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] …

And also follow a bit complicated cascading select here:

How to create a multi layer cascading select question?

Hi @PALASH9698, Please see the revised/updated cascading selects based on your added information. In the survey tab of the xlsform: [Image 1] In the chocies tab of the xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Palash Selected Villages.xlsx (18.0 KB) Have a great day!

Having looked at your xlsform i could see that you have a lot of choices in your cascading select questions. This could slowdown your form loading and data collection process. You could thus use the select_one_from_file approach to overcome these issues following the instructions outlined in the post discussed previously:

Pre-loading csv files in KoBo to cascade select

Welcome to the community @isaacmugabo! You could do the same as outlined in the images shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the csv file: state code [Image 3] In the csv file: district code [Image 4] In the csv file: village code [Image 5] Data entry screen as seen in Enketo: [Image 6] Reference xlsform: select_one_from_file.xlsx (15.7 KB) CSV file (state code): State_Code.csv (245 Bytes) CSV file (district cod…

[lucybattaglene]

Hi @Kal_Lam Im having a similar issue. Trying to add a cascading question following the steps in Adding Cascading Select Questions — KoBoToolbox documentation as I have done before and this time after I enter “done” the examples are empty. Ive tried several times and same issues occurring. Any tips?

[hakan_cetinkaya]

Hello @lucybattaglene,

Can you share a screenshot of your choices list?

[lucybattaglene]

Sure. Attached here from XLS

[lucybattaglene]

I’ve also tried this one.

[hakan_cetinkaya]

Thank you @lucybattaglene,

Can you also share the screenshot of the cascading question from your XLS form?

[lucybattaglene]

Sure sorry- ends up looking like this:

[hakan_cetinkaya]

Hi @lucybattaglene,

Let’s try this: Can you change the province names in your choices to not start with Uppercase Letters,
Torba → torba

Just like they are written in the name section

[lucybattaglene]

Thanks so much for your help- I’ve just tried what you suggested and still coming up the same- any other ideas and I can try them?

[hakan_cetinkaya]

@lucybattaglene

I’ve just tried what you suggested and still coming up the same-

Can you share the new screenshot of your choices list?

[lucybattaglene]

Sure the screenshots in my previous answer were the new outcomes in the form builder and here are the choices in XLS

[hakan_cetinkaya]

Hi @lucybattaglene;

I tried to show the necessary changes you need to do in your screenshot:

What I’m trying to say is your Province column (D Column in your excel) should be same with your Name Column (B column in your excel)

[lucybattaglene]

Oh sorry-Yep have just tried that and the same thing is happening. I’m not sure what the issue is as I have used the cascading feature before and it worked great.

Screen shows here of the XLS and form builder now…

[hakan_cetinkaya]

Hi @lucybattaglene,

The names of the choices can’t contain spacebar instead you can use underscore _ (G column in your excel)

For example instead of writing north santo in your name list, can you try north_santo

Can you make the changes and let me know if that solves your issue?

[lucybattaglene]

Thanks for the pick up- made the change (see screenshots) but same issue. I did just try to do a test version - pasting a table with only 2 provinces and 3 areac answers and weirdly it still ‘translated’ into the huge long list but with the same “empty” sign. Do I need to clear history or memory or something

?

[hakan_cetinkaya]

@lucybattaglene

I did just try to do a test version - pasting a table with only 2 provinces and 3 areac answers and weirdly it still ‘translated’ into the huge long list but with the same “empty” sign.

If that’s the case, it seems the question doesn’t get the version you are trying to paste. Can you delete the question and try to add a new one?

Clearing your cache would also might help.

[lucybattaglene]

thanks I just tried that and also using a different internet browser but same issue. If I do a mock version with limited choices it still translates into the longer list of ‘empty’ results. Any other ideas?

[hakan_cetinkaya]

@lucybattaglene, can you able to change the form via uploading an xls form ?

[lucybattaglene]

I haven’t ever tried this. What are the steps/template and I can give it a go?