idea Auto-populate a permanent field based on Arcade Expression in ArcGIS Online Ideas

Auto-populate a permanent field based on Arcade Expression

KaraUtter — Fri, 19 Apr 2019 21:16:41 GMT

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‌

Re: Auto-populate a permanent field based on Arcade Expression

XanderBakker — Wed, 22 May 2019 22:39:23 GMT

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

Re: Auto-populate a permanent field based on Arcade Expression

GeneSipes1 — Tue, 14 Jan 2020 15:49:15 GMT

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?

Re: Auto-populate a permanent field based on Arcade Expression

JamesWilson2 — Mon, 20 Jan 2020 01:11:49 GMT

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.

Re: Auto-populate a permanent field based on Arcade Expression

AaronWipf — Thu, 16 Apr 2020 21:31:17 GMT

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.

Re: Auto-populate a permanent field based on Arcade Expression

KoryKramer — Tue, 22 Jun 2021 09:00:26 GMT

Which is here https://community.esri.com/ideas/16977

Re: Auto-populate a permanent field based on Arcade Expression

AlixVezina — Tue, 05 Jan 2021 22:58:00 GMT

Please review the following article published on 3 January 2021: Introducing smart forms in ArcGIS Field Maps (esri.com)

Near the bottom of the article:

Attribute rules – are user-defined rules that can be used to automatically populate attributes, restrict invalid edits, and perform quality assurance checks on existing features when they are submitted. Attribute rules are coming to hosted feature services and to forms so that you can execute business logic in your form connected or offline.

Smart forms may provide the capabilities you require moving forward.

Re: Auto-populate a permanent field based on Arcade Expression

SandraDalton — Tue, 11 May 2021 05:02:35 GMT

@AlixVezina Is there a timeline for attribute rules being implemented in AGOL hosted feature layers?

Re: Auto-populate a permanent field based on Arcade Expression

AlixVezina — Tue, 11 May 2021 15:38:44 GMT

@SandraDalton I don't know the details, but it looks like it's in the pipeline. No target date has been provided yet, that I am aware of.

Re: Auto-populate a permanent field based on Arcade Expression

BamJam — Fri, 10 Jun 2022 18:02:23 GMT

@AlixVezina I have a need to have placeholder value for some fields, but not a default value. I have feature templates that contain multiple feature types, and I'd like to have these placeholders dynamically defined for fields for each feature type. I know that HTML5 has the placeholder capability that would be perfect.

Is this possible within using Arcade, Smart Forms with Field Maps, or in the Smart Editor widget in WAB?

Also, is there an update to Attribute Rules for hosted feature services?

Re: Auto-populate a permanent field based on Arcade Expression

AlixVezina — Fri, 10 Jun 2022 18:38:37 GMT

@BamJam , for the Smart Editor and the Edit widgets in WAB, the best way to do something similar to a placeholder hint is to add a Hint for the field in the web map pop-up configuration (map viewer classic).

The hint will display in a tooltip when the field is in focus.

Re: Auto-populate a permanent field based on Arcade Expression

BamJam — Fri, 10 Jun 2022 22:02:08 GMT

@AlixVezina Thank you for the quick response! That is good, but it seems to apply to all the feature types for that layer when the user is attempting to add a new feature. I have a feature template that defines several feature types that the user can select to add to the map. The templates allow me to set default values for fields based on which feature type they choose, which is great. However, I would also like the hint to change based on the feature type that they select.

I was hoping I could use Arcade to dynamically change the hint based on the value of a field in the layer. Is this something that is possible?

Thanks,
Brandon

Re: Auto-populate a permanent field based on Arcade Expression

AlixVezina — Mon, 13 Jun 2022 15:33:16 GMT

@BamJam This is not currently possible and has similar requirements as the original idea in this post. This would be good enhancement to be implemented in the new forms once they fully leverage arcade and potentially attribute rules. Auto-populate a permanent field based on Arcade Ex... - Esri Community

Also please note that this will not be available in the Smart Editor.

Re: Auto-populate a permanent field based on Arcade Expression

AllisonGiffin — Thu, 30 Jun 2022 00:56:48 GMT

Another reason I am really hoping that sometime soon we can use smart forms with calculated attributes in WAB or allow Arcade expressions as preset attribute actions in the smart editor widget, is because it is so much easier (for me) to edit feature geometry in WAB than in Field Maps, both because using a mouse on a desk is easier than a stylus or your finger on a mobile device in the field, but also because location accuracy in Field Maps has been pretty inaccurate in my experience (I am getting 3-6 meter accuracy at best) unless I were to obtain a GNSS device to use with the Field Maps application.

However, while editing feature geometry is easier in WAB than in Field Maps, you cannot configure a field to automatically calculate geometry every time a new feature is added or an existing feature's geometry is edited in WAB. So it seems like the work flow has to be editing the feature geometry in WAB, saving, then opening Field Maps (that uses the same web map and feature layer just edited in WAB) just to trigger the automatic recalculation of the feature's geometry (by moving a vertex slightly or something) after editing the geometry in WAB.

Re: Auto-populate a permanent field based on Arcade Expression

AlixVezina — Tue, 19 Jul 2022 16:01:31 GMT

@AllisonGiffin , regarding the statement below:

you cannot configure a field to automatically calculate geometry every time a new feature is added or an existing feature's geometry is edited in WAB

What geometry attributes are you attempting to calculate? The Smart Editor widget provides some automatic calculations that can also be triggered on feature update.

If you are looking for coordinates, setup a Coordinate attribute action. You can set it to use the feature's location or "My Location" (so the user's current device location) to populate these coordinates.

Then in the Action Settings, set the attribute actions to also update when the geometry of the feature is updated.

There's a video where some of this is demonstrated here (starting around 4min35): https://youtu.be/2LdUvD9B_R4?t=276

Thought I'd mention this just in case it may fit your needs!

Re: Auto-populate a permanent field based on Arcade Expression

AllisonGiffin — Tue, 04 Apr 2023 21:20:51 GMT

Thank you Alix! Sorry I took a long time to respond to this. The features I am editing are polygons, and the geometry attribute I would like to automatically calculate is an SQL expression to calculate the square footage of each polygon feature. In Field Maps, the calculated square footage field automatically updates when I move a vertex on the polygon in Field Maps. However, moving vertices and drawing polygons is much harder in Field Maps than it is in WAB, but in WAB the feature won't automatically re-calculate since WAB does not support Smart Forms. I understand WAB is being deprecated and Experience Builder is the preferred application now though, so in the future I think everything should be fine as long as Experience Builder supports smart forms and calculated and contingent attributes.