Hi
I am setting up a zap connecting stripe to airtable.
I want the zap to find a record in Airtable that matches the stripe data in 2 fields
To do this I need to enter an AirTable search formula into the zap
The 2 Airtable columns I want it to search are “Email Address” and “Subscribed to”
So let’s say that a change is made in stripe that fires the Zap.
The zap will search Airtable for a record where both the “Email Address” field and the “Subscribed to” field match the data in both those fields in stripe. The combination of the 2 fields indicates it is the correct record to be updated with the changes made in Stripe.
What search formula would get this result for me in my Zap?
ChatGPT helped me get to this formula:
"{Email Address} = {Stripe Subscription}rcustomer.email] AND {Subscribed to} = {Stripe Subscription}ritems.data.0.price.nickname]"
but I'm getting the message
"Failed to find or create a record in Airtable
Error from halted execution: The formula for filtering records is invalid: Invalid formula. Please check your formula text."
And Chat GPT says I've asked it too many questions 🙂
Thank you
Ben