nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Field Maps, FeatureSetByRelationshipName, Arcade, Related Tables

Anonymous User

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!

Find more posts tagged with

Accepted answers

All comments

KatiePiper

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.

Anonymous User

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.

KatiePiper

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

Anonymous User

I did, catch that.. no go

Anonymous User

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?

KatiePiper

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?

Anonymous User

yes that is correct

Anonymous User

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
}

KatiePiper

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

dougbrowning

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

Lindsay

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.

dougbrowning

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.

Lindsay

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?

dougbrowning

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.

dougbrowning

Turned out she was in a map not Field Maps and it says in there that is a no go.

Lindsay

Do we have an idea of when FeatureSetByName is going to be available in Map Viewer?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.