<turbo-stream action="update" target="wiki_99_subpage_3588_info"><template>
<h1>IsBlank(expr)</h1>
<p>The IsBlank(expression) function takes a field or an expression and return 1 (or true) if that field is blank or null or if the expression evaluates to a blank or null value.</p>
<p><span><strong>&nbsp;</strong></span></p>
<p><span><strong>Example:</strong></span></p>
<p><span>IsBlank("Fax No.")&nbsp;&nbsp;&nbsp; ---&gt;&nbsp;&nbsp; 1 (true) if the field "Fax No." is blank or null, otherwise 0 (false)</span></p>
<p><span>IsBlank(DBLookup('DESTDS','User','Alias',"Salesperson",'Id'))&nbsp;&nbsp; ---&gt; 1 (true) if the DBLookup function does not find a User for this Salesperson, otherwise 0 (false)</span></p>
<p><span>&nbsp;</span></p>
<p><span><span>The formula<br></span><span><strong>##IF(EQUALS(TAXGROUP,''),0,1)</strong>&nbsp;</span></span></p>
<p><span>can now be written like</span></p>
<p><span><strong>##IF(ISBLANK(TAXGROUP),0,1)&nbsp;</strong>&nbsp;or even shorter like&nbsp;<strong>##1-ISBLANK(TAXGROUP)</strong></span></p>
</template></turbo-stream>
<turbo-stream action="prepend" target="flash"><template></template></turbo-stream>
