I have a suggestion. First, take a look at this post:
There are several pieces to this solution.
- This will need to be built in XLS and imported to Formbuilder, so make sure you understand this process well. The example above took me 15 minutes to create - start to finish - so maybe try it or one of the other samples.
- Create a spreadsheet of all provinces, districts and communes -in three columns. This will take some time, but there is no way around this. If you have other lists, you may be able to copy and paste portions of the list into your spreadsheet.
- Using your example, you probably have a small number of provinces, so this column should be fine. (Lets assume you have 10 provinces.) However, you have> 100 districts, so find some way to subdivide these logically. For example, north, south, east, west. Add this column between provinces and districts and give the column a logical name. On average, this would be about 25 districts per list, which is manageable. These 25 districts should each have (1000/10) / 4 = 25 communes. Again, this is manageable.
- Label your resultant spreadsheet appropriately and drop it into Formbuilder.
The hard part is probably to logically divide the provinces, but even if the user guesses wrong (chooses north rather than south), the resultant list of districts is relatively small and the user can make another guess if they do not see the desired result.
This breaks down a bit if the user does not know both the district and commune names. But with some creativity, you should find a logical solution. Good luck.
One more thought. Before adding the 4th column, just drop the 3 column list into Formbuilder and see how it looks. Try changing the appearance to horizontal. Maybe you will decide you can live with it as is. The other advantage is that it will prove that you XLS setup is correct before you add another variable.
