Brian Dunning's FileMaker Custom Functions

isNull ( text )

Checks to see if the input is NULL

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

Derek Bastille   Derek Bastille
University of Alaska Fairbanks

Share on Facebook Share on Twitter

  Sample input:
$foo = Null
$foo = ""
  Sample output:

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

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:

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 ""



Log in to post comments.


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

Under construction. Email me your wish list for improvements.