S123 Form Clickable Map NOT working to return attribute from a polygon

[Teresa-AZ]

I CAN get the Map to show in the S123 Form, however when I zoom to the polygon and click it (make a polygon from the point FL just to attempt that too), it does NOT return the attribute from the Calculation cell in the XLS.  Below is a brief description of what I have tried along with the XLS for review. (XLS highlighted in Yellow the rows of interest.)

Background here: I WAS able to use "another" XLS to have it create the Web Map which I configured a Pop-up with a parameter URL so I could Click a point (not a polygon) and it would return that point (attribute) to the S123 Form.  All good there. However, I want the field crew to be able to do all this just from the S123 Form so...

WHAT I NEED is to have a Map IN the S123 Form that is 'Clickable' and will return the attribute automatically without any human error in the field. (FYI, I changed the Feature Layer from point to a polygon in hopes that would work; nope. Also, I had many other versions of this same XLS with different approaches and landed on this approach (see attachment and Esri links) which appeared to be the best solution.  The Map DOES show up in the Form and I can zoom in and Click the polygon (even at full zoom) but nothing is returned in the Form.  😞

I attached the final XLS that I am using as well as the links below which I watched and followed, as well as I did extensive research in the Esri Community and beyond.

ANY HELP you can give me would be great!

Thanks! - Teresa

LINK to Esri video that helped for pulldata with spatial map in Form.

LINK to Esri document they reference in that video.

[Neal_t_k]

The layer you are trying to pulldata from is a point layer, so unless they click the exact right spot you are not going to get a response,  I am not sure if this will even work for a point layer.  You mentioned making a polygon layer from the point layer, have you tried referencing that layer instead of the point layer?

Another option would be to configure the query to search within a distance of your location.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-laye...

Again not sure how this will work with a point layer.

[Teresa-AZ]

Hi Neal,

Thanks for your quick response!  Yes, I thought of that too so I made a 1, 2 and 5 meter buffer (so polygon) layer from that point layer and STILL have the issue. Ugg.  I even zoomed all the way in on the Map to click it, just in case. No luck.

-Teresa

[Neal_t_k]

This works, but it is a very big search radius, and I don't know which point it is returning, the closest, or more likely the first in the list. You could play with this shrinking the search radius until you are happy.

pulldata("@layer", "getValueAt", "attributes.mw_manh_24", "https://maranaegov.com/server/rest/services/Hosted/MW_MANHOLES_2025/FeatureServer/0?distance=1600&units=esriSRUnit_Foot", ${location})

or, If it were me I would make a polygon layer (similar to a parcel layer) where each polygon has one manhole attributed to it and use that instead of your current point layer for the pulldata query.

[Neal_t_k · Accepted solution]

You need something like this for your pulldata to reference

In ArcPro:

Create a border for your area of interest.

From your point layer, use the Create Thiessen Polygon tool (output fields - All) to make polygons

Clip the Thiessen Polygons to your border layer.

Publish the resulting feature layer and use that feature for the pulldata query.

[abureaux]

Have you considered having them select the point before entering the survey. E.g., Use Field Maps to select a data point, have that launch into S123 (and pull in the relevant data).

Having a quick scan of your XLSX form, that seems like it would be a more reliable workflow.

[Teresa-AZ]

Hi Neal - I created a 10-meter circle for them to Click and I have to be careful since I do not want it to overlap on other manhole covers.  I will add in the distance code, as you did, to hopefully be able to get it to work.

Hi abureaux - I was able to do that and it was successful, however I wish for them to only use the S123 app and therein lies my problem.

I will attempt what Neal suggested since that "seems" like it would work for us and I see his image with it working.

I will let everyone know what happens here. THANKS!  - T

[Teresa-AZ]

IT WORKED!  Thanks!  

Neal, you are the Best!