User manual

5-10 FileMaker Pro User’s Guide
3. In the Options for Field dialog box, click the Validation tab and
select options.
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 Select Strict data type, then choose
for the month and day, and four digits 4-Digit Year Date from the list.
for the year (for example,
5/12/2004)
Is a time containing numeric values Select Strict data type, then choose Time
for hours and minutes between 00:00 of Day from the list.
and 23:59 (seconds are optional)
Is not empty, or that the value is Select Not empty, Unique, or Existing.
unique or already existing in the file
(FileMaker Pro ignores capitalization
and punctuation)
Matches a value in a specified value Select Member of value list, then choose
list 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.
Click Validation
Select validation
options for the field
4. Specify how FileMaker Pro handles an invalid entry.
To Select
Prevent users from entering invalid data Strict: Do not allow user to override
(users must correct the data before moving validation
out of the record)
Display a custom message when the data Display custom message if validation
doesn’t meet the validation requirements fails, then type up to 255 characters
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.