We are thinking of using ODK tools as part of our data collection workflow in construction.
Our data is stored in a PostgreSQL/Postgis database and will be the base for field data collection.
We will use data preloading -https://opendatakit.org/help/form-design/data-preloading/ to associate our base data with survey forms.
In monitoring construction projects there are certain milestones - stage1, stage2, stage3. How does one approach the design of the form to:
- ensure data is collected when onsite
- cannot proceed to stage2 unless stage1 is completed
- on subsequent visits - to not have the ability to edit previously completed stages - when collecting stage3 data, one cannot go back to stage2 if already submitted.
- keep the PostgreSQL/Postgis database updated with new survey data. In this regard I have come across this solution - https://www.openfn.org/
Thanking you in advance for your assistance.