Arcade expression with 2 fields

JenJoern

Was hoping to get help with an Arcade Calculator issue. I have two field names I am referencing and 4 possible outcomes to populate a new text field.

I have an integer field as well as a text field that is domain driven. The end result is a simple text return: (Pass, Fail, No Locate, Other). 

If the number field = 1, and domain field = Full, then = Pass

If the number field = 1, and domain field = Dim, then = Fail... and so on.

Any Arcade wizards out there willing to help? I made a couple rough attempts, but am having trouble with referencing 2 different fields.

Thanks!

kenbuja

One problem you might be running into is when you're using a domain, you have to either make your evaluation with its label or use DomainName to use its code.

For example if DomainField is set up like

Label	Code
1	Full
2	Dim

then you'd either use

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>DomainField <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> ‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

or

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DomainField'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Full'</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

For your calculator, one way of evaluating your two variable would look something like this

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>NumberField <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
  <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>DomainField <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> ‍‍<SPAN class="punctuation token">{</SPAN> <SPAN class="comment token">// if (DomainName($feature,'DomainField') == 'Full')‍‍</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'Pass'</SPAN><SPAN class="punctuation token">;</SPAN>
  <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>DomainField <SPAN class="operator token">==</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> ‍‍ <SPAN class="punctuation token">{</SPAN> <SPAN class="comment token">//if (DomainName($feature,'DominField') == 'Dim')‍‍</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'Fail'</SPAN><SPAN class="punctuation token">;</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="comment token">//etc‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trevor Frame.jpeg