Hi @Quentin,
I would like to recommend a different structural approach to sorting out this issue.
- I assume that your region levels are manageable. So in this case you would need to have a region based skip which would allow you to divide the subsequent divisions into different questions which can be routed with a skip routine
- By tricking the app that each list is different, you avoid the processing of a large list. I have done so by ensuring that the listing for each region is different. So you do not need external select but keep all the responses in the choices sheet…
- You will create your cascade starting from the District not from the region, see example below.
Change your regions, districts, community and health posts appropriately. This should work out your issue. Please note if the Regions are still too big, think about the same logic but start the cascade at the Community.
Hope this works out for you.
Stephane
