Database Reference
In-Depth Information
Figure 9-10. This calculation checks for two conditions and uses an
or
operator. One comparison
checks to see if the length is five, while the other looks for a length of 10. If either is True, then your
calculation is True as well, and FileMaker accepts the Zip code. If both conditions fail, then the
calculation result is False, and FileMaker shows you an error message. This example has extra
spaces and paragraph returns for readability. Notice that the calculation's label (where the field's
name normally appears) in the Specify Calculation window reminds you that you're writing a cal-
culation for a validation, and not for the field itself.
