Help with Whatsapp expression

[Jaros]

Hi guys, I’m trying to get a whatsapp expression working but I am struggling.

Below is one of many versions I have tried but none is giving me the format I require.

concatenate(
“https://wa.me/”,
“?text=”,
EncodeURL(concatenate(“Hi,” [first_name] , "it was great connecting with you, this is my personal number, feel free to contact me via Whatsapp if you have and questions, also please find a link to our company profile :, " "

", HYPERLINK(“https://drive.google.com/file/d/1Kb-V4vHr0c_NGVsa2QY-Cat9rhTe3d9x/view?usp=sharing”,(Company Profile)

))))

I was hoping to drop the actual google drive link and return Company profile but for some reason the system ignores the second part and only returns the google drive link. Also how do I extract the data from the first_name column in this scenario as the system also ignores it and leaves it out.

This is what it is returning. Any assistance would be greatly appreciated

Hi,it was great connecting with you, this is my personal number, feel free to contact me via Whatsapp if you have and questions, also please find a link to our company profile :,

https://drive.google.com/file/d/1Kb-V4vHr0c_NGVsa2QY-Cat9rhTe3d9x/view?usp=sharing

[Suvrutt_Gurjar]

Jaros:

concatenate(
“https://wa.me/”,
“?text=”,
EncodeURL(concatenate(“Hi,” [first_name] , "it was great connecting with you, this is my personal number, feel free to contact me via Whatsapp if you have and questions, also please find a link to our company profile :, " "

", HYPERLINK(“https://drive.google.com/file/d/1Kb-V4vHr0c_NGVsa2QY-Cat9rhTe3d9x/view?usp=sharing”,(Company Profile)

))))

Not tested the entire expression, but at least as per syntax of HYPERLINK() , you may wish to give a try to the below.

concatenate(
“https://wa.me/”,
“?text=”,
EncodeURL(concatenate(“Hi,” [first_name] , "it was great connecting with you, this is my personal number, feel free to contact me via Whatsapp if you have and questions, also please find a link to our company profile :, " "

", HYPERLINK(“https://drive.google.com/file/d/1Kb-V4vHr0c_NGVsa2QY-Cat9rhTe3d9x/view?usp=sharing”, “Company Profile”)
)))

[Steve]

I’m pretty sure an embedded hyperlink isn’t going to work.

[Jaros]

Suvrutt_Gurjar:

concatenate(
“https://wa.me/”,
“?text=”,
EncodeURL(concatenate(“Hi,” [first_name] , "it was great connecting with you, this is my personal number, feel free to contact me via Whatsapp if you have and questions, also please find a link to our company profile :, " "

", HYPERLINK(“https://drive.google.com/file/d/1Kb-V4vHr0c_NGVsa2QY-Cat9rhTe3d9x/view?usp=sharing”, “Company Profile”)
)))

@Steve excuse my ignorance, are you saying that it isn’t possible to hide the Google drive URL and only display the text “Company Profile” in the message? I tried to research embedded hyperlink but I didn’t find info that seemed to pertain to this. Is it not the same thing because I am using a Shareable link rather than a URL?

[Steve]

Jaros:

are you saying that it isn’t possible to hide the Google drive URL and only display the text “Company Profile” in the message?

That is what I’m saying, yes.

[jyothis_m · Accepted solution]

Jaros:

Also how do I extract the data from the first_name column in this scenario as the system also ignores it and leaves it out.

Jaros:

EncodeURL(concatenate(“Hi,” [first_name] ,

Hi @Jaros I think you have missed a comma after the “Hi,”. Like shouldn’t it be Concatenate (“Hi,”,[first_name],…)

[SkrOYC]

Unlike Telegram, whatsapp doesn’t have a way to make those formatting things, just a link inside the message

core.telegram.org

Telegram Bot API

The Bot API is an HTTP-based interface created for developers keen on building bots for Telegram. To learn how to create…