How to Return a Null Value in Attribute Rule

ChristopherEarley

We are using the Add Attribute Rule tool to execute an arcade script (Script 1). This is for an app we are developing. I want the script to return null in the “PlannedClosureStart” date field (line 3) when “No” is input in the “PlannedClosure” text field (line 0). However, when I try to add this the tool returns the error “ERROR 000358: Invalid expression Failed to execute (AddAttributeRule)”.

 

Is it possible to add null values to date fields in an arcade script?

 

Script 1

 

var PlannedStart = $feature.PlannedClosure;

if (PlannedStart=="Yes") {

    return $feature.PlannedClosureStart

}

else return null

XanderBakker

There is currently a BUG reported when you try to return a null value in Arcade: See How to return null in Arcade with Calculate Field (python works fine)? 

I would probably change the expression like this (although your code does not yield a compile error):

<SPAN class="keyword token">var</SPAN> PlannedStart <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>PlannedClosure<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>PlannedStart<SPAN class="operator token">==</SPAN><SPAN class="string token">"Yes"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> $feature<SPAN class="punctuation token">.</SPAN>PlannedClosureStart<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="keyword token">null</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>

Is you field configured to allow null values?