Hi I have a table Reports with a field phrases. The phrase field has a list of texts, like “was identified for” or “was shown by”. How can I search reports where a chunk of text contains at least one of these phrases? A text block might be something like “James was identified for eating crisps”. The report that contains a phrase “was identified for” should therefore be shown in a RG for this piece of text. I’m running into a dead end with advanced filters, which appear to only let you check ONE item is contained within a block of text (see screenshot). Many thanks for advice! [Screenshot 2021-08-28 at 19.31.09]

@raharley0 [image] Contains Keywords matching rules Database Hi @alan5 , My experience has been that “contains keyword(s)” returns: whole words only words in any order case insensitive words “Contains” requires: partial words words need be in precise order case sensitive words Hope this helps +1:t2

Thanks, but contains keywords isn’t an available option. ‘Contains’ is - but as I said does not appear to allow a list of texts to be supplied.

Explore the differences between searching , filtering and advanced filtering Also … look into fuzzy search plugins and external services like Algolia.

Searching, filtering and advanced filtering don’t seem to solve this - I was hoping there is a bubble native solution. Thanks, will look into other alternatives.

Checking if text contains one or more items from a list

Need help

cmarchan August 28, 2021, 6:39pm 2

@raharley0

Topic		Replies	Views
[How to] Make filter "text contains" not only look for whole words Tips	3	3697	March 26, 2026
Need help with matching two lists in "Do a search" Need help	16	321	October 27, 2025
In need of a hack -- way to do "doesn't contain" against >1 item Questions	4	513	April 19, 2019
NEED HELP Compare if keywords (thing's field's list) appear in a text (other thing's field) and return those keywords Need help	5	818	April 9, 2017
How to check if text contains any item from a list? Need help	6	3767	November 23, 2019

Checking if text contains one or more items from a list

Related topics