Two Views in AND() Expression

AppSheet AppSheet Q&A
1

Hi, I have an expression to make a dropdown column (NUMBER) adjust values in the “Suggested values” based on two view (Master/Data Entry). (It ignores any row that has “-” in the INFO column.). I figured out how to make it work for one view but how do I make this expression include two different views? I looked up the AND() Appsheet info but I still missing something.

AND(SELECT(Master[NUMBER], and(ISNOTBLANK([NUMBER]), [INFO]<>“-”)),

SELECT(Data Entry[NUMBER], and(ISNOTBLANK([ NUMBER]), [INFO]<>“-”)))

2

Remove AND completely because that’s not the way you use it.
Instead just use a list addition.

First Select() + Second Select(), that’s it

AND() - AppSheet Help

Combine lists - AppSheet Help

2 Likes
3

Hi @Tameron

Have you checked out CONTEXT view?

4

I get it now! I didn’t even consider using + . Still wrapping my old brain around expressions but I’m starting to see it. Thank you!

2 Likes