isNull ( text )

Checks to see if the input is NULL

Average rating: 4.6 (26 votes) Log in to vote

Derek Bastille - Show more from this author
University of Alaska Fairbanks

Sample input:

$foo = Null
isNull($foo)
$foo = ""
isNull($foo)

Sample output:

1
0

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
 * isNULL()
 *
 * Requires: Null
 * Param: text
 * Returns: 1 if the input is the Null tag and 0 otherwise
 */

Let( 
  in = text;

  If( in = Null; 1; 0 )
)

This is the companion function to Null. It can be used to check to see if a variable, string, etc. has been set to the value NULL. This can be very useful when testing input values that might be empty or when returning an error condition from a script or expression. I frequently use it in conjunction with get(ScriptParameter). As in:

Let(
in = get(ScriptParameter);

if( in = ""; Null; in)
)

Later, if I set a variable to NULL, then the variable won't 'disappear' like it would if I set it to ""

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

isNull ( text )

Comments

Support this website.

Support this website.