Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

I need to use a lookup table to search if a key contains a certain text, and not search for exact match of the text.

 

The lookup key is Website URL.

So if my website url is

www.mywebsite.com/?utm_source=google&utm_medium=cpc&utm_term=tampabrand

 

I want the formatter to search for 

?utm_source=google&utm_medium=cpc&utm_term=tampabrand

 

and if it finds it, then the value is:

Google AdWords Tampa Brand

 

And so on and so forth for every UTM I’m using in ad campaigns.

 

However, my current lookup table is looking for an exact match, and since the lookup key has a URL on the front end of the UTM, it’s not counting it. I can’t enter the full URL as the key because the website URL could be any different page on my website. So I need it to only search for a URL containing the UTM.

 

How can I achieve this?

 

Thanks.

 

 

 

 

 

 

Hi Lance,

Looks like you’ve got a great conversation going with our Support team and they’re helping you out with this! If you have any further questions you can reply to that email :)

If there's any way you could update this thread once your issue has been resolved, we’d very much appreciate it! Then, anyone who comes across the thread can benefit from the answer.

Thanks!

It looks like you were able to find a solution for this @Lance Devore, I hope you don’t mind if I share it here 🙂


I've been able to achieve what I need by writing a (very long) formula in an Airtables field. A condensed version of it looks like this:

IF(SEARCH("UTM-string-1"),"Source1",
IF(SEARCH("UTM-string-2"),"Source2",
))

etc.

So the conditions and values of a lookup table are all found within the formula.

Terms & Conditions