How do we randomly select a member of a household roster based on certain eligibility criteria?

Hi @jsleiva,

Welcome to the community! Would you mind testing the attached xlsform that selects eligible household members from a household roster.

select_random-female-eligible-respondent V1.xlsx (11.0 KB)

Please Note: It best works with KoBoCollect while it might show an error while trying to enter the same through Enketo (web form). Also please note that the random selection of eligible household members are based on the random number generated. If there are more than one eligible members in the household the survey form selects an eligible respondent based on the value calculated from a random number. If the value of the random number is towards 0 it selects the eligible member that has been first registered (within the household roster) while if the random number is towards 1 it selects the eligible member that has been lately registered (within the household roster).

GOOD DAY!

1 Like