Functions Reference

Logical functions
F
ILEMAKER PRO FUNCTIONS REFERENCE 241
Once defined, local and global variables can be referenced in any calculation within their scope.
Local variables defined in a calculation are scoped to the file but are only available when scripts are
not running. A local and a global variable (or even two local variables in different scripts) can have
the same name but they are treated as different variables and store different values.
You can include an optional repetition number that appears in brackets [ ] immediately after the
variable name. For example:
Let ( [
$variable[repetition] = value;
$$variable2 = value2
];
calculation )
The Let function sets the variables from left to right. You can use previously defined variables (for
example, variables that you defined with the Set Variable script step) to define new variable values,
and you can nest one
Let function within another. If you use a previously defined variable within a
nested
Let function, the variable has scope only within the nested function (as if you had defined a
completely unique variable). See the City example below.
Examples
Let ( x = 5; x*x ) returns 25.
Let ( [ x = 5; squared = x*x; cubed = squared*x ]; cubed ) returns 125.
The following example returns San Francisco - Paris.
Let (
City = “Paris”;
Let (
City = “San Francisco”;
City & “-“
)
& City )
The following example sets a local variable to the current account's privilege set and returns the
contents of the variable. If this calculation is used in a script, the local variable would be available for
the duration of the script.
Let ( $PRIVILEGE_SET = Get(AccountPrivilegeSetName) ; $PRIVILEGE_SET )
returns [Full Access] if it is evaluated by an account with the Full Access privilege set.
The following example sets a local variable counter at repetition 50 with a value of 120:
Let ( $counter[50] = 120; $counter[50]*2 ) returns 240.
The following example shows how to pass named parameters using the Evaluate, Let, and
Get(ScriptParameter) functions, allowing access only to variable “a” (the example returns 6):
ScriptParameter = "a = 5; b = 10"
Evaluate (
"Let ( ["
& Get(ScriptParameter) & "
];
a+1 )"
)