I have one Zap that creates an AirTable record whenever a customer makes an Acuity reservation.  A second Zap monitors Stripe for the credit card transaction, subtracts the Stripe Transaction Fee off of the Stripe Amount, and I want it to search for and update the relevant AirTable record, but I can’t get that step to work.

The Stripe->AirTable Zap in question starts with Stripe, builds in a delay to ensure Acuity/Zapier/AirTable have time to create the AirTable record, then Formatter subtracts the Stripe Transaction Fee off of the Stripe Amount, and Formatter changes Stripe’s date-time format into what AirTable stores from Acuity.  At this point, I want Zapier to search AirTable for whatever record has *BOTH* the client’s name (from Stripe) *AND* the formatted time of when the booking was made, then update that record with the formatted income amount.

I think my Search Formula in the AirTable search step is breaking, but I don’t know why.  It is as follows:

{Client Name}= "<TriggerValue>1. Billing Details Name: XXX YYY <TriggerValue>"&"("&"<TriggerValue> 4. Created Formatted: 04/12/2020 12:20<TriggerValue>"&")"

That search step should give me the name (XXX YYY) and the date/time that the reservation was made (04/12/2020 12:20), for me to pull into my Update AirTable step, yes?   But when the search runs, I get the “Nothing could be found for the search” error.  Help?