Skip to main content

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.

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

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?

It should! Can you post a screenshot?

This one is not working but should:

This is when I do the exact name:

  

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?

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:

FIND("NAME OF COMPANY GOES HERE", {Unternehmen})

 

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.

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

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.

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

Reply


Terms & Conditions