Help

Seach for String containing - wildcard search

Topic Labels: Formulas
Solved
Jump to Solution
705 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}))