topic Re: Arcade When Function Execution Error in ArcGIS Online Questions

Arcade When Function Execution Error

jfiacco — Wed, 25 Aug 2021 15:37:11 GMT

Hi,

I'm working on a Pop-Up configuration using an Arcade expression to display related fields based on attributes in another field. I'm trying to use a When expression that states, when the well location field equals a particular string, display related fields, otherwise display nothing. There are multiple related fields associated with one well location.

I keep getting the following error:

I've tried various versions of my expression to get rid of the error but nothing seems to be working. Here are examples of what I have tried so far:

When(($feature.wellLocation == 'A3'), ($feature.A3ArapCycles) && (TextFormatting.NewLine) && ($feature.A3ArapFlow), None )

When(($feature.wellLocation == 'A3'), ($feature.A3ArapCycles && TextFormatting.NewLine && $feature.A3ArapFlow), None )

When(($feature.wellLocation == "A3"), ($feature.A3ArapCycles && TextFormatting.NewLine && $feature.A3ArapFlow), None )

When(($feature.wellLocation == "A3"), ($feature.A3ArapCycles || TextFormatting.NewLine || $feature.A3ArapFlow), None )

Could someone take a look and let me know if anything stands out? I've looked at a lot of documentation but can't seem to figure out why I'm getting this error. I'm relatively new to Arcade so any information/ideas would be greatly appreciated.

Thanks!!

Jenna

Re: Arcade When Function Execution Error

KenBuja — Wed, 25 Aug 2021 16:01:21 GMT

To concatenate values, use "+"

When($feature.wellLocation == 'A3', $feature.A3ArapCycles + TextFormatting.NewLine + $feature.A3ArapFlow, 'None' )

Re: Arcade When Function Execution Error

jfiacco — Wed, 25 Aug 2021 16:06:42 GMT

Thanks, Ken.

That removed the error but it's still not recognizing the well location value so nothing is populated in the pop-up.

Re: Arcade When Function Execution Error

KenBuja — Wed, 25 Aug 2021 16:44:26 GMT

What are the possible values?

Re: Arcade When Function Execution Error

jfiacco — Wed, 25 Aug 2021 16:54:13 GMT

Here is a screenshot of the some of the attributes. I have over 700 fields. Each field has a prefix, in my form, indicating the specific well location. I only want to show the relevant fields for each well. So, for this well, I only want to show the attributes within the red box. I'm trying to figure out the correct expression/combination of expressions to parse down the attribute list based on the well location. Do you know of a LIKE statement or something similar that might work better than WHEN for this case?

Re: Arcade When Function Execution Error

KenBuja — Wed, 25 Aug 2021 18:00:58 GMT

You can use this type of syntax to get fields that have multiple prefixes

var test = "LAST"; return $feature[test + 'EDITOR']

This is using one of the profiles in the Arcade playground

Re: Arcade When Function Execution Error

KenBuja — Wed, 25 Aug 2021 18:24:31 GMT

What you could do is something like this

var array = ['ArapCycles', 'ArapFlow']; var output; for (var i in array) { output += $feature[$feature.wellLocation + array[i]] + TextFormatting.NewLine; } return output;

This is how it works in the Playground

Re: Arcade When Function Execution Error

jfiacco — Mon, 20 Sep 2021 17:23:42 GMT

Thanks Ken!

I ended up doing something similar. Instead of creating an array, I created a variable for each field associated with the various well houses and called them that way. It produced an output more along the lines of what I was looking for.

Example:

var RegencyArapFlow = $feature.RegencyArapFlow
var RegencyArapMeter = $feature.RegencyArapMeter
var RegencyArapLevel = $feature.RegencyArapLevel
var RegencyArapCycles = $feature.RegencyArapCycles
var RegencyButterfieldTankLevel = $feature.RegencyButterfieldTankLevel
var RegencyBradburyTankLevel = $feature.RegencyBradburyTankLevel
var RegencySysPressure = $feature.RegencySysPressure

var varRegency;
if ((!IsEmpty(RegencyArapFlow)) || (!IsEmpty(RegencyArapMeter)) || (!IsEmpty(RegencyArapLevel)) || (!IsEmpty(RegencyArapCycles)) || (!IsEmpty(RegencyButterfieldTankLevel)) || (!IsEmpty(RegencyBradburyTankLevel)) || (!IsEmpty(RegencySysPressure))){
varRegency += TextFormatting.NewLine +
"Arapahoe Flow: " + RegencyArapFlow + TextFormatting.NewLine +
"Arapahoe Totalizer: " + RegencyArapMeter + TextFormatting.NewLine +
"Arapahoe Level: " + RegencyArapLevel + TextFormatting.NewLine +
"Arapahoe Cycles: " + RegencyArapCycles + TextFormatting.NewLine +
"Butterfield Tank Level: " + RegencyButterfieldTankLevel + TextFormatting.NewLine +
"Bradbury Tank Level: " + RegencyBradburyTankLevel + TextFormatting.NewLine +
"System Pressure: " + RegencySysPressure + TextFormatting.NewLine
}
return varRegency

Thanks again for your help!