User manual

5-10 FileMaker Pro User’s Guide
3. In the Options for Field dialog box, click the Validation tab and
select options.
4. Specify how FileMaker Pro handles an invalid entry.
5. Click OK to close the Options for Field dialog box, then click Done.
For more information about validating fields, choose Help menu >
Contents and Index, click the Index tab, and type validating data.
To verify that the entered value Do this
Contains only numbers Select Strict data type, then choose
Numeric Only from the list.
Is a date containing numeric values
for the month and day, and four digits
for the year (for example,
5/12/2004)
Select Strict data type, then choose
4-Digit Year Date from the list.
Is a time containing numeric values
for hours and minutes between 00:00
and 23:59 (seconds are optional)
Select Strict data type, then choose Time
of Day from the list.
Is not empty, or that the value is
unique or already existing in the file
(FileMaker Pro ignores capitalization
and punctuation)
Select Not empty, Unique, or Existing.
Matches a value in a specified value
list
Select Member of value list, then choose
an existing value list or define a new
one. (See “Defining a list of values for
data entry” on page 7-3.)
Falls within the range you specify Select In range, then type a starting
value and ending value.
Matches the result of a calculation Select Validation by calculation, define a
formula in the Specify Calculation
dialog box, then click OK.
The result must be Boolean—“true” or
“false,” “yes” or “no,” and so on. The
result is false when the result is 0 or null
(empty); otherwise the result is true.
For information about the Specify
Calculation dialog box, see “Defining
calculation fields” on page 5-5.
To Select
Prevent users from entering invalid data
(users must correct the data before moving
out of the record)
Strict: Do not allow user to override
validation
Display a custom message when the data
doesn’t meet the validation requirements
Display custom message if validation
fails, then type up to 255 characters
Select validation
options for the field
Click Validation