Functions Reference

Get functions
F
ILEMAKER FUNCTIONS REFERENCE 176
Get(ScriptParameter)
Purpose
Returns the script parameter passed into the current script.
Format
Get(ScriptParameter)
Parameters
None
Data type returned
text
Originated in
FileMaker Pro 7.0
Description
Use this function as part of a calculation evaluated within a script.
Note For information on how functions evaluate differently on the host versus the client, search the
FileMaker Knowledge Base available at http://help.filemaker.com
.
Examples
Returns Print when “Print” was the value of the parameter passed into the current script.
The following example shows how to pass a return-delimited list as the parameter.
ScriptParameter = List ( Customers::First; Customers::Last )
LeftValues ( Get ( ScriptParameter ) ; 1 ) returns Michael if Customers::First is
"Michael".
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 )" )
The following example shows how to pass named parameters, allowing access to both variable “a”
and “b”. The simplified first parameter makes the second parameter more complex (the example
returns 6, 12):
ScriptParameter = "a = 5; b = 10"
Evaluate("Let ( [" & Get(ScriptParameter) & "]; a + 1 & \", \" & b + 2 )" )
The following example shows how to pass named parameters, while keeping the ability to check the
syntax of the second parameter of the Let function (the example returns 6, 12):
ScriptParameter = "a = 5; b = 10"
Let( [a = Evaluate("Let( [" & Get(ScriptParameter) & "]; a )");
b = Evaluate("Let( [" & Get(ScriptParameter) & "]; b )")];
a + 1 & ", " & b + 2 )