Table 1.

Customizing the ODK excel sheet for data collection and combined use with MAPS.ME: the survey sheet

line	type	name	label::english (en)	appearance	calculation	choice_filter
1	select_one interviewer	interviewer	Interviewer:
2	select_one shehia	shehia	Shehia:
3	select_one houseID	houseID	To which household are you going?			shehia = ${shehia} and interviewer = ${interviewer}
4	calculate	latitude			instance('houseID')/root/item[name = ${houseID}]/latitude
5	calculate	longitude			instance('houseID')/root/item[name = ${houseID}]/longitude
6	select_one modes	mode	How will you get there?
7	integer	mapsme-wayfinding	Click to open maps.me	ex:com.mapswithme.maps.pro.action BUILD_ROUTE(lat_to = number(${latitude}), lon_to = number(${longitude}), router = ${mode})
8	select_one modes	goodbye	Thanks!			latitude = 1 and longitude = 1