View this page in the latest version of Appian. and() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page Function and( value ) Returns true if all inputs are true; returns false if at least one input is false. Parameters Keyword Type Description value Boolean A value or array of values that must be true for the function to return true. Returns Boolean Usage considerations Casting and returning boolean values Arguments are cast to Boolean before and() evaluates. As soon as the returned value of a value evaluation returns false, the function returns false. Evaluation order and performance Multiple arguments are evaluated left-to-right. By keeping common conditions on the left and complex edge cases on the right, you can improve function performance. That way, if an earlier, simple function returns false, evaluation of the later edge cases never occurs. Null and empty arrays Null values that are part of input arrays are filtered out before evaluation. Empty arrays evaluate to true. Empty text strings in a text array evaluate to false, but empty text strings in an array with multiple data types are considered null values and are filtered out before evaluation. Examples 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 The table below lists this function's compatibility with various features in Appian. 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 Feedback Was this page helpful? SHARE FEEDBACK Loading...