How to search by "logical AND" or "logical OR"

AppSheet AppSheet Q&A
1

Hi,
Is it possible to search by “logical AND” or “logical OR”.

Example:

3X_f_7_f7ac110116e06485ec8376c62c62e03f8aa35d89.jpeg
3X_f_7_f7ac110116e06485ec8376c62c62e03f8aa35d89.jpeg1080×2340 103 KB

3X_5_e_5ea6c1396b786d1c33b13ca65b747c527632fa2d.jpeg
3X_5_e_5ea6c1396b786d1c33b13ca65b747c527632fa2d.jpeg1080×2340 87.3 KB

What I want to achieve is to display columns that have ONLY the words “apple” and “fruit”.

Thanks for your help.
I really appreciated.
Sorry for my English, I hope you understand.

1 Like
2

The built-in search bar does not provide for logical operators; it is a simple literal (but case-insensitive) text match.

3 Likes
3

Hi @Steve would it be possible to add search operators like these? Feature Request?

3X_d_1_d1d5c71eb8c98988c4a5cdea8427476d7ec20f16.png

4

Please post this to the Feature Request category.

1 Like
5

Search Operators Feature Requests

I would like to use search operators in the search box. [image] * = any text ? = any character " " = exact phrase & = AND | = OR ! = NOT () = group

1 Like
6

The only possibility you have then is to go to the filter function, and the word apple, and search in the search bar for fruit, then these two words do not have to be side by side, but appear somewhere in the text.