topic Re: Customize Data or List Widget with Arcade in ArcGIS Experience Builder Questions

Customize Data or List Widget with Arcade

KateDoughty1 — Mon, 25 Mar 2024 15:19:11 GMT

I have a table that I'd like to:

1. Color records by an attribute;

2. Concatenate one field based on value in another field.

I've been trying to do this with arcade, but I can't seem to get it to read through each table record. My latest effort is below:

var test = $feature.Land_Use
var desc = []
for (var i in $feature){
iif ($feature.Determination == 'Compatible'){
var group = test[i]
Push(desc, group)}
If ($feature.Determination == 'Incomp'){
var group = test[i]
Push(desc, group)
}}
return Concatenate(desc, ', ')

Is what I'm trying even possible with arcade or does it require a custom widget?? The reason for wanting to use list or table is so the user can search. Table is attached. Any help or suggestions is much appreciated!! TIA

Re: Customize Data or List Widget with Arcade

MFazio — Mon, 25 Mar 2024 18:06:06 GMT

At a quick glance, I see you have an 'iif' statement which is technically an 'if-else' statement. So I believe it needs an argument to evaluate to if statement is true, and if the statement is false:

IIf(condition, trueValue, falseValue)

Re: Customize Data or List Widget with Arcade

KateDoughty1 — Mon, 25 Mar 2024 18:10:40 GMT

That is correct but it still doesn't fix the issue.

Re: Customize Data or List Widget with Arcade

JeffreyThompson2 — Tue, 26 Mar 2024 12:16:51 GMT

Experience Builder does not currently support Arcade.

Re: Customize Data or List Widget with Arcade

KateDoughty1 — Tue, 26 Mar 2024 13:45:05 GMT

Arcade is supported in pop-ups for Experience Builder which is where I'm trying to customize the output.

Re: Customize Data or List Widget with Arcade

JeffreyThompson2 — Tue, 26 Mar 2024 14:43:01 GMT

I'm not sure what your intent is with this table or your Arcade script, but here is some information you may find useful.

The Table Widget in Experience Builder supports searching and filtering.
Arcade has if statements and the IIF function. You are mixing the syntax between the two of them causing your IIf function to break.
Calling for( i in $feature) will loop through all of the fields in a feature with a feature being a single row in your table. You should probably be using $layer or $datastore, but I'm not sure how that would be very useful in this context either.
Because var test = $feature.Land_Use is outside the loop it's value will not change throughout the loop.