User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
42 FileMaker Pro User’s Guide
4. For Field Name, type a name for the field.
See “About naming fields” on page 39.
5. For Type, select Calculation.
You can enter a description of the field in the Comment box.
6. Click Create.
You see the Specify Calculation dialog box.
7. If necessary, for Evaluate this calculation from the context of, choose
a table from the list.
Setting the context for a calculation is only necessary when you’re
creating a calculation field in a
source table that has two or more
occurrences in the relationships graph. The source table is the table
defined in the
Tables tab of the Define Database dialog box. The
choice you make may affect the calculation results, particularly if
your calculation will include fields in related tables.
8. Build a formula for your calculation.
Click where you want the item to appear in the formula box, then do
the following. You can also type the formula into the box.
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.
To add a Do this
Reference to a field In the field list, double-click a field name.
To display field names from another table, choose a table
from the table list.
Mathematical or
text operator
In the keypad in the dialog box, click an operator.
(Quotation marks and parentheses are copied to the
formula as a pair, with the insertion point blinking in the
middle).
Comparison or
logical operator
For Operators, choose an operator from the list.
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