Concatenate Action address Google Maps to Whatsapp

[marinocity]

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

[Marc_Dillon]

Maybe you need to use ENCODEURL()

[marinocity]

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)

[marinocity]

Any help?

[dbaum]

Encode the entire value of the WhatsApp API's text parameter.

[marinocity]

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

[dbaum]

CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
ENCODEURL(
CONCATENATE("Hi!

"),
CONCATENATE
(“https://www.google.com/maps/place/",[ADDRESS]
)))

[marinocity]

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

[dbaum · Accepted 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]
      )
    )
  )
)

[marinocity]

Thank youuu!!! @dbaum 
Works perfect!