Making decisions with Yes/No functions and expressions
Many times, in your app configuration, there will be logic that has just two possible results, Yes
or No
or TRUE
or FALSE
. In this section, we will learn about AppSheet functions that lead to these results. Before understanding these Yes
/No
functions, let us first discuss a few examples of scenarios where a yes or no answer will need to be configured in your apps:
Does a list of flowers, LIST( "Jasmine", "Rose" , "Aster", "Daffodil, "Dahlia")
, include "Hibiscus"
? The answer, in this case, is No
or FALSE
.
Does the word ice cream contain the word ice? The answer is Yes
or TRUE
.
There is a value of skateboard
in the [DESCRIPTION]
column in record 1 of a table. Now, the question is – is the [DESCRIPTION]
column in record 1 blank? The answer, in this case, is No
or FALSE
.
You can use AppSheet functions that result in a Yes
/No
or TRUE
/FALSE
value when applied to...