I have created a custom scenario using webhooks, the “Sleep” tool, Airtable’s “Search Record,” and “Create Record” modules. The webhook is designed to retrieve information from the Odoo API. However, when searching for a client (let’s call it Client X) in Airtable, the search result is returning 0, even though the client exists in the Airtable database. Could you help me figure out why this is happening?
Best regards,
Hello @farah,
Please share the formula that you’re trying to search using the “Search Record” module.
Also, share the Airtable structure and field names.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution 
and 
Need expert help or have questions? Contact or comment below! 
What field are you searching by?
({E-mail} =“{{1.email}}”) : the formula of “search record”
If you’re using the AND() function then try this.
AND({E-mail}={{1.email}})
// Remove that quotes(")
If this is not work for you then please share the full screenshot of the Airtable setting dialog.
Hello @farah
Did this work?
Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.