ENCODEURL NOT WORK

AppSheet AppSheet Q&A
1 
CONCATENATE("https://api.whatsapp.com/send?phone=39",SELECT(Staff[TELEFONO],AND([CATEGORIA]=[_THISROW].[IDCATEGORIA],[RUOLO]="Allenatore in prima")),"&text=",CONCATENATE("Prossima%20partita%20di%20Campionato%0A*****************************%0AData%3A*",DAY([DATA]),"%2F",MONTH([DATA]),"%2F",YEAR([DATA]),"%0AAlle ore %3A*",HOUR(TIME([DATA])-"00:00:00"),"%3A",IF(MINUTE(TIME([DATA])-"00:00:00")<>"0",MINUTE(TIME([DATA])-"00:00:00"),"00"),"*%0ALuogo%3A*",[LUOGO],"*%0AAVVERSARIO%3A*",[AVVERSARIO],"*clicca%20qui%20per%20avviare%20il%20navigatore%0A%20https://www.google.it/maps/place/"))&ENCODEURL([LUOGO])

I can’t understand why the above code doesn’t work, while this one below does

"https://www.google.it/maps/place/"&ENCODEURL([LUOGO])

in the first code ENCODEURL function not work

2

In what way doesn’t it work?

Here’s your expression rewritten to my preferences:

CONCATENATE(
  "https://api.whatsapp.com/send?phone=39",
  ENCODEURL(
    ANY(
      SELECT(
        Staff[TELEFONO],
        AND(
          ([CATEGORIA] = [_THISROW].[IDCATEGORIA]),
          ([RUOLO] = "Allenatore in prima")
        )
      )
    )
  ),
  "&text=",
  ENCODEURL(
    CONCATENATE(
      "Prossima partita di Campionato
*****************************
Data:*",
      DAY([DATA]),
      "/",
      MONTH([DATA]),
      "/",
      YEAR([DATA]),
      "
Alle ore :*",
      HOUR(TIME([DATA]) - "00:00:00"),
      ":",
      IF(
        (MINUTE(TIME([DATA]) - "00:00:00") <> "0"),
        MINUTE(TIME([DATA]) - "00:00:00"),
        "00"
      ),
      "*
Luogo:*",
      [LUOGO],
      "*
AVVERSARIO:*",
      [AVVERSARIO],
      "*clicca qui per avviare il navigatore
 https://www.google.it/maps/place/",
      [LUOGO]
    )
  )
)
1 Like
3

this is result:

Prossima partita di Campionato

Data:*26/2/2022
Alle ore :15:00
Luogo:Lungotevere Dante, 311, 00146 Roma RM, Italia
AVVERSARIO:A.S.D. CAMPUS EUR 1960clicca qui per avviare il navigatore
https://www.google.it/maps/place/Lungotevere Dante, 311, 00146 Roma RM, Italia

ENCODEURL not work

4

Where are you seeing the result? Please provide a screenshot.

1 Like
5

cattura-1.png
cattura-1.png1617Ă—840 45.2 KB

whatsappweb

6

Ah. That’s a WhatsApp problem. You’ll need to contact WhatsApp support.

7

thank you.
Could I try to create the encoding manually with SUBSTITUTE?

8

No. The problem is not with ENCODEURL(). WhatsApp is reformatting your message.

9

it seems to work

SUBSTITUTE(SUBSTITUTE([LUOGO]," “,”%20"),“,”,“%2C”)