I have a bridge feature class with a related table of reports
After everything was built, got request to add a custom ID field to the related table that directly reference a field in my feature class.
Based on research, I need to grab the related GlobalID, filter my feature set, and return the needed field to calculate my custom ID.
For example, report 41 needs to have a field calculated to pull the bridge number associated with that report and.
This is what I was thinking but now I'm not sure I'm doing it right. Wish Pro had an Arcade Playground for testing functions in field calculator.
I am calculating the field in the related table.
I think I'm not accessing the filter result correctly...
// reference feature service
var fl = FeatureSetByName($datastore, 'PM_Bridges')
// read the associated bridge GlobalID stored in my related table
var bridgeGUID = $feature.REL_GLOBALID
//sql for filtering feature service
var sql = "GlobalID = '" + bridgeGUID + "'"
// go to bridge feature service & filter by GUID
var bridge = Filter(fl, sql);
//returns string - both fields already string type
var name = bridge.BRIDGENUM + " " + bridge.BMS
return name;