topic Re: Auto-populate survey with attributes from more than one layer in ArcGIS Survey123 Questions

Auto-populate survey with attributes from more than one layer

JeffreyMotz — Tue, 09 Mar 2021 19:56:42 GMT

Is it possible to auto-populate a survey with attributes from more than one layer? I'm thinking of a web app where a user clicks on the map, attributes from multiple layers appear along with a link to a URL configured with parameters of the collected attributes.

Re: Auto-populate survey with attributes from more than one layer

DougBrowning — Tue, 09 Mar 2021 20:15:05 GMT

Yes a do this. It works in AGOL and now the new Field Maps (not in Collector).

Take a look at FeatureSet functions in Arcade.

Here is some sample code for you using 1 layer. You can make several arcade expressions and pass all of them over. (note current bug requires all fields to be returned.

var sql = "PointID = '" + $feature.PointID + "'"; var tbl = Filter(FeatureSetByName($map,"Points", ["*"], false), sql); return First(tbl).DesignLat

arcgis-survey123://?itemID=2fb3880b8631451cac08f1653f350787&field:PointID={PointID}&field:EvaluationID={expression/expr0}&field:FieldEvalDate={FieldEvalDate}&field:FieldEvalStatus={FieldEvalStatus}&field:DesignLat={expression/expr6}&field:DesignLong={expression/expr7}&field:AvgTypicalBankfullWidths={expression/expr1}&field:CollectCoreSubset1={expression/expr8}&field:CollectCoreSubset2={expression/expr9}&field:CollectCoreSubset3={expression/expr10}&field:Supplementals={expression/expr11}&field:CollectGreenlineVegComp={expression/expr12}

Hope that helps.

Re: Auto-populate survey with attributes from more than one layer

jcarlson — Tue, 09 Mar 2021 20:17:03 GMT

I think the answer to this (and most questions) is "it depends".

Using built-in web maps / apps

In order to populate a Survey123 URL with attributes from a layer, you'd need to create an expression on one of your feature layers. That's pretty straightforward, and examples abound.

To get more than one layer, the limitation here is that the expression that generates a URL needs to come out of a single layer. The other layers would need to be brought into the same expression by means of Arcade's geometry functions, like Intersects, etc., in order to grab an attribute from another layer.

This might be okay, but then, I don't know the shapes of your layers. I can easily imagine a situation in which the clicked location does not correspond to the same feature that would be returned from the geometry functions.

Using Custom JS

If you built your web map from scratch, you could probably get a clicked coordinate to run a series of intersections with your layers and spit out a single URL. I don't know enough JS to be of much help there, but you might check out the Developers page and see if it's worth pursuing.

Re: Auto-populate survey with attributes from more than one layer

RyanBohan — Tue, 09 Mar 2021 20:36:46 GMT

Should be doable in arcade...something like

var URL = "https://survey123.arcgis.com/share/(your survey)?"

URL += "field:ID=" + $feature.OBJECTID
URL += "&field:business_address=" + "feature["business_owner_name"]"
URL += "&field:business_activity=" + "feature["business_activity"]"

return URL

Re: Auto-populate survey with attributes from more than one layer

ScottLehto1 — Fri, 12 Mar 2021 19:19:53 GMT

Hi Doug,

Thanks. The example helps for sure. I have two questions:

1) In your URL Link string above, i see you use both the {expression/expr#} syntax to pass a value and the {FieldName}. I'm just wondering what the difference is in terms of functionality. I'm sure there is good reason but I am new to this, so i am missing something.

2) So when i click my my link in the popup, i am pushed to Survey123 where i edit the record, and then submit my record in S123. However, a new record is created in AGOL instead of an update/edit. In other words, when i click on the link, the URL is pushing the values I want to use to the Survey123 Form, but it looks like its creating a new record versus updating the old one.

I was wondering and hoping you might be able to shed some light on that.

Thanks Doug. You've helped me out a lot.

Re: Auto-populate survey with attributes from more than one layer

DougBrowning — Mon, 15 Mar 2021 13:43:12 GMT

&field:EvaluationID={expression/expr0} is to pass a value from Arcade

&field:PointID={PointID} is to pass a field from Collector or Field Maps.

Yes this was all designed to add not edit. App does not support an edit only the web app. Here is one post but there are more.

https://gis.stackexchange.com/questions/358709/edit-and-update-existing-features-in-a-collector-app-using-survey123-forms

I personally always add records vs edit to track all visits.

Hope that helps.

Re: Auto-populate survey with attributes from more than one layer

DougBrowning — Fri, 03 Dec 2021 19:53:20 GMT

Note it seems like the field list bug is now fixed. That means you can do this and it will be much faster for large layers.

var tbl = Filter(FeatureSetByName($map,"Points", ["DesignLat"], false), sql);

Re: Auto-populate survey with attributes from more than one layer

RichardPasquale — Thu, 27 Feb 2025 16:56:06 GMT

I have been searching the community for weeks now looking for ideas and I think you maybe speaking to what I need to do. Let me run what I'm trying to get past you.

I'm using offline map and survey. I have a popup in layer A (the selected layer) with URL using callup fields of the feature in layer A the user has interacted with (pushed on) to populate in the survey.

What I am hoping to add to this URL, is a way to also callup a field in Layer D (circle in yellow) of the feature with the matching attribute X (in orange) from the feature selected, thus returning a value from a different layer in the same map which shares a common value to the feature selected.

My idea was something like:

Field X = (in layer ID reference feature with field Y matching field Y {return value to populate}

&field:DateCompleted=(id=0cf6839995f34aafb01a5459d7f6205d,(SUID=SUID){DATE_COMPLETED})

I feel like I'm note even explaining this right