Arcade - FeatureSetByRelationshipName - Calculate Field

RonParis

I was wondering if it was possible to use FeatureSetByRelationshipName to calculate fields in a related feature class?

What I want to do is carry the values from a field in featureclass1 to an empty field in featureclass2. I can successfully achieve this in a popup in AGOL, but I want to do be able to achieve this in Field Calculator, and then ultimately Python to automate the process.

At the moment, I am using the below expression for the popup, but it doesn't seem to work in Field Calculator:

 

var relatedrecords = FeatureSetByRelationshipName($feature,"[relationship_name]")

for (var f in relatedrecords){
return f.[field_name]
}

TIA

dougbrowning

Yea you need to filter it for the feature you want.  Like other poster said use First since 1 result will be faster.  Also do not return geo (the false part).

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