Pulling data based on specific conditions (multiple conditions)

[Candy]

Hi,

I would like be able to pull data based on the id number and school selected. I have children assigned to the same id number under multiple schools. I want to be able to pull data on the name of the child based on the school selected and id number inputted. please help urgently!

[Kal_Lam]

@Candy, you could do it as outlined in the image shared below:

In the survey tab of your XLSForm:

In the choices tab of your XLSForm:

In the CSV File:

Data entry screen as seen in Enketo:

Reference XLSForm:

Pull Data (Multiple Condition).xls (34 KB)

Reference CSV File:

Codes.csv (425 Bytes)