Database Reference
In-Depth Information
Percent
Choose Percent to turn the number into a percent value. FileMaker automatically multiplies
the number by 100, and puts a percent sign after it. That way, people can enter
.1
for 10 per-
cent. (Entering the number this way makes math with percentages easier, since you can
simply multiply. After all, 10 percent of 20 is 2, not 200. You'll learn how to do math in
FileMaker in the next chapter.) Your other choices under Percent are drawn from the Decim-
al option.
Date Formatting
The Date formatting works a lot like its number-oriented sister. This time, though, you tell
FileMaker how you want
dates
to look. This date could be the value in a date field, or the
date part of a timestamp field. For example, the date at the top of a letter may look best
spelled out, while the due date on a list of 25 invoices may best be served by an abbreviated
numbers-only format.
Figure 8-14
shows the Date formatting section on the Inspector (no
surprises here: Just click the button with the calendar icon).
