Add more than 4 levels in cascade

[cispmed]

Good night,

Please inform me how many levels the cascade option allows to add since I am trying to add more than 4 levels and it does not allow it.

Thank you.

[Kal_Lam]

@cispmed, there should be no restrictions with the cascading select as you say as we already have a workaround that shows a cascading select of more than 4 levels discussed in our community previously:

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!

[cispmed]

Good night,

I am generating a cascade list of countries which have more than 10,000 rows and it generates the following error.

Can you please verifying me please.

Attached file in excel.

Thank you.

aZAoqProR7kx9qKRKo4zEA.xlsx (389.3 KB)

[Kal_Lam]

@cispmed, if you have this large a choice list I would recommend you using the cascading select with the select_one_from_file as 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…

[cispmed]

Good Morning,

The drawback is when I try to add more than 10,000 rows, not in the format as such, you can perform the test adding more of those rows since when trying to load the system it is not capable and generates the error that I send them.

[Kal_Lam]

Do you mean adding 10k rows in a CSV file?

[cispmed]

If we have added 10,000 records and the system crashes, then we want you to inform us what kind of limits the platform has.

[Kal_Lam]

Adding 10k records where? Do you mean collecting 10k submissions?

[cispmed]

The response options are 10k, as I send it to you in the following attachment.

additionally, the system is blocked, indicating that it is not able to load the form with so many response options

aZAoqProR7kx9qKRKo4zEA2.xlsx (377.5 KB)

[Kal_Lam]

@cispmed, kindly please be informed that this large a choice list would definitely affect the loading of your survey form. Hence, we recommend using an external choice as shown/shared in the post above (i.e. using select_one_from_file). The external choice would help you lower the loading time of your form.