Help

Table Of Contents

FILEMAKER PRO HELP 1285

Identifying text constants and special characters in formulas

Adding a new line to the results of a formula

Adding comments to a formula

Using a reserved word or symbol for a field or table name

Scripts reference

Specify Field dialog box

This dialog box appears so that you can choose a field.

1. Select the field you want in the list.

To choose a field in another table, choose the table from the tables list above the list of fields.

(You can also choose Manage Database to create a relationship or a table.) Then select a field

from the list of fields.

You can also click the Manage button to choose a field from the current or a related table,

if the button is visible.

Note When the Specify Field dialog box opens from within the Send Mail dialog box, the tables

list may default to Current Layout (LayoutName) and display only the visible fields on the

current layout. To display all field names from the current table, choose Current Table

(TableName) from the list.

2. If the field you’re specifying is a repeating field, for Repetition, enter which repetition you

want.

You can also click Specify to create a formula to calculate the repetition.

3. Click OK.

Examples of calculated repetition

In the following example, you create a script step that inserts text in a repetition based on the day.

You have a database that has a date field with seven repetitions. Each repetition represents a day of

the week starting from Sunday. If you run the script on a Wednesday, the calculation returns 4 and

the text is inserted in the fourth repetition.

Insert Text [Select; FileName::FieldName [DayOfWeek(Get (Current Date))];

Text.

In the following example, you create a script to clear the contents of a field with five repetitions.

count=1

Loop

Clear [Select;FileName::FieldName[count]

count=count+1

Exit Loop If [FileName::count=5]

End Loop