Hi everyone
I am quite new in the appsheet editing
I want to know if it is possible in the apk app to search multiple colum with multiple words in search box? For example i want to search from Name column and Organisation column eg i write “John Foundation” in search box to find John Smith working in Ford Foundation.
Is it possible?
How to do it?
Is it possible to get seach result with partial word eg Sm found ?
Thanks in advance
Haque
Not possible.
Hi @Fazlul_Haque! Welcome to AppSheet!
@Steve is right about the lack of a native capability to search with multiple conditions. However, it may not be “impossible” to do something close to what you would like to do. Here are a couple of ideas for workarounds.
Since you are new to AppSheet you may not yet be familiar with how to make slices and what a virtual column is. If you search for these terms in documentation, I think you’ll find good explanations.
I wanted to indicate that, if it is very important to have some method of limiting the displayed records to those that conform to two conditions it’s not exactly impossible but it is a bit time consuming to configure such a method.
By the way, in regard to your question about searching for partial words, that is possible. For example, records with the word “partial” will be selected even if you only type in “part.” I don’t think @Steve was referring to this part of your question when he wrote “not possible.”
One way you could try… create a Usersetting with fields like Search#1, Search#2 etc. and then create a slice as @Kirk_Masden proposed.
Take a look in
Help converting a GSheets formula to AppSheet.
probably can help you.
Yes it is possible.
You have to add a virtual column and
add both of your columns in concatenate ()
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |