Cascade Uplaod of 300,000 excel rows

[cahi64]

I’m attempting to load a cascade in Formbuilder containing 300,000 Excel rows with Geo-political Zone, State, LGA, Ward, and PU as sub-cascades. However, it fails to load, constantly buffering and hanging. How can I successfully load this cascade into Formbuilder? Are there alternative methods I could use? Please guide me. Thank you.

[pruzige]

Use External Choice List CSV either with search(), pulldata(), autocomplete However , the performance also depends on the efficiency of the devices used. Though am note sure regarding the 300,000 , to me the highest has been 12,500

[Kal_Lam]

Welcome to the community @cahi64! These posts discussed previously (as advised by @pruzige) should be helpful for you to solve your issue:

Cascading Limitation

@dimesh, seems like you have a lot of choices in your cascading select option. Please be informed that in such cases you will need to use the external CSV to list the choices. You could overcome this limitation as outlined in the post discussed previously (using the select_one_from_file question type): Alternatively, you could also overcome this issue by using the select_one_external question type as outlined in the post discussed previously: