< Day Day Up > |
IsEmpty()Category: Logical Syntax: IsEmpty ( expression ) Parameters: expression ”typically a field name , but can be any valid FileMaker Pro calculation formula Description: Returns 1 (True) if the referenced field is empty or if the expression returns an empty string. Returns (False) if the field or expression is not empty. Examples: IsEmpty (myField) Returns 1 if myField is empty. IsEmpty (Name_First & Name_Last) Returns 1 if the result of concatenating the two fields together is an empty string. Comments: Remember that zero is a valid entry for a number field. If a number field contains a 0, it is not considered to be empty. |
< Day Day Up > |