FINDMANY
Lookup fields in related datasources which contains multiple rows (e.g. lookup an employee's schedule when processing a timecard)
Example Usage
FIND('Employee', 'Exempt') -> 'true'|'false' or 1|0
FIND('Employee', 'HireDate') -> '2022-02-08'
FIND('Location', 'Code') -> the code corresponding to the employees home location
FIND('test', 'test') -> 'TestResult' // used to test when there is no data
FIND('Employee', ) -> {"EmployeeNumber":"1234"
Overview
Function signature
FINDMANY(source, column, value, returncolumn)
Category
Database
Return data type
None
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
source | string | Name of the related datasource to return | |
column | string | Column to search on | |
value | string | The data value to search for | |
returncolumn | string | The column to return |