The Search function finds records in a table that contain a string in one of their columns. For more information, see the examples below and working with record scope. The As operator can also be used to name the record being processed which can help make your formula easier to understand and make nested records accessible.
Use the ThisRecord operator or simply reference fields by name as you would any other value. Besides the normal formula operators, you can use the in and exactin operators for substring matches.įields of the record currently being processed are available within the formula. Records that result in true are included in the result. Use LookUp to find a single record that matches one or more criteria.įor both, the formula is evaluated for each record of the table. The LookUp function finds the first record in a table that satisfies a formula. Use Filter to find a set of records that match one or more criteria and to discard those that don't. The Filter function finds records in a table that satisfy a formula.
0 kommentar(er)
