topic Re: Using Arcade to link Survey123 data in ArcGIS Survey123 Questions

Using Arcade to link Survey123 data

ColtonPhillips — Thu, 09 Sep 2021 18:14:52 GMT

Hello,

Forgive me if this is the wrong place to post.

I have a web map that has line work on it. That line work when clicked on brings up a survey123 that is auto-populates with the line name.

I am trying to link the survey with my line work. So when a user clicks on 'line X', the survey populates, the survey gets submitted, and then the pop-up for 'line X' shows the survey information.

I was able to use intersect for survey items that have geometry, but is there a function that is essentially 'intersect' but for checking field names?

Re: Using Arcade to link Survey123 data

jcarlson — Thu, 09 Sep 2021 18:29:55 GMT

Can you clarify: the survey that is pulled up is not tied to the linework layer, but is a separate layer? If I'm understanding your post correctly, you want that updated value from the survey to then show up in the popup for the original clicked feature?

It is more of an Arcade question than a S123 question.

There is a way to "intersect" based on field using the Filter function.

// Name of feature var f = $feature.line_name_field // Get survey layer var fs = FeatureSetByPortalItem(Portal('your-portal-url', 'itemid-of-survey', 0, ['list', 'of', 'survey', 'fields', 'created_date'], false) // Filter survey responses for those applying to clicked line var filt_fs = Filter(fs, "line_name_field = @f") // Check length of filtered featureset, return generic message if none found if(Count(filt_fs) == 0){ return 'No surveys for selected feature' }

You'll need to think about whether and how you want to deal with multiple surveys for a single feature. Simplest is to just go with a single feature so that the attributes can be accessed. Combining OrderBy and First makes this easy enough.

// Get the single most recent survey var s = First(OrderBy(filt_fs, 'created_date DESC')) // Assemble survey attributes into output string return `Some field: ${s.some_field}, Another field: ${s.another_field}`

Re: Using Arcade to link Survey123 data

ColtonPhillips — Wed, 29 Sep 2021 18:15:32 GMT

Sorry for the late reply. I figured it out by using a code similar to below....

var moreData = FeatureSetByPortalItem(Portal ('https://maps.arcgis.com/'), 'ItemID', LayerID) var PROJECT = $feature["PROJECT_TI"] var filterStatement = 'project = @PROJECT' var relatedData = filter(moreData, filterStatement) var relatedDataSorted = OrderBy(relatedData, 'CreationDate dsc') var popUpString ='' for (var f in relatedDataSorted){ popupString += Text(f.rating + ' Star') + TextFormatting.NewLine } DefaultValue(popupString, 'No comment')