Table of Contents

Formulas - Logical

Sofia Teran Updated by Sofia Teran

If is your first time with Formulas, please check our Getting Started guide here and our crash course here

Formulas available

  • And
  • If
  • Not
  • Or

AND

If email contains "gmail.com" AND the age is over 18
And(Contains(@email,"gmail.com"),IsGreater(@age,18))

IF (ternary)

With this method, you will be able to assign one value based on a true/false condition. If is true, assign a value and if is false, another value

Check if the age is above 18, and assign text value to a variable called @check

In the formula below, you can see "if age value is greater than 18" , we will assign to the variable @check the value "Is greater" otherwise, we will assign the value in the variable @check "Is not greater"

If(IsGreater(@age,18),"Is greater","Is not greater")

Not

Not 0

This formula is used to negate an expression and works with Boolean data type that has one of two possible values, which can be True/False or 0/1.

Not(0)

OR

Barcelona OR Madrid
Or(IsEqual(@city, "Barcelona"),IsEqual(@city,"Madrid"))

How did we do?

Formulas - Object

Formulas - Math

Contact