User manual

Defining database fields | 87
Procedures for working with formulas and a reference to all FileMaker Pro
functions (organized alphabetically or by category) are available in Help.
9. Select calculation options for the field.
Constant value Type the value. A constant can be text, number, date, or time.
Use date constants with the functions Date and GetAsDate,
time constants with the functions Time and GetAsTime, and
timestamp constants with the functions Timestamp and
GetAsTimestamp.
Text constants can be up to 29998 characters long.
Function In the functions list, double-click a function (a predefined,
named formula that performs a specific calculation and returns
a single, specific value). In the formula box, replace the
placeholder parameter with a value or expression.
To add a Do this
Choose field
references
Formula box
Select comparison and
logical operators
Select
functions
Choose a
formula
result type
Choose
indexing and
storage options
Make the calculated
field repeating
Choose a table
from the list
Calculate only if at least one
field in the formula has a value
Select mathematical and
text operators
Choose the
way functions
are listed in
the dialog box
Choose the table from which the
calculation will be evaluated
Click to display
online Help on
defining
calculations
φμπ10_υσερσ_γυιδε.βοοκ Παγε 87 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ