Hello
I have a list of more than 500 records, a search was created with the name for the information. I am looking for how to filter this list in the search, to show me only the true or false values.
I am using this formula for searching:
SLICE(SELECT(data.tickets1, CONTAINS(LOWERCASE(item.name), LOWERCASE(pageVars.Search_term))), 0, 10)
how do I add the filter “delivered: false” to this
Looks like some “If condition” could be used, maybe even at the earlier stage to avoid analysing results not matching the condition
Hi,
In the SELECT() function, simply use item.Entregado == false
So your whole formula would look like this:
SLICE(SELECT(data.tickets1, item.delivered == false && CONTAINS(LOWERCASE(item.name), LOWERCASE(pageVars.Search_term))), 0, 10)
thank you very much
it works perfect i’m still learning from appgyver
