Cascading file

[nohandoye]

Hello,
I have created a cascading file. The commune (commune) depends on the department (département), and the department depends on the region (region).

I would also like to create 2 variables: Surveyor and Supervisor. Both must depend on the region, such that there are 2 surveyors per region and 1 supervisor per region.
The surveyors are coded from 1 to 4, and the supervisors are coded from 1 to 2.

How can I add these 2 variables (surveyor and supervisor)?
The file in attached.

Thank you
Cascading_File.xlsx (9.6 KB)

[Kal_Lam]

@nohandoye, if you have not gone through it, then this support article Adding Cascading Select Questions should help you design a cascading select question.

In addition, this community post discussed previously should also help you understand how it’s built through the XLSForm:

How to create a multi layer cascading select question?

Hi @PALASH9698, Please see the revised/updated cascading selects based on your added information. In the survey tab of the xlsform: [Image 1] In the chocies tab of the xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Palash Selected Villages.xlsx (18.0 KB) Have a great day!

More discussions on cascading select can be viewed here.

[nohandoye]

@Kal_Lam Thank you very much