Functions Reference

Table Of Contents

FILEMAKER FUNCTIONS REFERENCE 166

Examples

Let(x=5;x*x) returns 25.

Let([x=5;squared=x*x;cubed=squared*x];cubed) returns 125.

Let(City=“Paris”;Let(City=“San Francisco”;City&“-“)&City) returns San

Francisco

- Paris.

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 )" )

The following example shows how to pass named parameters, allowing access to both variable “a”

and variable

“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 )