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.
Screenshots:
@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.
