I want to use a list of values from another i...

(Cory Chapman) #1

I want to use a list of values from another in the valid_if field of a column but I don’t want the dropdown. I just want the app to check the users input. Is that possible?

(Steven Coile) #2

If your Valid_If contains solely an in() expression, AppSheet works some magic and produces a drop-down menu with the values matched by the in(). To avoid this magic behavior, you have to disguise your use of the in() function. The simplest way is to make it part of another, benign expression:

=and(true, in(…))

(Cory Chapman) #3

+Steve Coile Thanks! That worked perfectly.