lookup( multipleValues, dataToLookup, valueIfNotPresent )
Returns location of data within multiple values, or valueIfNotPresent.
Keyword | Type | Description |
---|---|---|
|
Any Type |
Values to lookup within. |
|
Any Type |
Value to lookup within multipleValues. |
|
Any Type |
Value to return if dataToLookup is not present. |
Integer
lookup({"a", "b", "c", "d"}, "c", -1)
returns 3
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Compatible | |
Process Events | Compatible |
lookup() Function