topic map viewer, forms, and related data in ArcGIS Online Questions

map viewer, forms, and related data

clt_cabq — Thu, 15 Aug 2024 16:57:10 GMT

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?

Re: map viewer, forms, and related data

MarkBockenhauer — Fri, 23 Aug 2024 14:51:49 GMT

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

Re: map viewer, forms, and related data

clt_cabq — Fri, 23 Aug 2024 15:35:35 GMT

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!