I'm currently working with ODK Collect and Google Drive as my local server for collecting and organizing the data. I am collecting data on ~30 trainees completing a work readiness program, and I'd appreciate your advice on:
- What is the best way to collect attendance for 30 people throughout the year using ODK Collect?
- So far I've created a 'Trainee_Database' form for gathering basic info on each trainee. I'd like this to be linked to the attendance sheet. Is it possible to aggregate data per user using ODK Collect + Google Drive spreadsheets? Ideally I'd like to have the 'Trainee_Database' as an overview all of trainees in the program, and then click on a single trainee to see their attendance over time, their progress in work readiness skills over time, etc.
Lastly, I'm considering learning how to use Enketo in order to make the forms & data more visually appealing. Any advice on the compatibility of Enketo for attendance sheets, and what I'm trying to do?
Thank you very much for your help!