Contains() with partial text search

FILTER(“TABLE”,(CONTAINS([FREE TEXT FIELD],[TAGS]))) of List Type Ref

Hi All, trying to do the following:

I have a FREE TEXT FIELD where the user can type something such “I want to know more about cars.” (for example)

The lookup TAGS field contains “cars” and the rows tagged as such are returned. The string is found contained in the FREE TEXT FIELD (as expected)

When the Tags field contains “boats, bikes, cars” then it is not returned. I know this is due to the full string being referenced in the contains lookup. I would like this to be returned when a partial match on the contains. Is there a means to achieve this?

0 5 1,008
5 REPLIES 5
Top Labels in this Space