What info is avail re the IN function? Not s...

(Tim Meske) #1

What info is avail re the IN function?

Not sure how to use and when it is useful.

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

(Tony Fader) #2

@Tim_Meske More info is available here: help.appsheet.com - List Expressions and Aggregates

If you write IN(elementX, listY), it will return true if elementX is a member of listY. List Expressions and Aggregates help.appsheet.com

(Steven Coile) #3

The in() function is used to test whether a single value (the first argument) is “in” a list of values (the second argument).

The result of an in() expression is true or false according to whether the first argument is (true) or is not (false) in the list in the second argument.

The first argument must match (at least) one item in the second-argument list exactly, including upper- and lower-case letters.

A common use of the in() function is within a Valid_If expression. For instance, suppose the column [Color] requires the user to input a legitimate color from a list of available colors. The list of available colors could be expressed as list(“Red”, “Yellow”, “Green”, “Blue”). The user’s input could then be validated using a Valid_If expression of:

=in([Color], list(“Red”, “Yellow”, “Green”, “Blue”))

(Tim Meske) #4

+Steve Coile thanks for the quick response!