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 )
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Perform Script and script parameter examples
Was this topic helpful? Send feedback.