ALL

Use ALL to check if every item in a list meets a condition — all payments completed, all inventory in stock, all scores above minimum, all fields filled.

How it works

ALL(list, function(item: condition))

list - Items to check
condition - Test that must be true for each item

Returns true if every item passes, false if any item fails.

Examples

Verify all payments are completed

Check that no pending payments remain before closing an order.

ALL(PAYMENT_LIST, function(PAYMENT: PAYMENT.STATUS = "Paid"))

Returns true only if every payment shows "Paid".

Confirm all required fields are filled

Validate a form before submission.

ALL(ARRAY(NAME, EMAIL, PHONE), function(FIELD: NOT(ISEMPTY(FIELD))))

Returns true only if all three fields have content.

Check all products are in stock

Ensure order can be fulfilled.

ALL(ORDER_ITEMS, function(ITEM: ITEM_STOCK > 0))

Returns true if every item has stock available.

Common mistakes

Empty lists return true - An empty list has no items that fail, so ALL returns true. Check length first if this matters.
Using ALL when you only need one - If you just need to check that at least one item passes, use SOME instead.

When to use alternatives

Need at least one match: Use SOME
Want to see which items fail: Use FILTER with the opposite condition

SOME, FILTER, AND

Was this helpful?

ALL