topic Re: Data validation in the field in ArcGIS Survey123 Questions

Data validation in the field

ReneAubut — Thu, 24 Oct 2019 13:32:44 GMT

Hi, we use a Survey123 form for soil tracking on construction sites. Our most critical info is the truck licence plate. Since we allow field workers to copy an existing record as a new record, is there a way to check that the licence plate question was updated in the copied record ? Thanks

Re: Data validation in the field

JamesTedrick — Fri, 25 Oct 2019 21:15:51 GMT

Hi Rene,

There isn't a way in Survey123 to compare values across different submissions.

One possible workaround would be to require a photo of the license plate to make sure that it's captured correctly, or if there's an asset barcode on the truck, to scan that.

Re: Data validation in the field

DougBrowning — Mon, 28 Oct 2019 16:58:50 GMT

Maybe have a Start type field. Then compare this to today. If it is today then set the license plate to ''? Might need to use a once() to make sure it does not change.

Not sure if Start will change on a copy?

Re: Data validation in the field

ReneAubut — Mon, 28 Oct 2019 18:56:05 GMT

Just tested. A copy wont change the Start, but it will change the End. so how would it be set? Would you set that condition in the Default column? if not(now() = End) then licence= ?. I know my syntax is wrong...

Re: Data validation in the field

DougBrowning — Mon, 28 Oct 2019 19:12:09 GMT

You could add that check to the relevant somehow. That is how I "blanked out" fields in the past. The hard part is there is no way to "keep value" since that would be a dependency loop.

Now I am thinking

Have a field with a calc of once(now())

Then have a field calc on a question Enter new plate Yes/No and calc the yes or no based on above

Then have your license field relevant on the Yes/No

That is all I can think of.

Re: Data validation in the field

ReneAubut — Wed, 30 Oct 2019 11:34:00 GMT

Thanks Doug, I will try something and let you know!