Auto fill a field based on value of another using Smart Editor Widget

Question

Hi,

I would like to use the Smart Editor Widget to populate a numeric value into another field based on what is selected in the 'Issue' dropdown pictured below.

The numeric value would then be inserted into the separate field 1, 2, 3 etc.

I thought I could use the new cool functionality within the widget and create a Smart Action with an expression whereby.

Flooding - No Property Risk would have a Reported Risk value of 2

Flooding - Property Risk would have a value of 1

The selection from the dropdown would auto fill Reported Risk.

I have tried Attribute Actions > Preset also but you can't build an expression which is what I think I weed need to do in order to allocate the numeric value?

Thankyou

RoseF · Answer

Going to dive into a similar situation but I want the selection of one field value to populate 4 or 5 others. @CMcDonald I'd love to hear which solution(s) you ended up using if you have a minute to share. Thanks!

CMcDonald · Answer

Hi @AlixVezina

A lot of really useful information there, this may end up being the best approach and so I'll need to set some time aside and do some testing.

Thanks 👍

avezina · Answer

@CMcDonald indeed ArcGIS Field Maps would involve a different workflow than the office-based one you've described. If I am not mistaken, the "smart forms" that are available in Field Maps will also be available in other ArcGIS products. In the article I mentioned above, this is described as follows:

"The form you build with the Field Maps web app is stored within the map. Smart form content is managed in the map so other ArcGIS apps can display the same form editing experience as the Field Maps mobile app." [...] "The first web app to use these forms is the Map Viewer beta – planned for release in 2021. If you add or edit features in the Map Viewer beta, you’ll be presented with the same form that the Field Maps mobile app displays."

If that works out the way it's described in the article, these capabilities should eventually become available in the Map Viewer (beta) and potentially ArcGIS Experience Builder.

Of course, that's not an immediate solution to your problem.

I did a bit more research and it appears a similar capability is supported in Survey123. Here's a video (a bit dated) that shows how it works: ArcGIS Survey123: XLSForm – Using Calculations in Your Surveys - Bing video - I assume there's lots more you can do today, please see related doc: Formulas—ArcGIS Survey123 | Documentation

I think you would need to use Survey123 Connect to build your form and leverage the formulas.

Survey123 forms can be used in a desktop browser and are also part of Experience Builder if you would like to display the web map and the survey into one app: Survey widget—ArcGIS Experience Builder | Documentation