topic Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables in ArcGIS Field Maps Questions

Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 15:57:32 GMT

Hello, I am trying to populate a field (Site_ID) in a related table (campground_evaluations) using the arcade function FeatureSetByRelationshipName. The related feature that I am trying to pull from is called MTH_Campgrounds.

In Field Maps I want to select a point (campground in this example case) and select the related table icon and enter data into the form I created for the table. Hopefully, this code will reduce the potential for error while inputting data into the table's form. The feature and table are related using Global IDs. This is where I am, but I get a Execution Error:Cannot read properties of null (reading 'toString').

var related = FeatureSetByRelationshipName($feature,'MTH_Campgrounds', ["SITE_ID"], false)

var record = First(related)

if (IsEmpty(record)){

return "No Record Found"

}

return record['SITE_ID']

Thanks in advance!

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

KatiePiper — Tue, 16 Aug 2022 15:13:52 GMT

var parent_fs = FeatureSetByRelationshipName($feature, 'MTH_Campgrounds', ['SITE_ID'], true) var parent = First(parent_fs) if (!IsEmpty(parent)) { return parent['Serial_Num'] } else { return null }

Hi Matthew, try this. I tried for so long a few weeks ago and eventually got this code to work with my dataset. I find that it helps to use the Global links to input the feature class and field and not just type it in. Hope it works for you.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 15:09:09 GMT

Thanks for your reply!! The code still generated the error message though... I am about to resort to just making a separate table created from the relates.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

KatiePiper — Tue, 16 Aug 2022 15:15:15 GMT

Ah okay, I just realized I didn't change the "Serial_Num" to "SITE_ID" Not sure if you caught/changed that.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 15:25:53 GMT

I did, catch that.. no go

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 15:55:13 GMT

Does the table's (campground_evaluations) field (SITE_ID) that we are trying to populate from the related feature (MTH_CAMPGROUNDS) need to be identified as a variable?

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

KatiePiper — Tue, 16 Aug 2022 16:10:22 GMT

I don't think so because you are putting the arcade expression under that field on field maps. That is where you are putting it, correct?

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 16:23:27 GMT

yes that is correct

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User — Tue, 16 Aug 2022 19:19:56 GMT

So I added brackets, and the test for this code worked!! But, when I open the map in the mobile field maps app it says calculation failed.... any ideas?

Here is the code

var parent_fs = FeatureSetByRelationshipName($feature, ['MTH_Campgrounds'], ['SITE_ID'], true)

var parent = First(parent_fs)

if (!IsEmpty(parent)) {
return parent_fs['SITE_ID']
} else {
return null
}

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

KatiePiper — Tue, 16 Aug 2022 19:58:39 GMT

That was my trouble for days before I was able to get it to work. In the information I was reading.. it sounded like after $feature you had to put the relationship class name. I kept trying to do that but then randomly tried the parent class name and it worked. So I can only suggest trying different names that you used while creating the feature class?

https://community.esri.com/t5/arcgis-pro-questions/attribute-rule-to-pass-a-value-from-parent-to/td-p/1123857

https://community.esri.com/t5/arcgis-field-maps-questions/automatically-populating-related-table-field-with/m-p/1172223#M3343

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

DougBrowning — Wed, 17 Aug 2022 14:05:56 GMT

There has been many, many posts on here that FeatureSetByRelationshipName has some bugs in it and often does not work. Change to FeatureSetByName and it should all work better. You then have to wrap it in Filter to get just the record you want. It could be slower if a large table since it grabs it all then you filter. But it works. Also note to add just the field you want and not return geometry which will be faster.

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

I asked them to add a where clause to FeatureSetByName which would be much more efficient but no word back yet.

I am also not sure you can return null? I would return ''.

Hope that helps

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Lindsay — Sun, 21 Aug 2022 21:41:17 GMT

Hi @DougBrowning , I have a similar situation. Not sure if I should be starting a new post here. Sorry if I've hijacked the thread. I want to pull in the block name from another layer into my new polygon. These layers are in the same map. They are not related. I tried following the instructions in this Field maps blog post - May 12, 2022 Common calculated expressions for ArcGIS Field maps , and then when I couldn't get it to work, did some googling and came across this thread we're in now.

This is the calculated expression I have.

// Create a feature set using the 'Regions' layer in the map var blocks = FeatureSetByName($map, 'Blocks', ['Block_name']) // Intersect the current location with the regions and // get the first region var block = First(Intersects($feature, blocks)) // If the current location does intersect a feature, // return the name of the region. Otherwise, return null if (!IsEmpty(block)) { return block['Block_name'] } else { return '' }

Do you notice anything I've missed here or am I using featuresetbyname incorrectly? I haven't used it before, but want to get the Block_name field from the Blocks layer carried into this new layer.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

DougBrowning — Mon, 22 Aug 2022 14:25:03 GMT

I tend to use block.Block_name instead but what you have there looks like it should work to me. I would make sure your field name and map name are the proper case. Like it is maybe Block_Name or something.

Try that then maybe a screen shot of the map to see.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Lindsay — Mon, 22 Aug 2022 20:57:28 GMT

Hi @DougBrowning . Thanks for your reply. I've checked the casing. It doesn't look like that. I'm not following where you swap out the block.Block_name part and do I keep using "" or '' in that situation?

Both of these layers are view layers. Would that be affecting it?

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

DougBrowning — Mon, 22 Aug 2022 21:02:14 GMT

On the return line I always write it like First(tbl).DesignLat

Yours would be

return block.Block_name

My intersects I wrote in one line but it should work the same

var plots = Intersects($feature,FeatureSetByName($map,"TerrADat", ["BareSoilCover"], false));
return Average(plots, "BareSoilCover")

What are the geo types of both layers?

I wonder if you are zommed way out?

Be aware that using $feature as input to this function will yield results only as precise as the view's scale resolution. Therefore values returned from expressions using this function may change after zooming between scales.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Lindsay — Mon, 22 Aug 2022 22:32:27 GMT

Hi @DougBrowning , I copied in your expression and switched it out with mine, but got this error.

var blocks = Intersects($feature,FeatureSetByName($map,"Blocks", ["Block_name"], false)); return blocks.Block_name

Execution Error:Runtime Error: Cannot call member property on object of this type. Block_name

I'm using two polygons published from ArcPro. Separate feature services. Both view layers.

I'm not zoomed out far. I'm pretty close in.

Thanks for advising about the precision. I wasn't aware of that.

I'm going to mull this over more. Thank you for your help.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

DougBrowning — Tue, 23 Aug 2022 13:42:15 GMT

You need First in there.

return First(blocks).Block_name

If that does not work take out the false part. That tells it no geo and may be needed.

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Lindsay — Tue, 23 Aug 2022 20:27:17 GMT

Hi @DougBrowning , I've added in First and removed false, but I'm getting this error.

Execution Error:Runtime Error: Cannot call member method on null. Block_name

var blocks = Intersects($feature,FeatureSetByName($map,"Blocks", ["Block_name"])); return First(blocks).Block_name

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

DougBrowning — Tue, 23 Aug 2022 20:43:34 GMT

Sounds like your intersect is not returning any results. It picks the first one in the table or the area you are zoomed to. Are you sure the feature has something to intersect to?

You can add a check to see if the result is empty to avoid an error.

var blocks = Intersects($feature,FeatureSetByName($map,"Blocks", ["Block_name"]));

if (Count(blocks) > 0) {
return First(blocks).Block_name
}
else {

return "None found"

}

Re: Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Lindsay — Tue, 23 Aug 2022 23:28:47 GMT

Hi @DougBrowning , when I test in the preview, the Result returns None found, but after I click ok in Configure form and save the map, close out and re-enter, if I draw a new polygon (zoomed in enough so I can't see the borders of the polygon whose Block_name attribute I'm trying to pick up), it still appears empty in the form and in the pop-up.