Help

Table Of Contents

Creating a database

ILEMAKER PRO HELP 203

• Insert Picture

• Insert QuickTime

• Recover File

• Save a Copy as

• Save Records as Excel

• Save Records as PDF

• Send DDE Execute

• Send Event

• Send Mail (Attach File option)

Examples of using variables in file paths

Assume the following variables:

$fileName = "test.xlsx"

$username = "JohnSmith"

$searchList = "file:old results.txt

file:../archived/old results.txt"

Notes

• Variables are only supported in script steps that use stored file paths.

• Variables are not supported in file paths that are stored in container fields.

• Variables are not supported in FileMaker data source references.

• The data type of a variable is determined dynamically based on the assigned data. The

default data type is text.

Working with formulas and functions

A formula calculates a single value based on constants (such as 1.07 or “hello”), operators (such as

“+” or “>”), and field references (such as Subtotal or InvoiceTotal) you enter. For example, if sales

tax in your area is 7% and you have a field named Subtotal, you could create a field named

InvoiceTotal that gets the value of the formula

Subtotal * 1.07.

If a formula is especially common or popular, FileMaker Pro gives it a name and defines exactly how

you should use it. A named and predefined formula is called a

function. For example, if you want to

find the average of some test scores, you could write your own formula to add them all and divide by

the total number of scores. A simpler approach would be to use the function named

Average and

follow the rules defined for its use.