UTM formula hyperlink is not working

[Harmony_Gilliar]

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!

[Zollie]

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]

(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))

[Zollie]

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.

[Harmony_Gilliar]

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-image

[Justin_Barrett]

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.

[Harmony_Gilliar]

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.

[kuovonne]

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.

?_?

[Harmony_Gilliar]

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

[Zollie]

@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.