Search/filter for multiple text items

[mtcsp_test]

Hello,

I am using my app to manage inventory across the organization, and each inventory item has multiple information/columns like:

• [Name]  - and this is a free entry/text column
•  [Use by date] - Date column
• [Location] - free entry/text column
• [Type] - Dropdown/Enumlist

Among many others.

On the app itself, you can search by text using the search bar, or Filter them by item conditions, example: [Location: USA], but I noticed that I can only do these 1 condition at a time for text columns. That is, in the search bar, I cannot have more than 1 keyword. Example: "name type" or "name, type" will not result in a search of "name" and "type" (separated).

For Filter, I cannot filter for multiple items within the same column, example: [Location: USA, Canada] nor [Name 1, Name 2], because those are text columns. However, I can search [Type 1, Type 2] by checking multiple boxes it's an Enumlist column. 

I wanted to know if there was a way to search for multiple items even for text columns/through text search. Open to other suggestions to do it, as well. Beginner to Appsheet, so I appreciate any guidance.

Thank you!

[AleksiAlkio · Accepted solution]

I'm afraid you are not able to do that with the existing search functionality. Though you can build this by yourself with the combination of a quick editable Detail view (Few search columns) and Table view (using slice based on your search columns) inside of a Dashboard.