- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 15, 2023 12:09 PM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 15, 2023 05:00 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 15, 2023 05:00 PM
Hi, ruvi
Like this?
SEARCH("bro",LOWER({TABLE_ID}))
