LOOKUP
Usage
Use this function to return the value of a matching property of a collection given a confrontation parameter
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | COMPARISON | .VALUE |
Syntax:
1 |
|
Arguments
#Storage
the source storage entity
#Storage.Return_Field
the column field whose values will be returned
#Storage.Condition_Field
the column name used to check the condition and return the field value
Condition_Value
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Note
LOOKUP returns only one value. Can be used in VALUE arguments in CLIENT function only if its arguments are not value-parameterized on the cells of the client-UI rendered records.
Return Value
Value
Examples
Example 1
Formula
=LOOKUP(#StorageExample; #StorageExample.Column_1; #StorageExample.Column_2 == 1)
Description
Take from Storage StorageExample the value of the Column_1 where the Column_2 of the Storage StorageExample matches with value 1
Result
One value of the Column_1
Example 2
Formula
=LOOKUP(#StorageExample; #StorageExample.Role; #StorageExample.Email == $CURRENTUSER.EMAIL)
Description
Take from Storage StorageExample the value of the column Role where the column Email of the Storage StorageExample matches with current User email
Result
Role of the current User
Example 3
Formula
=LOOKUP(
#StorageExample_1;
#StorageExample_1.Role;
#StorageExample_1.Email == #StorageExample_2.Email.VALUE
)
Description
Take from Storage StorageExample_1 the value of the column Role where the column Email of the Storage StorageExample_1 matches with the value of the column Email of the Storage StorageExample_2
Result
Role linked to the Email of the StorageExample_2