Pulling data based on specific conditions (multiple conditions)


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!

@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)