Returns true if some condition is met for every record in a list of records. Returns true for an empty list.
Function
every(condition)every(records)
Arguments
| Argument | Data Type |
| condition | Boolean list |
|---|---|
| result | Boolean |
Comments
The every function receives a list of records with some condition, and returns true if that condition is met for every record in the list. If there are one or more records that do not meet the condition, then the every function will return false.
If there are no records in the list then the every function will return true. Note that this is in deliberate contrast to the any function.
Example
The following calculation assumes it is running in the context of a person record. It will return true if every task assigned to that person is completed. It will also return true if the person has no assigned tasks. It will return true if the person has one or more tasks that do not have a state of 'Completed'.
every([Assigned Tasks].[Status] = 'Completed')