Yes / No Expression in Appsheet feature in Appy Pie.

# Yes / No Expression in Appsheet feature in Appy Pie.

Yes / No Expression :

TRUE/FALSE

A result that is either TRUE (Yes) or FALSE (No) is produced by TRUE/FALSE function.

Syntax

YESNO('TRUE')

Example

YESNO(‘FALSE’): FALSE

YESNO(‘TRUE’): TRUE

YESNO(2) : FALSE

EQUAL

The EQUAL  function returns TRUE if two specified numbers are equal and returns FALSE if the numbers are not equal.

Syntax

EQUAL([value_1],[value_2])

Example

EQUAL(, ) = TRUE

EQUAL(, ) = FALSE

NOTEQUAL

The NOTEQUAL  function returns TRUE if two specified numbers are not equal and returns FALSE if two numbers are equal.

Syntax

NOTEQUAL([value_1],[value_2])

Example

NOTEQUAL(, ) = FALSE
NOTEQUAL(, ) = TRUE

GREATERTHAN

The GREATERTHAN function returns TRUE if the first number is greater than the second, and FALSE otherwise.

Syntax

GREATERTHAN([value_1],[value_2])

Example

GREATERTHAN(, ) = TRUE

LESSTHAN

The LESSTHAN function returns TRUE if the first number is less than the second, and FALSE otherwise.

Syntax

LESSTHAN([value_1],[value_2])

Example

LESSTHAN(, ) = FALSE

GREATERTHANEQUAL

The GREATERTHANEQUAL function returns TRUE if the first number is greater than or equal to the second number, and FALSE otherwise.

Syntax

GREATERTHANEQUAL([value_1],[value_2])

Example

GREATERTHANEQUAL(, ) = TRUE
GREATERTHANEQUAL(, ) = TRUE

LESSTHANEQUAL

The LESSTHANEQUAL function returns TRUE if the first number is less than or equal to the second number, and FALSE otherwise.

Syntax

LESSTHANEQUAL([value_1],[value_2])

Example

LESSTHANEQUAL(, ) = TRUE

NOT

If the specified condition is true, the NOT function returns FALSE and if the specified condition is false, the NOT function returns TRUE.

Syntax

NOT({cond_1})

Example

NOT(EQUAL(8,8)) = FALSE

NOT(TRUE) : FALSE

NOT(FALSE) : TRUE

NOT(ISBLANK([Summary])) : TRUE if the Summary column value is not blank.

NOT(WEEKDAY(TODAY()) = "Friday") : TRUE if today's weekday name is not Friday.

NOT(IN([Month]), {"March", "May"}) : TRUE if the Month column value is not March or May.

Arguments

A (YES/NO) Condition that results in TRUE or FALSE.

Return Value

Yes/No: The inverse of condition that is if the condition is TRUE, the function will return FALSE and if the condition is FALSE, it will return TRUE.

ISBLANK

If the value or referenced cell is blank, the ISBLANK function returns TRUE, and if the value or referenced cell is not blank, it returns FALSE.

Syntax

ISBLANK([column])

Example

ISBLANK([ ]) = TRUE

ISBLANK("") : TRUE

NOT(ISBLANK("")) : FALSE

ISBLANK(0) : FALSE

ISBLANK(LIST()) : TRUE.

ISBLANK(LIST("Red", "Yellow", "Black")) : TRUE if List has no value, FALSE otherwise.
ISBLANK([Location]) : TRUE if the Address column has no value, FALSE otherwise.

Arguments

• Any singular value of any type
•  List of any type.

Return Value

Yes/No: The function returns TRUE if this has no value, and FALSE otherwise. A list that is empty has no value.

ISNOTBLANK

If the value or referenced cell is not blank, the ISNOTBLANK function returns TRUE, and if the value or referenced cell is blank, it returns FALSE.

Syntax

ISNOTBLANK([column])

Example

ISNOTBLANK() : TRUE

ISNOTBLANK("") : FALSE

NOT(ISNOTBLANK("")) : TRUE

ISNOTBLANK("Hello!") : TRUE

ISNOTBLANK(0) : TRUE

ISNOTBLANK(LIST()) : FALSE.

ISNOTBLANK(LIST("Red", "Yellow", "Black")) : TRUE if List has a value, FALSE Otherwise

ISNOTBLANK([Location]) : TRUE if the Address column has a value, FALSE if the column has no value.

Arguments

• Any singular value of any type
• List of any type.

Return Value

Yes/No: This function returns TRUE if this has a value, and FALSE otherwise. A list that is empty has no value.

IN

This function returns TRUE if the search target matches a minimum of one item in the search list, and FALSE otherwise.

Syntax

IN([Summary], LIST([value1], [value2]))

Examples

IN("a", {"a", "b", "c"}) : TRUE

IN("bc", {"a", "b", "c"}) : FALSE

IN("d", {"a", "b", "c"}) : FALSE

IN("Red", {"I'm bored!"}) : FALSE

IN(".com", LIST([Email])): It is the value of the Email column exactly .com and nothing else.

Arguments

• Summary: This denotes the value to be determined and this value's type must be compatible with that of the items of the search list.
• List (EnumList or List of any type): A list of items where the search is to be carried out while ensuring that the type of items is compatible with that of the search target.

Return Value

Yes/No : The function returns TRUE if the search target matches a minimum of one item in the search list and FALSE otherwise.
Note:The match is case-insensitive, that is the upper- and lower-case letters are equivalent.

CONTAINS

This function returns TRUE if the fragment is found in the search value and False otherwise.

Syntax

CONTAINS(Fragment,Value)

Examples

CONTAINS("abc", "a") : TRUE

CONTAINS("abc", "bc") : TRUE

CONTAINS("abc", "d") : FALSE

CONTAINS("I love my country!", "try")  : TRUE

CONTAINS([Location], "PO Box"): Does the Location indicate a post office box?

CONTAINS([Email], "@"): Does the Email contain at least one at sign (@)?

Return Value

Yes/No : This function returns TRUE if the fragment is found in the search value and False otherwise.
Note:The match is case-insensitive, that is the upper- and lower-case letters are equivalent.

AND

If all of the provided conditions are logically true, the AND function returns TRUE, and if any of the provided conditions are logically false, this function returns FALSE.

Syntax

AND([cond_1], [cond_2])

Example

AND(ISBLANK([Base]), ISBLANK([Num]))

AND(FALSE, FALSE) : FALSE

AND(TRUE, TRUE) : TRUE

AND(FALSE, TRUE) : FALSE

AND(TRUE, FALSE) : FALSE

AND(ISNOTBLANK([Section]), (EQUAL([Section] , "A")) : TRUE only if the Section column value is both present and has a value A; otherwise FALSE. See also: ISNOTBLANK().

AND(([Name] = "App"), (GREATERTHAN([RATING],3), [Preferred?]) : TRUE only if the row is for the company named App that has a review of 5 or higher and is a preferred; FALSE otherwise.

Arguments

A (Yes/No) condition that results in TRUE or FALSE. A minimum of two conditions are required.

Return Value

Yes/No: This function returns TRUE if every condition is TRUE, otherwise FALSE.

OR

If any of the conditions is logically true, the OR function returns TRUE, and if all the conditions are logically false, this function returns FALSE.

Syntax

OR([cond_1], [cond_2])

Example

OR(ISBLANK([Base]),ISBLANK([Num])): TRUE, If any of the conditions is logically true False otherwise

OR(FALSE, FALSE) : FALSE

OR(TRUE, TRUE) : TRUE

OR(FALSE, TRUE) : TRUE

OR(TRUE, FALSE) : TRUE

OR(EQUAL(Red, [Color]), EQUAL(Yellow, [Color]), EQUAL(Green, [Color])) : TRUE if the Color column value is any of Red, Yellow, or Green.

Arguments

A (Yes/No) condition that results in TRUE or FALSE. A minimum of two conditions are required.

Return Value

Yes/No: This function returns TRUE if any of the provided condition is TRUE, otherwise FALSE.