Hi Adam
I have some code that does something similar that you should be able to adapt. On any feature Insert or update, it queries a table, t.Road_atr, for a related record and updates that record with a value from the feature being updated.
//get the road_atr record
var results = FeatureSetByName($datastore, 'T.Road_atr', ['GlobalID', 'FNODE', 'TNODE', 'ObjectID'], false)
var roadsegid = $feature.roadsegid
var atrset = Filter(results, 'roadsegid = @roadsegid');
if(Count(atrset) > 0){
var atr = First(atrset);
console(atr.objectID);
// atr.GlobalID,
return {
'edit': [{
'className': 'T.Road_atr',
'updates': [{
'objectID': atr.objectID,
'attributes':{
'FNODE': $feature.from_interid,
'TNODE': $feature.to_interid
}
}]
}]
}
}