1. What is the problem? Be very detailed.
I'm trying to use ODK or ODK X for a maintenance inspection routine where total pump hours and total volume pumped are recorded. It is very important for the operators to be able to see the hours the pump has ran since the last inspection, and the volume pumped since the last inspection.
For example:
November 15, 2019 Inspection of Pump 1:
- Total hours: 1,500 (hours) ... operator input
- Total volume pumped: 5000 (cubic meters) ... operator input
November 16, 2019 Inspection of Pump 1:
- Total hours: 1,510 (hours) ... operator input
- Total volume pumped: 5500 (cubic meters) ... operator input
- Hours ran since last inspection: 10 (hours) ... calculated from (Nov16 total hours - Nov15 total hours)
- Volume pumped since last inspection: 500 (cubic meters) ... calculated from (Nov16 total volume - Nov15 total volume)
And so on for the rest of the inspections.
I'm looking for help regarding the "hours/volume since last inspection" field.
2. What app or server are you using and on what device and operating system? Include version numbers.*
I'm open to using any of the ODK or ODK x tools
3. What you have you tried to fix the problem?
I've currently installed and tried setting up the ODK tools but cannot find a way to reference previous form entries. Am currently experimenting with ODKx tables to see if a calculated column can be added.
4. What steps can we take to reproduce the problem?
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
Appreciate your time
-Andre