Arcade expression to symbolise attribute from related table for most recent date only that will also show in collector

CraigGadaloff

Hi,

Is there a way that I can update the symbology of my feature class based on the most recent attribute value entered into a related table (in collector and/or AGOL/Pro). 

I have a point feature class with a related table where the 'project status' is added as a new record each time it is changed.  I need to symbolise the most recent status. This must show up straight away in collector as well as in AGOL (upon sync if needed).

Is there an arcade expression(?) for this that is also compatible in collector?

XanderBakker

Hi Craig Gadaloff ,

Defining symbology does not allow you to dynamically connect to a related table. This would requiere a FeatureSetBy* function and those are not available in the symbology profile. There are also limitations in Collector for the support of Arcade, but as far as I know the beta ArcGIS Field Maps has better support for it. If you would work with Enterprise you could use Attribute Rules to achieve the goal, but there is not support in AGOL for Attribute Rules at the moment. You could probably schedule a task in Pro with a Field Calculation and an Arcade expression to update the information, but it will depend of the frequency of the scheduled task if the data reflects the changes.

What I have seen before is that the feature itself contains the state of the project that should be changed when adding another additional record. This will have support everywhere in the platform.