Functions Reference

Chapter 8
|
Logical functions 133
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 )
Lookup
Format
Lookup(sourceField{;failExpression})
Parameters
sourceField - the field from which the lookup value is taken.
failExpression - any expression.
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the contents of sourceField, using the relationships in the relationships graph.
The result of the optional failExpression will be returned if the lookup fails. In order
for this function to access the contents of the source field, the tables
containing the source
field and calculation field need to be related. Calculations using the Lookup function won’t
be forced to be unstored calculations
.