Lookup Formula
Introduction
Sapper supports a variety of lookup formulas. Those are mentioned in this section.
- 1 Introduction
- 2 Formulas
- 2.1 LOOKUPVALUE
- 2.2 LOOKUPALLVALUES
- 2.3 LOOKUPLASTVALUEMATCH
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 |