Very informative !
These are functions to find one or more records in a table.
| Matches by a formula or a single string * | Multiple formulas accepted |
Returns multiple records or a single record |
Returns the subset of the original dataset or one value | No record found | Function to check if no record found | |
| Filter | Formula | Yes | Multiple | Subset | Empty table | IsEmpty |
| Search | String | No | Multiple | Subset | Empty table | IsEmpty |
| Lookup | Formula | No | First Single | One value | Blank | IsBlank |
*The formula is evaluated for each record of the table. Records that result in true are included in the result. Besides the normal formula operators, you can use the in and exactinoperators for substring matches.
Fields of the record currently being processed are available within the formula. You simply reference them by name as you would any other value. You can also reference control properties and other values from throughout your…
View original post 287 more words
Advertisements
