Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Seach for String containing - wildcard search

Topic Labels: Formulas
Solved
Jump to Solution
1528 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ruvi
4 - Data Explorer
4 - Data Explorer

Hi

I have in my AirTable a list of Names. Lets say I want to find all results with last name "brown". I am making a search for people with formular like this:

filterByFormula: LOWER({TABLE_ID})="brown"

How can I do it that if I search "bro", or even "own", it will also send the result of someone with name "brown". Meaning I want to receive when the String contains the seach word, not just when its an exact match.

Thanks

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi, ruvi

Like this?

SEARCH("bro",LOWER({TABLE_ID}))

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

Hi, ruvi

Like this?

SEARCH("bro",LOWER({TABLE_ID}))