- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 05:43 AM
My challenge is to do a search that looks for records where my input is part of the company name. So essentially I am looking for a "contains" function.
Example searches:
1.
Input: "sephora"
Target: "company" field in record: "SEPHORA Inc."
2.
Input: "GoSports"
Target: "Go Sports Inc."
I guess the second example won't be possible but my plan is to just get all the matches based on company name, then name of the record and description and then let AI do a matching by probability and my other form inputs.
I am using the search module in Make.com.
My guess was to use either "SEARCH", "FIND", or "REGEX_MATCH" but no luck so far with my tests.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 04:43 PM - edited Jan 27, 2025 04:48 PM
Oh, you didn’t mention it was a lookup field. That is likely what is causing the issue, as lookup fields are arrays instead of text strings.
So if it’s a lookup field, try this formula, which will turn the lookup field into a text string:
FIND(
Lower("NAME OF COMPANY GOES HERE"),Lower({Field Name}&"")
)
- ScottWorld, Expert Airtable Consultant

- « Previous
-
- 1
- 2
- Next »