Syntax

if()

<aside> <img src="/icons/info-alternate_orange.svg" alt="/icons/info-alternate_orange.svg" width="40px" />

Checks a condition and returns one value if the condition is true and another if it’s false.

</aside>

if(condition, value_if_true, value_if_false)

ifs()

<aside> <img src="/icons/info-alternate_orange.svg" alt="/icons/info-alternate_orange.svg" width="40px" />

Checks more than one condition in sequence and sets the value to the first true condition. If non of the conditions are true it sets a default value.

</aside>

ifs(
	condition, value_if_true,
	condition, value_if_true,
	value_if_all_false
	)

Basic examples

Basic if() example

This example checks if two values are the same - in the database below we want to check to see if the number in the Value 1 property is the same as the number in the Value 2 property.

Simple Example DB

if(prop("Value 1") == prop("Value 2"), "Yes", "No")

Image of the formula in the database👆

Basic ifs() example

In the database below we want to check to see if the number in the Value 1 property is less than, greater than or the same as the number in the Value 2 property.

Simple Example DB (1)

ifs(
	prop("Value 1") > prop("Value 2"), "Greater than",
	prop("Value 1") < prop("Value 2"), "Less than",
	"Equal"
	)

Image of the formula in the database👆

Intermediate Example