update geopoint with calculation using if statement

TregChristopher — Wed, 29 Apr 2020 19:45:45 GMT

Hello,

I'm setting up a QC Survey123 form and would like the editor be able to:

1. move the map geopoint to a new location,

2. record new location coordinates to two lat/long attribute fields

3. either save the form with the new location or revert back to the original location, depending on whether they toggle a Yes/No question asking if they want to update the map with their loc or the originally reported location (stored in two other lat/log attribute fields).

Following calculation suggested in:Geopoints—Survey123 for ArcGIS | Documentation, I used the formula "substr(${previous_question}, 0, 10) + " " + substr(${previous_question}, -10)" to change the map location. However, I'm having difficulty toggling between two sets of coordinates, depending on the answer to the yes/no question (see examples below).

Calculation on geopoint

1. This works to force an update the geopoint back to the original coords found in two, lat/long attribute fields:

(substr(${LatitudeReported}, 0, 10) + " " + substr(${LongitudeReported}, -10))...i.e. when I review the record again, the geopoint has been moved back to the originally reported location.

2. This gives an error "ODK Validate Errors" when I try to save the form and include an if statement to update the geopoint between the two different choices from location attribute fields:

if((${IsLocationCorrected}=20),(substr(${LatitudeReported}, 0, 10) + " " + substr(${LongitudeReported}, -10)),(substr(${WSDOT_LatitudeStateRoute}, 0, 10) + " " + substr(${WSDOT_LongitudeStateRoute}, -10)))

Am I just mis-typing the formula or this not even possible to combine the if statement with the substring calculation when updating geopoint?

Re: update geopoint with calculation using if statement

BrettStokes — Wed, 08 Jul 2020 06:20:36 GMT

Hi Treg,

Did you find a solution for this workflow? If so, please share it on the forum.

Thanks,

Brett

topic update geopoint with calculation using if statement in ArcGIS Survey123 Questions

update geopoint with calculation using if statement

Re: update geopoint with calculation using if statement