I have a survey that has 2 mandatory date/time fields.
The 1st date/time field records when the inspector arrives on site and is calculated using the Now() function, when the survey is opened.
To get the value for the 2nd date/time, (which is when the inspector leaves site), the users enters a value for the number of minutes on site, and then a calculation is applied to add the value in the 1st date/time field and the number of minutes on site.
The number of minutes and the calculation has been deployed to make it easier for the inspector to complete the inspection... i.e. less typing.
The survey also includes before and after photos, corresponding to the 1st and 2nd date/time questions.
For the most part the survey works fine, but our users are saying that if they've been on site for say 30-45 minutes, then when they fill in the value for number of minutes on site, then 2nd date/time field won't compute.. and since this is a mandatory field then the inspection cannot be submitted.
I guess we could amend the survey to..
- allow the photos to be selected from the photos on the device
- make the 2nd date/time default to Now() and subtract the number of minutes to get the 1st date/time
but preference would be to take the photos live, rather than browse the device.
Is there any reason why a survey that has been left 'open' for a while would fail to compute the 2nd date/time?
Or would you have any other suggestions as to how to resolve?