About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Search function not returning known data (Airtable)

  • 19 October 2022
  • 7 replies
  • 78 views
N

**EDIT/UPDATE** I think part of the issue is my field in Airtable is a formula so I need to use Search Formula in Zapier. I am having some trouble understanding how to write this correctly. Currently I have…

{Client Name}="<TriggerValue>5. Output: Rachael Risch <TriggerValue>& " - " & DATETIME_FORMAT({Session Date}="<TriggerValue>3. Output:10/12/2022<TriggerValue>, 'MM/DD/YYYY')

 

And my formula in Airtable is…

{Client Name} & " - " & DATETIME_FORMAT({Session Date}, 'MM/DD/YYYY')

 

 

Hello,

I am trying to use Zapier to find a listing on Airtable and in the test it keeps returning that it can’t find anything but the data I want it to grab is exactly the same as what it’s searching for. Any guesses why it is not able to pull it in?? 

 

Pic #1 What I am trying to build that is returning nothing

Pic #2 The listing it should be able to pull 

 

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

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @nps_clt 

Good question.

The Search Formula be the same to how you’d write a formula in an Formula field in Airtable.

Try this for a Search Formula.

AND({CLIENT_NAME}=”[VALUE]”,{DATE}=”[VALUE]”)

Change the values between the curly {} brackets to match your field names.

Change the values for the square [] brackets to be your Formatter output variables.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
N

@Troy

 I might be missing something very obvious but I am still getting an error. Here is my input

 

AND({Client Name}=”5. Output: Rachael Risch ”,{Session Date}=”3. Output:10/12/2022”)

 

MohSwellam
Userlevel 7
Badge +8

Hi @nps_clt 

 

First, is the value available in the View you chose? 
 

Second, try to copy the value from Airtable and paste it in Zapier, see if there is a space or something that we cannot see in the field (if there is a space after the name and a space before the hyphen we wont see it as double space) 

 

Third, maybe add <Trigger Value> to @Troy Tessalone ’s formula before and after the values from Zapier. He is much better than I in those formulas but just a thought. 

Founder of GeekyAir.com
N

@MohSwellam Thank you! 

  1. The value is available in the view
  2. I am using a formatter to abstract the name and I did find some extraneous spaces there that I have removed. Sadly didn't solve the problem.
  3. I’ve tried the below versions but worried that I’m missing a small detail like a “ or [ in the wrong place...

 

MohSwellam
Userlevel 7
Badge +8

Glad that helped. Since you removed the space (also make sure its not in Airtable), now try your original setup (the value rather than the formula). also to make sure the space is always removed from Airtable use TRIM() 

 

Founder of GeekyAir.com
Troy Tessalone
Userlevel 7
Badge +14

@nps_clt

There is no need to use this:

 

Remove the [ and ] for both mapped variables.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
chanelle
Userlevel 7
Badge +8

@nps_clt are you all good to go? 😃

Terms & Conditions