Script Steps Reference

Appendix A
|
Glossary 163
Formula
A set of instructions that FileMaker Pro follows to calculate a value used in a field or as
the criteria for matching database records.
Found set
The set of records in a table that are made active by a find request. When you find all
records, the found set is the entire table.
Full Access privilege set
One of the three pre-defined privilege sets that appear in every file. The Full Access
privilege set allows complete read/write access to a file, including making changes to
privileges for the file.
Fully qualified name
The complete name of a field or layout, expressed using the format tableName::[field or
layout name], where “tableName” is the name of the underlying table occurrence in the
relationships graph upon which the field or layout is based. A fully qualified name identifies
an exact instance of a field or layout. Because fields and layouts with common names can
be based on different tables, FileMaker Pro uses fully qualified names to avoid errors in
calculations and scripts.
Function
A predefined, named formula that performs a specific calculation and returns a single,
specific value.
Function list separator
The punctuation character (a semicolon) that separates parameters in a function
definition. If you type a comma, FileMaker Pro automatically changes it to a semicolon
after you close the Specify Calculation dialog box.
G
GIF (Graphics Interchange Format)
A platform-independent file format often used to distribute graphics on the Internet.
Global field
A field defined with the global storage option can contain one value that's used for all
records in a file. Use the value of a global field as a fixed value in calculations, to declare
variables in If or Loop script steps, or for fields that rarely need to be updated (for example,
a company logo in a container field). A global field can be any field type except summary.
A global field can’t be indexed.
Grand summary
Total or other aggregate value for all records in the found set.