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
Solved! Go to Solution.
Hi @Jaros I think you have missed a comma after the “Hi,”. Like shouldn’t it be Concatenate (“Hi,”,[first_name],…)
User | Count |
---|---|
43 | |
26 | |
23 | |
16 | |
12 |