Number of rows that can be selected using cascade select

[DavidT]

I want to select schools using cascade select for 1300 schools.
Is there a limit on the number of rows for cascade select?
I was getting duplicated issues. As I have so many school names I changed the name to a unique number. Maybe that is what I went wrong.

[Kal_Lam]

If you have a long list a choices, it’s always good to use the external files. This should help you improve the performance of your data entry form.

Maybe the post discussed previously (which uses select_one_from_file) should help you solve your query:

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…

[DavidT]

Thanks for the reply. I have sorted it out. Do could you tell me if it is possible to create a cascade select in more than one language? I think I would need to export the xls file and add the other language under the choices fields.

Anyway, I have rewritten your instructions a little to make them clearer.
https://1drv.ms/w/s!AhfGsxr8hYaRibkD_-NuCjtPSWNuVw?e=5qsysx

[Kal_Lam]

Yes, it should be possible to have multiple languages with a cascading select choices.