Hi all!
I am creating a survey workflow that leverages Collector and Survey123.
The survey is designed to work overtime(call it 2 years) where users carry out inspections (up to 7 times) over this time period. This is in a forestry context where inspections are done on a tree and branch level. To accommodate this tree/branch level we make use of REPEATS.
Originally the survey was setup where the user would select an activity and capture the relevant data with the datetime being captured using the now() calculation. However there was a great deal of data duplication as the users were not able to visualize the previous data collected on the form which lead to double captures of the same activity.
This led to a change in design to only allow updating from the SENT items where the previously captured data could be seen. The issue being that the now() calculation only fires once when the form or REPEAT is created and not when users "edit and resend" the same form. A work around would be to allow users to manually change the time to the current time, however there can be upwards of 250 branches so this is not a possibility.
I should mention the reason we are wanting the time to change with each update is that we have a SQL script pulling these times and pushing them into a results table which runs daily. We cannot exclusively use the "GDB_FROM_DATE" field as this only captures the PUSH datetime of the entire capture and not the per branch time.
Any help would be greatly appreciated.
