topic Re: Add Inspection/Related Record: Bring Value from Feature Class to Related Table? Arcade? in ArcGIS Field Maps Questions

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

ArmstKP — Wed, 18 May 2022 15:27:31 GMT

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?

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

MobiusSnake — Wed, 18 May 2022 15:56:00 GMT

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.

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

ArmstKP — Wed, 18 May 2022 16:23:39 GMT

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

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

Anonymous User — Wed, 18 May 2022 17:05:52 GMT

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.

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

ArmstKP — Wed, 18 May 2022 17:24:45 GMT

@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"

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

Anonymous User — Wed, 18 May 2022 17:38:00 GMT

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.

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

ArmstKP — Wed, 18 May 2022 18:02:40 GMT

We aren't using offline areas.

This looks to be the related error in the log:

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

Anonymous User — Wed, 18 May 2022 18:10:54 GMT

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.

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

ArmstKP — Wed, 18 May 2022 19:42:00 GMT

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-field/td-p/1130571

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

DougBrowning — Wed, 18 May 2022 21:50:20 GMT

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.

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

DougBrowning — Thu, 19 May 2022 18:09:22 GMT

I wonder if you cannot use by relationship name because the New Map viewer has no relationship class support? Also wonder how poster is using this when the map has no relationships.

thanks

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

Anonymous User — Thu, 19 May 2022 18:45:52 GMT

Field Maps uses the relationships defined in the feature service. As long as the parent and child layers are in the map and there is an actual relationship between them, this should just work. There are some existing issues with the Arcade implementation where this doesn't work with offline areas or where the casing of field values matters.

If someone has a sample map where the FeatureSetByRelationshipName isn't working, can you please DM me about it? I'm happy to look into and log an issue if necessary.

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

Anonymous User — Wed, 01 Jun 2022 18:45:38 GMT

Just as a follow-up, we've identified two issues related to FeatureSetByRelationshipName.

1. If your relationship contains a "." in it, then the Android and iOS apps fail to successfully execute the expression. This also occurs in Pop-ups. This is under investigation but probably won't make the next release.

2. In the Arcade editor, if the related layer/table does not have any features it, when you attempt to test it or save an expression that used FeatureSetByRelationshipName the editor fails to execute the expression with "Execution Error:Cannot read properties of undefined (reading 'toString')". The reason it fails is due to how the Arcade Editor evaluates the expression when the foreign key field value is null. When Field Maps or Map Viewer launch the Arcade editor, they need to provide a sample feature to represent $feature. It will query to find the first feature in the layer/table and use that. If there are no features, it generates a sample feature using the default values of the field. In this specific case, if your related table has no features in it, this sample feature will likely have a null value for it's foreign key field. A simple workaround is in the Arcade Editor edit $feature using the > icon and then the pencil/edit icon and add any value to the foreign key field (it doesn't matter what). Then you should be able to test and save it. This is not planned to be fixed in the next release.

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

CodraFrum1 — Wed, 08 Jun 2022 04:32:46 GMT

Thank you Aaron, I simply replaced the FeatureSetByRelationshipName (because it did contain "." to FeatureSetByName

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

ZachBodenner — Mon, 28 Aug 2023 15:54:53 GMT

Is there an update on a fix for the first problem? Since we use referenced geodatabase classes, I think it's basically always going to have a "." in it right? It would be great to see this issue addressed!

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

chill_gis_dude — Thu, 12 Dec 2024 22:39:36 GMT

Does anyone have a workaround for this if there is a "." in the relationship class name?

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

DougBrowning — Thu, 12 Dec 2024 23:18:53 GMT

I thought it was fixed? If not just use FeatureSetByName and then wrap that in Filter(). Works about the same.

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

chill_gis_dude — Thu, 12 Dec 2024 23:47:59 GMT

We are in 11.2 Enterprise, so maybe the fix is in a later release?

Thank you for the suggestion! You don't have an example I can look at, do you?

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

DougBrowning — Mon, 16 Dec 2024 14:30:47 GMT

Just make a query

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