Is there a way to search multiple keywords in a saved search?

I’m creating a Saved Search where users can filter by different parameters but the most important one is a ‘Keyword’ field where we have multiple text strings separated by commas.

I want to be able to use the search field to look up all rows where I can find a relevant entry.

Eg. Let’s say I type “Apples” and “Horses”. I want to see all entries where these are found together.

I have tried setting the criteria to “Contains” but can’t seem to use operators in the input field.

Is there a way to achieve this?

Thank you.

Rookie Asked on July 30, 2020 in Saved Searches.
Add Comment
2 Answer(s)

If you select Use Expressions, you can specify multiple criteria with an OR operator instead of the default AND.

Would that work for you?

Intermediate Answered on July 30, 2020.
Add Comment

Tried it and got “You cannot use an expression builder criteria filter as an available filter” as an error

Rookie Answered on July 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor