nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

IF Else Statements in Arcade Expression

VyNguyen3

I try to create a Constraint Rule to limit the values for 2 fields which are applied 2 domains as Diameter (Double) and Material (Text). Here is my valid code and I've successfully added it. However, it always returns error when I edit feature attributes and I can't seem to understand why.

var diameter = $feature.DIAMETER;
if (diameter == [24,30,36,48])
{$feature.MATERIAL == [CI, SP]}
else if (diameter == [18,20])
{$feature.MATERIAL == DI}

I try with other valid code as follow but it doesn't work out anyway.

var diameter = $feature.DIAMETER;
if (diameter == 24 || diameter == 30 || diameter == 36)
{$feature.MATERIAL == CI || $feature.MATERIAL == SP}
else if (diameter == 18 || diameter == 20)
{$feature.MATERIAL == DI}

Please help me correct if I was missing st and just so you know I'm not a developer so I'm really bad at this.

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

Thanks for pointing out that you already posted the domains of the fields. You are also right about the topology. There is another type of attribute rule (validation rule) that will participate in topology, but I think it hasn't been implemented yet.

Looking at the domains, there is an error in the expression regarding reading the description. See the code below:

function IsValidMaterial<SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> valid_materials<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; var valid <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN>var i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> Count<SPAN class="punctuation token">(</SPAN>valid_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">+</SPAN><SPAN class="operator token">+</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>material <SPAN class="operator token">==</SPAN> valid_materials<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; valid <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> valid<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

var diameter <SPAN class="operator token">=</SPAN> DomainName<SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DIAMETER'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
var material <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>MATERIAL<SPAN class="punctuation token">;</SPAN>
var validation <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'24"'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">|</SPAN><SPAN class="operator token">|</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'30"'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">|</SPAN><SPAN class="operator token">|</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'36"'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">|</SPAN><SPAN class="operator token">|</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'48"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; var allowed_materials <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"CI"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SP"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> IsValidMaterial<SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> allowed_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> 
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'18"'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">|</SPAN><SPAN class="operator token">|</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'20"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; var allowed_materials <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"DI"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> IsValidMaterial<SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> allowed_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

... or perhaps better, just using the domain codes:

<SPAN class="keyword token">function</SPAN> <SPAN class="token function">IsValidMaterial</SPAN><SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> valid_materials<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> valid <SPAN class="operator token">=</SPAN> False<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>valid_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>material <SPAN class="operator token">==</SPAN> valid_materials<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; valid <SPAN class="operator token">=</SPAN> True<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> valid<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">var</SPAN> diameter <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>DIAMETER<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> material <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>MATERIAL<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> validation <SPAN class="operator token">=</SPAN> False<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">24</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">36</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">48</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> allowed_materials <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"CI"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SP"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="token function">IsValidMaterial</SPAN><SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> allowed_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> 
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">18</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> allowed_materials <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"DI"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="token function">IsValidMaterial</SPAN><SPAN class="punctuation token">(</SPAN>material<SPAN class="punctuation token">,</SPAN> allowed_materials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> True<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

To validate what is happening you could use the expression in a pop-up and see what is returned and add some Console statements for debugging.

All comments

XanderBakker

If my eyes don't deceive me I notice the diameter value being 20" (including the quote indicating inches). In case the field is a text field you will have to use a string comparison.Try this simple expression to see if assigning a value works:

<SPAN class="keyword token">var</SPAN> diameter <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>DIAMETER<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'24"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; $feature<SPAN class="punctuation token">.</SPAN>MATERIAL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"CI"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="string token">'20"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; $feature<SPAN class="punctuation token">.</SPAN>MATERIAL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DI"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In case the field is a field with a domain, the value should be handled differently.

VyNguyen3

Hi Xander, my goal is trying to insert or update attribute data in 2 fields of a feature class which are Diameter (Double) and Material (Text), assigned respectively with 2 Domain Code descriptions as below.

Technically, I want to apply the value of Material corresponding to the value of Diameter that I put in the code. Besides, I test with your code and the problem remains unsolved.

I dont really know that it could return the list of values in Arcade or not but I read somewhere that we could identify var result () and then return result in the code. I try many expression with this idea but never succeed.

Lastly, I test with the simple expression as you could see in the pic below but I failed to edit as well.

XanderBakker

There are multiple things going on in your code. If you apply the suggestion made by Dan in your code there will still be things that will not work:

you were not assigning a value to the MATERIAL when you used a double equal sign
You were assigning a variable "DI" (without the quotes). Does that exist in your code. I assume it should be a string so I included the quotes
In the first case you were assigning a list of variables CI and SP as result. What should this be? A string including the two values like "CI, SP" or a list of string values as shown in the code below (is this accepted, can you assign a list with values in this case?)
You were also missing some semicolons

<SPAN class="keyword token">var</SPAN> diameter <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>DIAMETER<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">24</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">36</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">48</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; $feature<SPAN class="punctuation token">.</SPAN>MATERIAL <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"CI"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SP"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">18</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">(</SPAN>diameter <SPAN class="operator token">==</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; $feature<SPAN class="punctuation token">.</SPAN>MATERIAL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DI"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

if (diameter == 24 || diameter == 30 || diameter == 36)

try

if ((diameter == 24) || (diameter == 30) || (diameter == 36))

Arcade seems to be missing an 'in' operator like python

if diameter in (24, 30, 36):

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.