topic Re: Arcade IIF statements and using 'OR' in ArcGIS Online Questions

Arcade IIF statements and using 'OR'

collegekid_96 — Tue, 20 Sep 2022 15:25:06 GMT

Hi everyone,

I have the following arcade IIF statement:

var redcolor = IIf($datapoint.STATUS == 'SCHEDULING','#ff0000','#228B22')

Im using this statement for the Advanced Formatting section for my List.

Im trying to come up with a scenario where can have something like this :

var redcolor = IIf($datapoint.STATUS == 'SCHEDULING' OR $datapoint.STATUS CONTAINS TEXT 'SCHEDULED' ,'#ff0000','#228B22')

Where I can implement an OR expression and also some sort of CONTAINS function to find records with those characters. I have yet to see any documentation for Arcade.

Thanks,

Re: Arcade IIF statements and using 'OR'

KenBuja — Tue, 20 Sep 2022 15:37:01 GMT

For the "OR" expression, use the Logical Or operator "||". Use the Find function to will check if a string of characters within a text value.

var redcolor = IIf($datapoint.STATUS == 'SCHEDULING' || Find($datapoint.STATUS, 'SCHEDULED') > -1 ,'#ff0000','#228B22')

Re: Arcade IIF statements and using 'OR'

collegekid_96 — Tue, 20 Sep 2022 16:06:15 GMT

Thank you so much!