How to use AND Operator with IF condition in Formula Mode

zaygum — Wed, 18 Oct 2023 13:43:44 GMT

Hi,

I am trying to use an AND operator with IF ELSE in the Formula mode in Workato.

Trying to do something like:

IF condition1=TRUE AND Condition2=True
Value

Can someone please assist on this.

Thanks

Re: How to use AND Operator with IF condition in Formula Mode

gary1 — Wed, 18 Oct 2023 16:47:56 GMT

You can use a "ternary operator", which is basically an "if" statement. It has this syntax:

logical_condition ? result_when_true : result_when_false

Example:

1 == 1 ? "true!" : "false!" ## >> "true!"

The AND operator is "&&" and the OR operator is "||"

Example:

1 == 1 && 0 == 1 ? "true!" : "false!" ## >> "false!"