Quisiera saber como filtrar o buscar datos en una lista de articulos, usando la lupa, pero que lo haga con palabras separadas. Ejemplo: si la descripcion dice " mesa blanca rota" que yo escriba “mesa rota” y la filtre
Hello @Tonybrus!
Welcome to the community. I don’t understand Spanish but I used Google translate to read your question. Here’s the translation of what you wrote:
I would like to know how to filter or search data in a list of articles, using the magnifying glass, but do it with separate words. Example: if the description says “broken white table” that I write “broken table” and filter it
You mentioned the magnifying glass. That is what the user uses to search in an app that you or someone else has made. Unfortunately, the kind of search you described is not part of the native capability of AppSheet. It is possible, however, to build the capability to search for two or more terms into your app:
[Search multiple columns with different criteria](https://community.appsheet.com/t/search-multiple-columns-with-different-criteria/15776) Tips & Tricks ?
The built in search is very easy to use, but it only allows a single search term across all (searchable) columns. [36%20AM] A multi-term search can be built by constructing a Virtual Column of type List with elements of type Reference. The formula should return a list of keys from the table you want to search, and should update the list based on your search terms. FILTER(“Order”, AND( OR( ISBLANK([_THISROW].[Status]) , IN([Status] ,[_THISROW].[Status]) ), OR( ISBLANK([_THISR…
[Search multiple columns and multiple tables with different criteria](https://community.appsheet.com/t/search-multiple-columns-and-multiple-tables-with-different-criteria/20867) Tips & Tricks ?
I’ve used the sample given by GreenFlux (Search multiple columns with different criteria for the first search.) Context: I have Events, and for each Event I invite Persons. 3 tables are needed (Person, Event and Invitation), Attributes: a Person has a name and a country (USA,France, …) an Event has a name and a class (Football, Handball, …) an Invitation has a type of invitation (VIP, Normal, …) Relations One Person is invited to many Event One Event has many Person invited for each r…
1 Like
No, appsheet no tiene ese mecanismo de búsqueda
Gracias por responder. tratare de armar una búsqueda con diferentes campos!
1 Like
Buena suerte!