Attribute Rule to update M:N relationship table using intersect

BillMoody

I'm wondering if it would be possible to update a M:N relationship table between a point layer and a polygon layer based on an intersect.  

Example:  I draw a polygon on a map that represents an area that needs to have tree trimming work.  The polygon covers all of the trees (points) that need to be trimmed.  

Upon polygon creation I would like the rule to grab the GlobalID all of the intersecting trees and push them to the relationship table and also grab the GlobalID of the polygon and match that in the corresponding rows of the those tree IDs.  

The reason for this is to make it possible to utilize the many to many relationship within an application like Field Maps, which I don't think can be done out of the box.  

Thanks for any suggestions!

Screenshot 2023-08-23 145953.png

Screenshot 2023-01-17 153311.jpg

JosephKerski_13-1619279106687.png

HusseinNasser2

Yes it is possible by returning an edit dictionary against the attributed relationshipclass table, here is a sample filegdb . 

 

 

 

script

 

 

var fs = FeatureSetByName($datastore, "tree");
var fsInt = intersects(fs, $feature);
var payload = [];
var c = 0;
for (var t in fsInt)
{
     payload[c++] = {"attributes": { "treeGUID":  t.globalid, "areaGUID": $feature.globalid} }
} 


return {
     "edit": [{"className": "tree_trimarea",
                "adds": payload
              }]
}

 

treesMnM.zip

Location Matters - RetailITMarch2013.pdf