Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Search for partial match formula

Topic Labels: Formulas
2060 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ewan_Farry
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

Looking to use the FIND function for a column and return a result in Zapier.

My column ‘Name’ contains an entry 'Data’

I want to return a result, even when a partial match exists for 'the data’

I’ve got FIND("the data", LOWER({Name}) & "") but this returns nothing.

Is there something along the lines of an ‘If Contains’ formula that I can apply to Zapier via an Airtable formula?

I appreciate that this might mean entries with “the” would be considered e.g. ‘the number’ but thought there must be a way to find the closest match?

1 Reply 1
James-Trory
Airtable Employee
Airtable Employee

If you’re looking for the word “data” somewhere in a field, why not remove “the” from the FIND() formula and look only for “data”? That way you’ll pick up anywhere where that word occurs, regardless of what else might be in the string.

FIND("data",LOWER(Name))

Having said that, FIND() on its own will return where in the string the found word starts. So if the string read “the data”, this formula on its own will return “5” (ie. where in the string the word “data” starts).

You could combine this instead with IF() to return something else. For example:

IF(FIND("data",LOWER(Label)),"Match")

This would instead return the word “Match” in the formula field if it finds the word “data”.