and( value )
Returns true
if all inputs are true
; returns false
if at least one input is false.
Keyword | Type | Description |
---|---|---|
|
Boolean |
A value or array of values that must be true for the function to return true. |
Boolean
and()
evaluates.false
, the function returns false
.false
, evaluation of the later edge cases never occurs.true
.false
, but empty text strings in an array with multiple data types are considered null values and are filtered out before evaluation.Use functions to Pass Multiple Logical Values:
and(isleapyear(1996),isleapyear(1997))
returns false
Pass an Empty Array:
and({})
returns true
Pass an Array of Numbers:
and(1,2,"",3)
returns true
and(0,1,2,"",3)
returns false
because 0
casts to false
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Compatible | |
Process Events | Compatible |
and() Function