Auto-populate a permanent field based on Arcade Expression

1890
5
04-19-2019 02:16 PM
Status: Open
Occasional Contributor

Hello,

It would be very helpful in ArcGIS Online if a layer could have a permanent field that is set up with an arcade expression that the field uses to auto-populate its value based on information from another field as new records are created from map applications. 

For example, we track our time and each record has a CATEGORY (meeting, project, internal support, etc.) that we define for our new record. These categories are then defined as 1 of 4 bins for strategic DELIVERY classification (Alignment, Projects, Support, Value). I created a blank field that only I see on the back-end named DELIVERY, which I calculate each day using an arcade expression that reads the CATEGORY field and then based on that value will fill in the DELIVERY cell as either Alignment, Projects, Support or Value. This DELIVERY field is used to provide a bar graph in a separate WebApp Builder dashboard template application that was created for our IT coordinator.

Though I can define an attribute expression with an Arcade Expression that WILL auto-generate the attribute expression field in the map, this can only be seen and used in the map pop-ups and are not visible within any of the graphic widgets for the story maps. If we could define an arcade expression for a field and allow for auto-generation of a permanent field value, that would be very helpful in streamlining dashboard processing.

Thanks,

Kara

arcade expression‌ auto populate‌

5 Comments

In other words, implement Attribute Rules for ArcGIS Online...

I am trying to do this very thing. I have 6 fields in a sidewalk assessment map that I want summed into a 7th field for a total score of the 6 fields. I want this to occur on the fly as values are populated into those six fields. I am assuming nothing has been developed since this thread was created?

It would be great to do this. I can currently do it in Survey123, but as Survey123 has very limited options for recording line geometry I would like to be able to populate a field based on other fields (in this case, an average) as a form is filled out in a webmap and in collector.

I assumed this was possible and quickly found out it was not, I'd love to see it added in!

In my case, I have to conform to a previously established schema, so I'd like to populate a custom GPS accuracy field with a simple expression that converts the value from the default ESRIGNSS_H_RMS field into feet. Again, could be done in Survey123 (but we have a security incompatibility that prohibits Survey123 from submitting data to an ArcGIS Server feature service) or it could be an extra processing step outside of Collector, but it would be much cleaner to have the functionality baked in.

Which is here