Help

FILEMAKER PRO HELP 1291
4. Click OK.
Examples
Name: $abc
Value: fieldName * 10
Repetition: 10
Set Variable [$abc[10]; Value: fieldName * 10]
Name: $$abc
Value: “xyz”
Repetition: 1
Set Variable [$$abc; Value: “xyz”]
Name: $CurrentUser
Value: Get(UserName)
Repetition: 1
Set Variable [$CurrentUser; Value: Get(UserName)]
Name: $$TaxRate
Value: 1 if the field City contains the value “San Francisco”, 2 if City is “New York”, 3 if City is
“Miami”,
0 if it’s none of those values.
Repetition: 1
Set Variable [$$TaxRate; Value: Case ( City = “San Francisco” ; 1 ; City =
“New York” ; 2 ; City = “Miami” ; 3 ; 0 )]
Related topics
Let function
Set Variable script step
Defining repeating fields
Edit Expression dialog box
This dialog box appears so you can specify which expressions you want to monitor with the Data
Viewer.
To specify an expression:
1. Select the database file containing the expression.
2. Build or edit the expression you want to monitor.
To add a Do this
Reference to a field In the field list, double-click a field name.
To display field names from another table, choose a table from the
table list.
Mathematical or text operator Type an operator.
Comparison or logical operator For Operators, click a button or double-click an operator from the
list.
Constant value Type the value.
Function In the functions list, double-click a function. In the formula box,
replace the placeholder parameter with a value or expression.