topic Re: Calculate field using Arcade expression in ArcGIS Survey123 Questions

Calculate field using Arcade expression

Bryan_Wade — Tue, 19 Jul 2022 19:48:28 GMT

I have a feature layer with a mishmash of values that should be the same. IE: Features that should be marked as "Reviewed" might be "Reviewed" or "reviewed", resulting in a legend with 4x classes instead of two?

Wade_Bryan_0-1658260007473.png

This issue occurred when I updated and republished my survey. It was suggested I recalculate the field using an arcade expression. I have never done this before and was hoping someone could give me an idea of how to go about it.

Re: Calculate field using Arcade expression

jcarlson — Tue, 19 Jul 2022 20:58:46 GMT

If you go to the Data tab of your item and look at the Table, clicking a field heading lets you open up the Field Calculator. I would suggest using SQL for this, but either SQL or Arcade will work.

Arcade:

var s = $feature.status return When( Find('ubmitted', s) != -1, 'Submitted', Find('eviewed', s) != -1, 'Reviewed', s )

By using Find, we can tell our expression to return "Submitted" any time it finds 'ubmitted' in the field value and so on, which would account for capitals, extra spaces at the beginning / end.

In SQL, we can use LIKE, which is a bit more straightforward to me, but works on the same principal:

CASE WHEN status LIKE '%ubmitted%' THEN 'Submitted' WHEN status LIKE '%eviewed%' THEN 'Reviewed' ELSE status END

In both cases, we leave unmatched values at their initial value. The lists of conditions can easily be expanded for other statuses.

Re: Calculate field using Arcade expression

Bryan_Wade — Wed, 20 Jul 2022 14:58:19 GMT

When I use the arcade expression I end up getting this error message:

Execution Error:Runtime Error: Identifier Not Found. reviewed

Any thoughts?

Re: Calculate field using Arcade expression

jcarlson — Wed, 20 Jul 2022 15:27:03 GMT

What's the actual expression you're using?

Re: Calculate field using Arcade expression

Bryan_Wade — Wed, 20 Jul 2022 19:32:15 GMT

I was able to get it to work. but when I go to the map I'm still getting this:

Wade_Bryan_0-1658345368085.png

Also, the indicator tiles in my dashboard are not picking up the field 'Status' correctly. I have a tile with a filter set for reviewed and one for submitted.