Hi @hadil
Looking at your form, I notice the following
- For countries on the choices sheet, I see all the countries have some Governorates within them as summarized below which sum up to 388 governorates.
-
On looking at the Governorates, each one seems to have a city with a total of 3129 cities listed across the Governorates.
-
On assessing your issue
I noticed your choices sheets seem to have only countries within them. So as it is, this seems to be a problem with your form. Please note that the system can hold quite a huge chunk of data.
Proposed Solution
- One of the easiest approaches to me would be that you structure your form differently i.e. fooling the form
- Create Country as you have created
-Create Governorate but not as a cascading question, but rather as 15 Governorate questions e.g. Governorate_Algeria, etc. This will minimize the selection list per Governorate.
-Create cities as a cascading select from the country-specific Governorate list e.g. cities_algeria would cascade based on the governorate_algeria list. - If you are interested in analyzing the results governorate and city as one, you can create a text question for each which uses a calculation approach that will be the Governorate and the City to provide you this in one. e.g. for governorate you can use; **f(${Country}=“Algeria”,concat(${governorate_algeria},“”),(if(${Country}=“XXX”,concat(${governorate_XXX},“”),EXPAND FOR ALL COUNTRIES)
- The alternative approach would be to use select one from external as illustrated in the topic/s below
Stephane
