Airtable formula in Search records module

Hi, with a webhook I retrieve the values when an order is paid in Woocommerce webshop. I want to upsert the contact in the contacts table in Airtable.
So, I think I first have to search for a record in the contacts table with the same mailaddress as in the order. So after the webhook I inserted the Airtable module Search records. As formula to filter the records I typed {E-mail} = and the the email field retrieved by the webhooksmodule.
But in the Search module I get the error " RuntimeError[422] The formula for filtering records is invalid: Invalid formula. Please check your formula text."
I have tried the same formula without brackets but that doesn’t help.

What am I doing wrong?

Thanks, Sandra


1 Like

Thanks @SebastianMertens for your quick response! It’s working now :smiley:


Hello! I have the same error but with this formula:

Can’t figure out where the error is. Any suggestions?

@SebastianMertens sorry for bothering, but we really need some assistance with this. We want to test if Make can work for us, and if does we want to transfer many of our workflow and move from Zapier.

{Post_Date_String}=“{{formatDate({{now}}; YYYY-MM-DD}}”

Do not use the equation function ( the green = )

Use a typed =

1 Like

Thank you, but then I get an error:
The operation failed with an error. [404] NOT_FOUND

1 Like