Add Inspection/Related Record: Bring Value from Feature Class to Related Table? Arcade?

[ArmstKP]

When clicking the blue add button to add a related record/inspection, it brings the globalid/guid value forward into the related table, but what if I want the feature class park name value to populated the related table as well in the park_name field?

[MobiusSnake]

Arcade should do it.  I've set up this kind of thing in Pro using GDB attribute rules but the same approach should work with a calculated expression in Field Maps.  Use the foreign key GUID to find the parent record with a feature set, get the first record of the feature set and pull the field you want off that feature.

[ArmstKP]

@MobiusSnake  Could you give me a small example to go off of?

[Anonymous User · Accepted solution]

Check out the second example in this blog post. It should be exactly what your looking for, just change the layer name and attribute name.

[ArmstKP]

@Anonymous User  I used that code and it worked when I clicked the "Test" Button.  I saved it and then opened up Field Maps 22.2 and I get in red text, "Failed to calculate"

[Anonymous User]

Are you using offline areas by any chance?

If you go to Profile->Troubleshooting->Logs do you see any messages with "Arcade" in them? The error is probably logged there.

[ArmstKP]

We aren't using offline areas.

This looks to be the related error in the log:

[Anonymous User]

In the expression did you change the relationship name? In my example it's "wHydrants", yours is probably different.

If you open the table JSON, you can find the relationship name.

Go to the child layer/table page and click view in the bottom right:

Then in the upper left corner click json:

Then look for the relationships property and the name property within that, copy that and use it in your expression.

[ArmstKP]

I did change the relationship name to my own.  I have come up with another solution (below) without dealing with FeatureSetByRelationshipName.  I see a lot of people are having the same issue.

var relate_guid = $feature["relfeatureglobalid"];
var featSet = FeatureSetByName($map,"Parks Mowing", ['Park_ID','globalid'], false);
for(var feat in featSet){
if(Lower(feat.globalid)==Lower(relate_guid)){
return feat.Park_ID;
}
}

Seems like I am having the same issue as this post:  https://community.esri.com/t5/arcgis-field-maps-questions/featuresetby-arcade-functions-supported-in...

[DougBrowning]

Yes I have seen this as an issue before I use map and then the layer name, like you are, and it seems to work better.