Form Loading Error when trying to load around 3 737 records populating cascading 5 levels combo boxes

[ugpmsguinee]

I got the error message on screenshot attached when loading a form of arround 3 737 records populating cascading 5 levels combo boxes, please need help

[Kal_Lam]

Do you mean you get this error message when trying to collect data using Enketo? If yes, were you able to collect data with the same in Enketo previously?

[ugpmsguinee]

Error loading hapends when I want to view form (OPEN) in formbuilder or test in enketo online xlsform convertor

[Kal_Lam]

Have you already made submissions or is it a new deployment?

[ugpmsguinee]

It is a new deployment

[Kal_Lam]

Oh, it seems like you have a huge number of choices for the the cascading select (3737 records, which i accidentally missed it out earlier). Have you tried using external selects to cascade a large number of choices. It should load quickly and should also solve your issue.

Would you mind redesigning your cascading select question as outlined in the post discussed previously (it should solve your issue):

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…