isNull ( text )
Checks to see if the input is NULL
Average rating: 4.6 (26 votes) Log in to vote
University of Alaska Fairbanks
$foo = ""
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 ""
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.