Calculate Visit number?

Support
1

What is the problem? Please be detailed.
I have many health facilities that will be visited various times to monitor different variables. I am developing a dashboard with Google sheets and I want to look at the different variables for all health facilities for all visits BUT I also want to compare the different variables for all health facilities at each visit i.e. Visit 1, Visit 2.
My question:
Is there a way for the XLSform to generate automatically the visit number or would it be easier to do a choose_one question with choices Visit 1, Visit 2, Visit3, etc

Thanks

2

Hi there! The simplest way to do this is to use ODK Collect and have a drop down or integer question that asks for the visit number. I'd also make sure you have some metadata like device id and start/end time so you can order and group visits in case your enumerators don't get the visit sequence correct.

1 Like
3

Thanks for your answers Yaw!