Introduction
Sapper supports a variety of lookup formulas. Those are mentioned in these sectionsthis section.
| Table of Contents | ||||
|---|---|---|---|---|
|
Formulas
LOOKUPVALUE
Description | Returns the first match value from the lookup table. |
Syntax | Expression: ('lookup', 'EmpId', '1003', 'Designation') Return Type: Object |
Example | Expression: ('lookup', 'EmpId', '1003', 'Designation') Result: Sr.Executive |
LOOKUPALLVALUES
Description | Returns the all sr.executive employee Id from table. |
Syntax | Expression: ('lookup', 'Designation', 'Sr.Executive', 'EmpId') Return Type: list |
Example | Expression: ('lookup', 'Designation', 'Sr.Executive', 'EmpId') Result: 1003, 1005, 1009, 1010 |
LOOKUPLASTVALUEMATCH
Description | Returns the Last match value from the lookup table. |
Syntax | Expression: ('lookup', 'Designation', 'Sr.Executive', 'EmpId') Return Type: Object |
Example | Expression: ('lookup', 'Designation', 'Sr.Executive', 'EmpId') Result: 1010 |