topic Re: Automatically populating related table field with parent table data? in ArcGIS Field Maps Questions

Automatically populating related table field with parent table data?

NoahWasserman — Mon, 09 May 2022 22:14:22 GMT

I have a point layer with a SiteID field linked to a related table with SiteKey (similar setup to the ESRI Hydrant Inspection tutorial). For each point there are multiple rows in the related table ("1:M"; e.g. hydrants and inspection records). I can't figure out how to use FeatureSetByRelationshipName (or another function?) to simply pull a number from the parent point layer into each inspection record. I have a constant in the point attribute table (different for each point) that I need to use in an expression when recording new records in the related table. I keep getting the objectID along with the value I want which won't populate an integer field.

Re: Automatically populating related table field with parent table data?

JohannesLindner — Tue, 10 May 2022 05:50:42 GMT

You're halfway there!

The FeatureSetBy*() functions return feature sets, collection of features. You have to select 1 of those features (often the first one) and return 1 of its attributes.

// load all related features var related_features = FeatureSetByRelationshipName($feature, "SepticLocations", ["inspect_freq"], false) // select one of those features, here we just grab the first one var related_feature = First(related_features) // if there are no related features, related_feature will be null and we will // get an error down the line, so we need to check that and return early if(related_feature == null) { return null // if there are no related features, we return a default value (null in this case) } // return an attribute return related_feature.inspect_freq

Re: Automatically populating related table field with parent table data?

RenM000 — Fri, 09 Sep 2022 18:30:21 GMT

Reading through your code, I can't tell what of my own Globals to fill in.

simplified, I have a layer called Plants. Then I have a related table called Plant Inspections. I am trying to calculate the Site Name (and other fields) for my related table by what is already in the layer, as OP was.

The green font (Septic Locations) came from where? Is that the Layer name? And if so, is the [inspect_freq] the equivalent of Site Name? Would this site name be from under the layer or from under the table?

Thank you.

Re: Automatically populating related table field with parent table data?

JohannesLindner — Sat, 10 Sep 2022 09:23:10 GMT

This code uses FeatureSetByRelationshipName(), which returns the related features based on a relationship class.

SepticLocations is the name of the relationship class, inspect_freq is the name of a field in the related table.

If you haven't built a relationship class, you can load the related table with FeatureSetByName() or one of the other FeatureSetBy*() functions and then Filter() it.