Hi!
I have a action that concatenate address and city in google maps to send for whatsapp.
Action Name: Maps
For a record of this table: Ventas
Do This: External: Go to a website
Target:
CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
CONCATENATE("Hi!%0A%0A", )
CONCATENATE
(“https://www.google.com/maps/place/",CONCATENATE([ADDRESS],","," ",[CITY])))
Result in Whatsapp:
No link to Google Maps
I tried with
https://www.google.com/maps?q=
https://www.google.com/maps/search/
It doesnt work 😞
any help?
Thanks
Solved! Go to Solution.
I was just illustrating for you where to position the ENCODEURL function to apply it to the entire text parameter's value. I hadn't reviewed the rest of your expression. Here's a version that I tested works for me (at least when I manually substitute a valid WhatsApp number where you have "551111111" and an address where you have the [ADDRESS] column).
CONCATENATE(
“https://api.whatsapp.com/send?phone=",
"+551111111”,
"&text=",
ENCODEURL(
CONCATENATE(
"Hi!
",
“https://www.google.com/maps/place/",
ENCODEURL(
[ADDRESS]
)
)
)
)
Maybe you need to use ENCODEURL()
Thanks @Marc_Dillon
I tried only with [ADDRESS] but result is always with spaces.
CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
CONCATENATE("Hi!%0A%0A"),
CONCATENATE
(“https://www.google.com/maps/place/",ENCODEURL([ADDRESS])
))
https://www.google.com/maps/place/RIBERAO PRETO 228 (WRONG)
https://www.google.com/maps/place/RIBERAO%20PRETO%20228 (OK)
Any help?
Encode the entire value of the WhatsApp API's text parameter.
Thanks @dbaum
But I dont understand....Encode the entire value of the whatsapp API's text parameter?
ENCODEURL(CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
CONCATENATE("Hi!%0A%0A"),
CONCATENATE
(“https://www.google.com/maps/place/",[ADDRESS]
)))
CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
ENCODEURL(
CONCATENATE("Hi!
"),
CONCATENATE
(“https://www.google.com/maps/place/",[ADDRESS]
)))
Gracias @dbaum
⛔ENCODEURL function is used incorrectly
Modifiqué el código quitando la coma " , " en la fila 6.
Lo acepta pero en whatsapp no aparece el link de google maps, solo aparece
"Hi!"
CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
ENCODEURL(
CONCATENATE("Hi!
")
CONCATENATE
(“https://www.google.com/maps/place/",[ADDRESS]
)))
I was just illustrating for you where to position the ENCODEURL function to apply it to the entire text parameter's value. I hadn't reviewed the rest of your expression. Here's a version that I tested works for me (at least when I manually substitute a valid WhatsApp number where you have "551111111" and an address where you have the [ADDRESS] column).
CONCATENATE(
“https://api.whatsapp.com/send?phone=",
"+551111111”,
"&text=",
ENCODEURL(
CONCATENATE(
"Hi!
",
“https://www.google.com/maps/place/",
ENCODEURL(
[ADDRESS]
)
)
)
)
Thank youuu!!! @dbaum
Works perfect!
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |