User manual

vi FileMaker Pro User’s Guide
Summarizing data in portals 8-12
Defining lookups between files 8-13
Defining lookups 8-13
Accessing related data from a third file 8-14
Creating many-to-many relationships 8-15
Chapter 9
Protecting databases with passwords and groups
Defining passwords 9-1
Deleting or changing passwords 9-3
Defining groups 9-3
Deleting or changing groups 9-5
Passwords and groups: a comparison 9-6
Chapter 10
Creating scripts to automate tasks
About scripts 10-1
Creating scripts: an overview 10-3
Planning scripts 10-3
Storing settings before creating a script 10-4
Defining scripts 10-4
About ScriptMaker steps 10-6
Control script steps 10-6
Navigation script steps 10-6
Sort, find, and print script steps 10-7
Editing script steps 10-7
Fields script steps 10-7
Records script steps 10-8
Windows script steps 10-8
Files script steps 10-8
Spelling script steps 10-9
Open Menu Item script steps 10-9
Miscellaneous script steps 10-9
Changing scripts 10-10
Duplicating, renaming, or deleting scripts 10-10
Deleting scripts 10-10
Importing scripts 10-11
To import a script 10-11
Listing scripts in the Scripts menu 10-11
Using buttons with scripts 10-12
Defining buttons 10-12
Copying, changing, or deleting buttons 10-13
Example of a ScriptMaker script 10-13
Finding duplicate records 10-13
Chapter 11
Using formulas and functions
About formulas 11-1
Expressions 11-2
Constants 11-2
Field references 11-2
Operators 11-3
About functions 11-5
Text functions 11-5
Number functions 11-6
Date functions 11-7
Time functions 11-7
Aggregate functions 11-7
Summary functions 11-8
Repeating functions 11-9
Financial functions 11-9
Trigonometric functions 11-10
Logical functions 11-10
Status functions 11-10
Design functions 11-12
External functions 11-13