I have come across a pretty interesting problem that I haven’t encountered in my many years of using Zapier.

As you know, the backbone of automation/Zaps is being able to isolate something consistent (e.g. a particular field), extracting the value of the field, and taking steps based on that value. For example, isolate the email field (which is a consistent field), extracting the specific email address (the value of which changes based on what the input of the user is), then adding it to your mailing list (an action step).

I’ve encountered a situation wherein the field is not consistent; it changes based on input of the user, so I am unable to isolate the field for the Zap. Is there a way to create a Zap step wherein, in layman’s terms, I can search all/multiple fields to see if there is a specific value in any of them?

I’ll give the specific use case. We are using Ticket Tailor to get registrations (Ticket Tailor is similar to Eventbrite). When someone buys a Workshop Ticket, we ask an additional custom question, “What course are you taking?”

So under normal circumstances, the fields are:

Ticket Description: Workshop Ticket

Custom Attendee Questions Workshop Ticket Question: What course are you taking?

Custom Attendee Questions Workshop Ticket Answer: (Can be Course A / Course B / Course C)

We take additional steps (using Paths) based on what course they choose. So if Workshop Ticket Custom Question Answer contains Course A, tag them with “Course A” in our CRM; etc

However, if someone uses a coupon code (let’s say the coupon is 5OFF) then the fields dynamically change to become:

Ticket Description: Workshop Ticket (inc. 5OFF)

Custom Attendee Questions Workshop Ticket Inc 5OFF Question: What course are you taking?

Custom Attendee Questions Workshop Ticket Inc 5OFF Answer: (Can be Course A / Course B / Course C)

So the field that I am trying to isolate (and take action based off of), which is the ‘answer’ of which course they take, is always different based on the coupon code. If we had 10 different coupon codes, that means 10 different scenarios.

Not only does it get very tedious to do this, it also means that we have to wait for a real-life registration of someone using each of the different coupon codes we have before we can set up the correct path/new zap.

Is there a better way of doing this?

In layman’s terms: Look for a field that has both “Custom Attendee Questions Workshop Ticket” and “Answer”, then extract the value so that we can take the appropriate steps based on the value.

Thank you!