Auto populate a field from related record using Arcade calculated expressions

Question

Hi, I know it's possible to grab data from the related record (inventory) when adding in a new related table (inspection record) available here: Common calculated expressions for ArcGIS Field Maps (esri.com)

However, I have numerous feature classes (point, line and polygon) with one related table (for all inspection records). Does anyone know if you can use Field Maps Designers Arcade expression to ensure a field from the parent inventory layer (could be either point, line or polygon) can automatically populate the related table record?

cat206 · Answer

Hi,

Unfortunately not no, I tried the FeatureSet but because there are multiple, it fails to calculate

// Get the feature set for the hydrantsvar maintenance = FeatureSetById($datastore,'ff83973e1a074d4ab758fce9d88f5339', ['Maintenance_Type'], false)

// Get the first hydrant (should only be one)var maintenance2 = First(maintenance)
// If there was a hydrant, return the facilityid of it,// Otherwise, return nullif (!IsEmpty(maintenance2)) {    return maintenance2['Maintenance_Type']} else {    return null}

anbinh · Answer

Hey Cat,

Have you got any progress on this? I am also looking for the same thing as you.

Regards,

AB

cat206 · Answer

Thanks for commenting BlakeTerhune - I have tried to do this but i have numerous related layers going into one related table. See below screenshot when i try to use the related features:

So depending which layer the user with click on and add a related record to, I will need the ID field carried across - hopefully that makes a bit more sense?