topic Re: Connecting ID Data to Attribute table in ArcGIS Pro Questions

Connecting ID Data to Attribute table

klewis47 — Wed, 02 Aug 2023 20:18:37 GMT

Hi,

So I have a trigger that when you create a polygon (each has its own ID) it will add the shape area and other data to a relational table using var FeatureSetByName, dictionaries and the attribute rules. My issue is that occasionally the user might want to data directly from that relational table through the add table. What i'm trying to set up is that if there was already a polygon created with an id of 79 the user could add a row to that table and write in the 79 as the id and the area of that polygon will automatically load into the table. My thing is that since the attribute rules are based on triggers a change won't be made until something within the polygon is changed. Does anyone know how I could get the table to automatically load the data for the same ID?

^ for example I want the null value in the second row to be the same value as the one above it.

Re: Connecting ID Data to Attribute table

JohannesLindner — Thu, 03 Aug 2023 07:07:47 GMT

You have created an Attribute Rule on the fc that writes to the table. As you said, that triggers only when you edit the fc. To get the same effect when you edit the table, you have to create another Attribute Rule there that reads from the fc:

// Calculation Attribute Rule on the table // Field: empty // Triggers: Insert, Update // load the polygon fc var polygons = FeaturesetByName($datastore, "Polygons") // find the correct polygon var id = $feature.PolygonID var poly = First(Filter(polygons, "PolygonID = @ID")) if(poly == null) { return } // and return its values: return { result: { attributes: { Field1: poly.Field1, Field2: poly.Field2, Field3: poly.Field3, } } }

Re: Connecting ID Data to Attribute table

klewis47 — Thu, 03 Aug 2023 20:53:06 GMT

(Deleted)

Re: Connecting ID Data to Attribute table

JohannesLindner — Thu, 03 Aug 2023 20:26:26 GMT

check the filter expression in line 6 (probably a copy/paste error)
check that both tables actually have a field called "shape_area"
just calculate the Area():

'shape_area': Area(poly),

Re: Connecting ID Data to Attribute table

klewis47 — Thu, 03 Aug 2023 20:51:52 GMT

Got it working, thank you!