Find record by company name with contains function

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:

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})
)

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