Sapper supports a variety of lookup formulas. Those are mentioned in this section.
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 |
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 |
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 |