< Day Day Up > |
IsValid()Category: Logical Syntax: IsValid ( expression ) Parameters: expression ”typically a field name , but can be any valid FileMaker Pro calculation formula. Description: Returns either a 1 (True) or a (False), depending on whether the field or expression returns valid data. IsValid returns a if there is a data type mismatch (that is, text in a date field) or if FileMaker cannot locate the table or field that is referenced. Otherwise it returns 1 , indicating that the data is valid. Examples: IsValid (myField) Returns 1 (True) when myField is present and contains data appropriate to its defined data type. IsValid (Contacts::Name) Returns (False) if the current record has no related records in the Contacts table. |
< Day Day Up > |