Populate a value from one table to another using a joining field

[GdB_Admin]

Hello,

I am trying to populate a field based on where a joining ID is between two tables. I have a relationship class set up between two tables but I want to bring over another value than just a GlobalID. So I was trying to use an attribute class to do this but it is not working for me. Can someone help?

My joining field is LocationGlobalID = GlobalID

The field I want populated from one table to the other is GdBOrderNumber = GdBOrderNumber 

var f_gid = $feature.LocationGlobalID;

var Project = FeatureSetByName($datastore, "Database.DBO.[Other Table]", ["*"], true);
var Join = Filter(Project, "GlobalID = @f_gid");

return {
'result': $feature.GdBOrderNumber,
'edit': [
{"GdBOrderNumber": $feature.GdBOrderNumber
} 
]
};

[JohannesLindner]

So, you have Table A with this rule and you want to populate the field "GdBOrderNumber" on Table B, is that correct?

// calculation attribute rule
// triggers: insert(, update)
// field: empty

// get the related record(s)
// either use FeatureSetByName() and Filter() like you did
// or use the relationship class:
var related_records = FeatureSetByRelationshipName($feature, "RelationShipName", ["GlobalID"], false)
// we're only interested in the related records' GlobalID, because we need that to identify them in the return dictionary

// create and fill the update array
var updates = []
for(var record in related_records) {
    // updates is an array of dictionaries
    // the dictionaries are built like this:
    // {"globalID": "GID of the edited feature", "attributes": {"Field": value}}
    var update = {"globalID": record.GlobalID, "attributes": {"GdBOrderNumber": $feature.GdBOrderNumber}}
    Push(updates, update)
}

// apply the edits
return {
    "edit": [
        {
            "className": "Database.DBO.OtherTable",
            "updates": updates
        }
    ]
}

To learn more about the return dictionary keywords, read this: Attribute rule dictionary keywords—ArcGIS Pro | Documentation

[GdB_Admin]

That is what i was looking for and thank you for the link that will help a lot

[GdB_Admin]

@JohannesLindner I spoke a bit too early on this. what you gave  me works but it is in the wrong direction form what I am looking for. the set up is the FeatureClass has the relationship class on it. When an inspection is done it is being put into the table using that GlobalID = LocationGlobalID. From here now that the Table has a new record in it I need to use that Relationship Class ID (LocationGlobalID) and grab the GdBOrderNumber field from the FeatureClass and apply it to the Table. I am putting the Attribute Rule on the Table because that is where the Insert is taking place. I tried to change the code you gave me but it keeps giving me errors or just does nothing. I tried to use the LocationGlobalID field in the dictionary like you said but it is telling me I need to use the GlobalID field, but when I do that it does not do anything. Here is what I have:

var f_gid = $feature.LocationGlobalID;
var related_records = FeatureSetByName($datastore, "Database.DBO.[FeatureClass]", ["*"], false);
var Join = Filter(related_records, "GlobalID = @f_gid");

// create and fill the update array
var updates = []
for(var record in Join) {
// updates is an array of dictionaries
// the dictionaries are built like this:
// {"globalID": "GID of the edited feature", "attributes": {"Field": value}}
var update = {"LocationGlobalID": record.GlobalID, "attributes": {"GdBOrderNumber": record.GdBOrderNumber}}
Push(updates, update)
}

// apply the edits
return {
"edit": [
{
"className": "Database.DBO.[Table]",
"updates": updates
}
]
} 

[JohannesLindner · Accepted solution]

Ah OK, in that case, you're editing the $feature itself, which makes it a little easier:

// calculation attribute rule
// triggers: insert(, update)
// field: GdBOrderNumber

var f_gid = $feature.LocationGlobalID;
var related_records = FeatureSetByName($datastore, "Database.DBO.[FeatureClass]", ["*"], false);
var Join = Filter(related_records, "GlobalID = @f_gid");

// return GdBOrderNumber of the first feature in Join
// if Join is empty (no related features found), return null
var firstJoin = First(Join)
if(firstJoin == null) {
    return null
}
return firstJoin.GdBOrderNumber

// or, if you leave the field parameter empty:
return {
    "result": {"attributes": {"GdBOrderNumber": firstJoin.GdBOrderNumber}}
}

[GdB_Admin]

@JohannesLindner that is what i was looking for thank you for your help