Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

UTM formula hyperlink is not working

Topic Labels: Formulas
Solved
Jump to Solution
5069 15
cancel
Showing results for 
Search instead for 
Did you mean: 
Harmony_Gilliar
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, I have a formula for UTM and its pulling from the other columns in the sheet, but for some reason, it is not hyperlinking the entire URL. I not sure why, But I have doubled checked the formula to make sure there are no spaces. I am new to Airtable formulas so I am not sure what I am doing wrong. Thanks!

1 Solution

Accepted Solutions

It’s working on this copy of the base you posted. I’ll keep that base up for a week so you have time to duplicate it and poke around.

Here it is again in case a typo was introduced:

SUBSTITUTE( LOWER( TRIM({URL}) & "?utm_medium=" & TRIM({Medium}) & "&utm_source=" & TRIM({Source}) & "&utm_campaign=" & TRIM({Campaign Name}) & "utm_content=" & TRIM({Content}) )," ","-")

But every now and then I have to write a formula by hand to get Airtable to recognize some of the field values.

Best of luck!

See Solution in Thread

15 Replies 15
Zollie
10 - Mercury
10 - Mercury

Please provide: (1) the link text you’re seeing (2) what you would like to see instead (3) the formula (4) details about any fields the formula is using.

Harmony_Gilliar
5 - Automation Enthusiast
5 - Automation Enthusiast

(1) this is what I am seeing(only half of the link is highlighted):
**https://www.understood.org/pages/en/families/?utm_medium=paid** &*utm_source=facebook&utm_campaign=this-is-a-testutm_content=post-w-image`

(2)I would like for the entire link to be highlighted.
(3) this is the formula I am using: LOWER(SUBSTITUTE(URL & ‘?utm_medium=’ & Medium & ’ &utm_source=’& Source &’&utm_campaign=’ &{Campaign Name} &‘utm_content=’ & Content))

Not sure what SUBSTITUTE is supposed to be doing. Try one of these:

URL & ‘?utm_medium=’ & Medium & ’ &utm_source=’& Source &’&utm_campaign=’ &{Campaign Name} &‘utm_content=’ & Content

LOWER(URL & ‘?utm_medium=’ & Medium & ’ &utm_source=’& Source &’&utm_campaign=’ &{Campaign Name} &‘utm_content=’ & Content)

If that doesn’t work, please try to re-communicate what you’re saying in (1). Your formatting is confusing.

Hey, Thank you for all your help! unfortunately the formal didn’t work. I was trying to say in for question 1:
the URL the formula is producing isn’t hyperlinking. half of the URL is a hyperlink while the other isn’t. At first I assumed it there was a space in the formula but after rewriting the formula several times there doesn’t seem to be any spaces. I am not sure what I am doing incorrectly.

This is how it looks:

https://www.understood.org/en/friends-feelings/empowering-your-child/building-on-strengths/5-steps-f... &utm_source=fb-community&utm_campaign=this-is-a-test, covid-apr20-wp&utm_content=post-w-imageScreen Shot 2020-04-20 at 9.00.23 PM

Welcome to the community, @Harmony_Gilliard! :grinning_face_with_big_eyes: Actually, there is a space in your formula, because there was one in the version that @Zollie created above. In yours, though, it’s “hidden” by the line break in your formula entry field. If you were to copy that full formula into a text editor, you’d see the space.

To nix it, place your cursor immediately after the quote at the end of that first line, and press the Delete key. That quote will move to the following line because the space has been removed.

thank you for noticing this, I went ahead and fixed it but unfortunately, it still didn’t fix the problem could there be anything else wrong with the Base or the formula? I could send you my Base if you would like to take a look at it.Screen Shot 2020-04-21 at 11.06.53 AM

Could you post some of your actual values?

In the screen shot in one of your posts it looks like there are two question marks in the URL.

?_?

this is a link to one of the records in the base https://airtable.com/tblxBdnafDwTpCxe0/viwf69BVDBvVJsdQd/recS6nijtkmxtYe71

@Harmony_Gilliard That link doesn’t work for users you’re not paying for. @kuovonne is just asking for values that the formula is spitting out. It also might help to share example values for the columns your formula depends on - so URL, Medium, Source, Campaign Name, Content. If typing is too hard, create a shared view and post that link.