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.

Re: Find record by company name with contains function

108 0
cancel
Showing results for 
Search instead for 
Did you mean: 
vierless_julian
6 - Interface Innovator
6 - Interface Innovator

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.

10 Replies 10
ScottWorld
18 - Pluto
18 - Pluto

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