All(Text values, Text list)

Returns true if all the values specified in its list argument exist in the values argument.

Parameters

values

The comma-separated list of values.

list

The comma-separated list of values to test.

Returns

Boolean

Examples

• All("A,B,C,D", "D,A") returns true.
• All("A,B,C,D", "D,E") returns false.

You can use this function in the filter of a view that asks the user for a checkbox column. For example, if there is a "Multiple Choices" text column in a table and you want the user to find records including an exact combination of choices asked by them, you can use the following formula in the filter of the view: Ask(All([Multiple Choices], [?Multiple Choices])).