- 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 06:44 AM - edited Jan 27, 2025 06:45 AM
When using Make’s Airtable integrations, you would just use normal Airtable formulas, and make sure that your formula results in the number 1 if you want Make to find that record.
You can test your formulas in an Airtable formula field to see if it works.
So, for example, if you’re looking for a word within a field, your formula would be:
FIND("string of text I’m looking for", {Field I’m Searching})
Back in Make, you would just substitute the text within the quotation marks with what you’re looking for, but everything else would remain the same.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 07:38 AM
Hi @ScottWorld !
Thank you for helping out.
I tried using this formula:
FIND("{{lower(1.Company)}}", {{lower("{Unternehmen}")}})
It outputs the company but only if it matches exactly my input. So if I put "SEPHORA Inc." just like in the record, it finds the record. If I put SEPHORA, it doesn't.
Should it not also output the record now since my input string is part of the record company name?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 07:50 AM
It should! Can you post a screenshot?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 08:05 AM
This one is not working but should:
This is when I do the exact name:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 10:10 AM
Those look like proper Airtable formulas. If you type your formula into an Airtable formula field, does Airtable yield the results you're looking for there?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 11:26 AM
I tried to add the formula field but it returns "0" for all records if I enter "Strabag".
When I enter the complete name (in this case "STRABAG BMTI GmbH & Co. KG") I get a "1".
This is the formula:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 11:34 AM
Is there a way to create a matching regex for this? I tried generating a formula using the built in AI but it fails and outputs Errors.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 03:28 PM
Hmmm... that's odd, because it works just fine for me. However, note that Airtable's FIND is case sensitive, so your idea to use the LOWER() function earlier was a good one. This formula should work in Airtable:
FIND(
Lower("NAME OF COMPANY GOES HERE"),Lower({Field Name})
)
- ScottWorld, Expert Airtable Consultant
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 27, 2025 03:52 PM
Ok, that is very interesting!
I just tried your function and it resulted in an error again. Then I changed the {Field Name} from {Unternehmen} to {Name} and suddenly it worked for my input. Maybe it has something to do with the field type of {Unternehmen}? It is a lookup field of another synched table in this base.
So for me your function works now but not for the right field yet.
