map viewer, forms, and related data

[clt_cabq]

I have a feature class with three 1:M related tables.  The features represent properties, the tables each reflect different periodic reviews that may occur for a given property. When a user creates a new record in one of the related tables, I'd like to update certain fields in the feature table so that the feature table contains the most recent information from a review. Can I trigger that sort of child-to-parent update from a form developed in the map viewer? 

[MarkBockenhauer · Accepted solution]

Yes, you can.

You can calculate a field in your feature class based on the value in a related table.  

One technique is to the set a value based on the most current related record.  This is an example of an Arcade pattern that can be used to do that.

var relatedRecords = First(orderBy(FeatureSetByRelationshipName($feature, 'relateTest_inspectionTable'),"CreationDate DESC"));

return relatedRecords.Status

[clt_cabq]

thank you - i have used a similar pattern for dashboards and such, i wasn't entirely certain if it would work in an editing scenario. I will play with this a bit!