topic Re: Restrict submission of form if geopoint is not within the city? in ArcGIS Survey123 Questions

Restrict submission of form if geopoint is not within the city?

ŽeljkoPušec — Thu, 04 Jun 2020 09:27:30 GMT

Hello,

first, I used pulldata on geopoint to extract full addres to field named "address". My idea is to create calculation which will check if the full address with street name and number etc., contains name of the city. If not, then return value of null, and as it is requiered field, it will forbid submission of the form if the geolocation is set outside of that city.

Well, I'm not sure this logic is right, but the calculation I wrote sure isn't:

if(${address}) regex(., 'Zlatar Bistrica'), 1, null)

Any help would be much appreciated, thank you.

Re: Restrict submission of form if geopoint is not within the city?

DanteLee — Thu, 04 Jun 2020 19:17:23 GMT

You could set the constraint column with contains:

contains(${address},'Zlatar Bistrica')‍‍

Re: Restrict submission of form if geopoint is not within the city?

ŽeljkoPušec — Fri, 05 Jun 2020 06:34:06 GMT

It works!

Thank you kindly for your reply!

Re: Restrict submission of form if geopoint is not within the city?

Arlington_CoGISMC — Fri, 05 Jun 2020 19:52:35 GMT

What about if you are only using the web version?

Re: Restrict submission of form if geopoint is not within the city?

DanteLee — Mon, 08 Jun 2020 14:36:50 GMT

I believe using formulas is only supported through S123 Connect right now, but I wouldn't be surprised if it's in the pipeline for the web version

Re: Restrict submission of form if geopoint is not within the city?

ŽeljkoPušec — Fri, 17 Jul 2020 14:25:31 GMT

Hello, after I used pulldata on geopoint to extract full addres to field named "address", I used this calculation for a required question: "Is geopoint within Zlatar Bistrica city?":

if(contains(${address},'Zlatar Bistrica'), 'yes', null)

So, the result is that form can't be submitted if the geopoint is se ouside the city.

Now I'm working on a same form for a neighbour city called "Zlatar". But if I use analog calculation:

if(contains(${address},'Zlatar'), 'yes', null)

it is obvious that a geopoint can be set in city "Zlatar Bistrica", because contains "Zlatar" . It shoudn't be posible, so how can I write a calculation for an address that must contain "Zlatar" and nust NOT contain "Bistrica" at the same time?

Thanks very much!

Re: Restrict submission of form if geopoint is not within the city?

DanteLee — Mon, 20 Jul 2020 16:37:46 GMT

Ah always a couple different ways about it.

The "proper" way (in either case) would be to use pulldata + reversegeocode. Note: This consumes 0.04 credits for each reversegeocode statement that is run, so consider your survey traffic and credit limitations. This post has a good example for how to set up a single reversegeocode and use pulldata(@json,'..') for separate fields. See the attachment in the initial question - Survey123: Reverse Geocoding. At its most basic setup, it might look something like this in the calculation field to pull the city (assuming you're using the standard geocoder):

pulldata("@geopoint",${yourgeopointfieldname},"reversegeocode.address.City")‍‍‍

You could embed this within an if statement, or you could have a hidden calculation field if it helps you understand the process step-wise.

The alternate method I might suggest would be a compound if statement. In this case, it checks if the address is within Zlatar. (In other words, if address contains Zlatar AND it contains Bistrica, then it is not in Zlatar.)

if(contains(${address},'Zlatar') and contains(${address},'Bistrica'), 'no', 'yes')‍‍‍‍‍