AND

Use the AND function to determine if all conditions in a test are TRUE.

Use

AND( condition1, [condition2], ... )
Returns TRUE if all logical conditions are TRUE.

Parameter	Required	Description
condition1	Yes	the initial condition to test, which must result in either TRUE or FALSE
condition2, ...	No	additional conditions to test, which must result in either TRUE or FALSE

Returns

Logical

Examples

Validation Logic (Number Range)

This formula is used as an Output Validation Formula to ensure a user enters a number that falls within a specific acceptable range, such as a quantity between 1 and 10.

• Formula: AND(this >= 1, this <= 10)
• Logic:
  • this: Refers to the value currently being entered in the form field.
  • The formula checks if the value is greater than or equal to 1 AND less than or equal to 10.
  • If a user enters "5", both conditions are met, and the formula returns TRUE (valid). If they enter "15", the second condition fails, and it returns FALSE (invalid).

Automated Path Condition (Expense Approval)

This formula is applied to a Path on a Conditional Branch to determine if an expense claim can be approved automatically without human intervention.

• Formula: AND(@Trigger.out.ClaimAmount < 100, @Trigger.out.ReceiptProvided = TRUE)
• Logic:
  • @Trigger.out.ClaimAmount < 100: This extracts the "ClaimAmount" from the trigger step and checks if it is less than 100.
  • @Trigger.out.ReceiptProvided = TRUE: This checks if a logical "ReceiptProvided" field from the trigger is checked as true.
  • The workflow will only follow this specific path (e.g., an "Auto-Approve" path) if the claim is under $100 AND a receipt has been provided.