nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

ŽeljkoPušec

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.

Najděte více příspěvků označených jako

Accepted answers

DanteLee

You could set the constraint column with contains:

contains(${address},'Zlatar Bistrica')‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

DanteLee

You could set the constraint column with contains:

contains(${address},'Zlatar Bistrica')‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

ŽeljkoPušec

It works!

Thank you kindly for your reply!

Arlington_CoGISMC

What about if you are only using the web version?

DanteLee

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

ŽeljkoPušec

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!

DanteLee

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")‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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')‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.