Chapter 5. Calculation Signatures

Aggregate Functions

Aggregate functions apply to a group of fields in related records or repeating fields.

Table 5.1. Aggregate Functions

Date Functions

FileMaker offers a range of date manipulation functions, including those for the Japanese calendar.

Table 5.2. Date Functions

Design Functions

Design functions generally extract information about one’s database and are helpful in debugging or for advanced scripting.

Table 5.3. Design Functions

External Functions

External functions originate from installed plug-ins and vary widely based on the plug-ins used.

Table 5.4. External Functions

Financial Functions

Financial functions assist with various specialized mortgage and interest calculations.

Table 5.5. Financial Functions

Get Functions

Get functions generally pull information from a given user’s current state, be it from within FileMaker, from one’s computer, or from a given network.

Table 5.6. Get Functions

Logical Functions

Logical functions allow comparative tests to be evaluated and return differing results based on those comparisons. They also allow you to work with variables.

Table 5.7. Logical Functions

Number Functions

Number functions allow various mathematical expressions within FileMaker.

Table 5.8. Number Functions

Repeating Functions

Repeating functions facilitate working with repeating fields within other calculations.

Table 5.9. Repeating Functions

Summary Functions

Summary functions operate across multiple records based on a break field (sort criteria). The function in this category is the analogue of the sub-summary part within reporting.

Table 5.10. Summary Functions

Text Functions

Text functions provide all the various text parsing tools within FileMaker, some specialized and some general.

Table 5.11. Text Functions

Text Formatting Functions

Text formatting functions allow a routine or calculation to manipulate the actual formatting of data within text fields in FileMaker.

Table 5.12. Text Formatting Functions

Time Functions

Time functions provide a means of manipulating time data within FileMaker.

Table 5.13. Time Functions

Timestamp Functions

The Timestamp function allows developers to exchange or transform data between date, time, and timestamp data types.

Table 5.14. Timestamp Functions

Trigonometric Functions

Trigonometric functions extend math and number functions within FileMaker to trigonometry.

Table 5.15. Trigonometric Functions