Skip to content
Problem with Airtab...
 
Notifications
Clear all

Problem with Airtable Search Record in Custom Webhook Scenario

6 Posts
3 Users
0 Reactions
4 Views
farah
(@farah)
Posts: 10
Active Member
Topic starter
 

I've put together a custom workflow utilizing webhooks, the "Sleep" tool, and Airtable's "Search Record" and "Create Record" modules. The webhook is set up to fetch data from the Odoo API. However, when I try to find a specific client (let's refer to it as Client X) in Airtable, the search is returning zero results, despite the client being present in the Airtable database. Can anyone offer some insight into why this might be occurring?

Best regards,

 
Posted : 06/12/2024 10:30 am
dilipborad
(@dilipborad)
Posts: 28
Eminent Member
 

Hello,

Please share the formula you are attempting to use with the “Search Record” module.

Additionally, please provide your Airtable structure and field names.


:bulb:

P.S.: Always search first. Check out the callin.io Academy here. If this was helpful, please mark it as a solution

:white_check_mark:

and

:+1:

Need expert assistance or have questions? Feel free to reach out or comment below!

:point_down:

 
Posted : 07/12/2024 4:55 am
AutomationZion
(@automationzion)
Posts: 2
New Member
 

Which field are you performing the search on?

 
Posted : 07/12/2024 5:02 am
farah
(@farah)
Posts: 10
Active Member
Topic starter
 

({E-mail} =“{{1.email}}”) : this is the formula for the “search record” action.

 
Posted : 09/12/2024 10:23 am
dilipborad
(@dilipborad)
Posts: 28
Eminent Member
 

If you are utilizing the AND() function, consider this approach.

AND({E-mail}={{1.email}})
// Kindly remove the quotes(")

Should this not yield the desired results, please provide a complete screenshot of the Airtable configuration dialog.

:+1:

 
Posted : 09/12/2024 11:19 am
dilipborad
(@dilipborad)
Posts: 28
Eminent Member
 

Hello
Did this work?

:white_check_mark: Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.

 
Posted : 24/12/2024 9:59 am
Share: