I am working on a ODK xls form and trying to do the following, however cannot yet work it.
I have three questions with choice lists.First one is to name the administrative unit. Second one is to mention type of settlement (urban and rural) and third one is to name community. As the list of communities is quite long, I am trying to connect it to the selected adminitrative unit and settlement type. For example, if X administartive unit was selected and in settlement type "rural" was selected, only rural communities of X administrative unit appear in the "community name" question's answer options. Is this possible? If yes, could you please give some guidenace, I would be very grateful.