Best answer

Is it possible to Find a Record in Airtable that contains part of a Search Value or Search Formula Query?


Userlevel 2
Badge +1

I’d like to be able to search for a specific record in a Table that contains part or all of the words in the Search Query. For example, ‘Search Value: Colton’s Bolt-ons’ → Record Contains ‘Colton’s Bolt-ons Exterior’.

I’d like for the zap to trigger when finding the partial result if possible.

icon

Best answer by Troy Tessalone 4 May 2022, 17:09

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @mannyv86 

Good question.

Try using the Search Formula option in the Airtable Find Record Zap action.

 

Userlevel 2
Badge +1

Yes sir, I’ve been trying formulas to achieve the desired result in the search formula field, but still cannot get it to trigger when I get a partial match. Any suggestions on what formula or function can be used to do so?

Userlevel 7
Badge +14

@mannyv86 

Airtable formula reference: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#text

SEARCH()

FIND()

 

NOTE: These may be case sensitive

 

EXAMPLE

 

Userlevel 2
Badge +1

Finally got it to work, thanks again Troy!