Skip to main content

Airtable novice here, need help crafting a search formula that will find the record that contains both a First Name and Last Name.  So in the attached screenshot, I will provide "Harley" and "Comber" and need Airtable to flag record 3 as satisfying the search.  I can't search based on an exact match because sometimes the name as it exists in the table includes a middle initial, full middle name, jr., sr., etc. that the document I'm pulling the first name and last name off of to do the search does not include.  But I will always have the first name and last name available to search.  

This is going in a Zapier routine that will provide the first name and last name for the search and then return the correct record so I can use the corresponding Matter ID in future steps.  

So, basically I need a formula that instructs Airtable to find the record that includes both the [First Name] and [Last Name] variables.  Thanks for your help.

Not sure I understand you fully, but try this:

AND(

FIND(

{First Name},Name

),

FIND(

{Last Name},Name

)

)


Not sure I understand you fully, but try this:

AND(

FIND(

{First Name},Name

),

FIND(

{Last Name},Name

)

)


That did it - thanks very much.  Was the last piece of the puzzle for us.  


Reply