Concatenate Action address Google Maps to Whatsapp

AppSheet AppSheet Q&A
, , , ,
1

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:

Captura de pantalla 2023-03-05 a la(s) 15.40.39.png
Captura de pantalla 2023-03-05 a la(s) 15.40.39.png764×392 44.3 KB

No link to Google Maps

I tried with
https://www.google.com/maps?q=
https://www.google.com/maps/search/

It doesnt work :disappointed_face:

any help?
Thanks

2

Maybe you need to use ENCODEURL()

3

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)

4

Any help?

5

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

6

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]
)))
7 
CONCATENATE
(“https://api.whatsapp.com/send?phone=",CONCATENATE("+551111111”),"&text=",
ENCODEURL(
CONCATENATE("Hi!

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

Gracias @dbaum

:no_entry: 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]
)))
9

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]
      )
    )
  )
)
1 Like
10

Thank youuu!!! @dbaum
Works perfect!