Include AND and OR conditions in a SELECT

[jialvarez]

How can I include two or more conditions in a SELECT.

I try to insert the words AND / OR but the select don't work.

Could I get some help?

[SkrOYC]

---

@jialvarez wrote:

I try to insert the words AND / OR but the select don't work.

---

Share an example, this could be a lot of things

[Markus_Malessa]

An example would be best since AppSheet does not have a set precedence on order of evaluation unlike MySQL for example. So typically you would need to designate the order of evaluation yourself by either starting with AND() or OR() and then following with the other evaluation inside that statement.

[WillowMobileSys · Accepted solution]

The expression syntax would follow this pattern:

SELECT(Table Name[Column Name], AND( <<criterion1>>, <<criterion2>>))

You would replace AND with OR if OR was the proper choice.

Each <<criterion>> must be an expressions that result is a TRUE or FALSE response; at least 2 criterion are required but you can have more than 2.

[jialvarez]

Thank you very much for you response so clear and concise. It really work and solve my problem

[Steve]

AND() - AppSheet Help