Script Steps Reference

22 FileMaker Script Steps Reference
Else If
Format
Else If [<Boolean calculation>]
Options
Click Specify to define the Boolean calculation. In the Specify Calculation dialog box, type
the calculation you want evaluated, or use the field list (on the left) and the functions list
(on the right) with the mathematical and text operators to build the calculation.
Web compatibility
This script step is web-compatible.
Description
Like the If script step on page 21, Else If evaluates a Boolean calculation and performs a
conditional action based on that evaluation. The Else If script step must follow an If step
or another Else If step; it can’t follow an Else script step.
When an If script step calculation evaluates to True (not zero), FileMaker Pro performs
the steps that are indented under it. When an If script step evaluates to False (zero), script
execution moves to any following Else Ifs as long as they evaluate to False. When an Else
If statement evaluates to True, the block of steps under the Else If is executed. An
evaluation of True ends the Else If process, and upon reaching the next Else If or Else
statements, execution will skip ahead to End If.
Example
If [Get (AccountName) = "Jim Davis"]
Go to Layout [“File One”]
Perform Find [Restore]
Else If [Get (AccountName) = "Julia Vargas"]
Go to Layout [“File Two”]
Perform Find [Restore]
Else If [Get (AccountName) = "Gerard LeFranc"]
Go to Layout [“File Three”]
Perform Find [Restore]
Else
Go to Layout [“File Four”]
Show All Records
End If
Note In this example, Get(AccountName) only returns usable values if database users log
in using assigned account names. If no accounts are created or required, Get
(AccountName) returns the default value ‘Admin’.