WhatsApp send message link

AppSheet AppSheet Q&A
1

Hi everyone,

Im trying to make a “Send WhatsApp message” action.

Found this address for whatsapp API, which actually works fine if you just type the phone number:
https://wa.me/“phone number”

BTW I´m using in the target URL for the WhatsApp action I have setup.

What would be the right way to refer “phone number” to the data of “Cellphone” column?

Thanks!!

2

Solved. Using CONCATENATE formula.
Thx!

3

I would like to see that made into a simple demo to be put under ‘Tips and Tricks’ please!

4

Sure, Colin, this is what I´ve done. Really easy.

  1. i´ve set up an action:

    3X_5_b_5b6d6f604f00c2036fab23747d648d5942046e1f.png
    3X_5_b_5b6d6f604f00c2036fab23747d648d5942046e1f.png675×593 29.2 KB

The basic target URL for whatsapp messaging is: https://wa.me,“phonenumber”
This works if you just type your phone number in the “phonenumber” field.
Although if you want the phone number to be pulled from a column use the CONCATENATE formula like in the screenshot. “[contacto]” is the name of the column where I have the phone numbers.

*NOTE. You need your google sheet or wherever your data table is to show the “+” sign in front of the phone number. Otherwise, it´ll probably wont work. To accomplish this, just add an apostrophe ’ before the + symbol. This way Google Sheets, recognizes your input as text, and wont delete the + symbol.

  1. This is the result:

    3X_9_e_9e10d0bad815e03b035527251a0300472005b377.png
    3X_9_e_9e10d0bad815e03b035527251a0300472005b377.png385×399 20.9 KB

Hope this helps!

5

Neat idea.

6

UPDATE!
So I believe Whatsapp changed something and the link stopped working.
I had to remove the “+” symbol and set the column as “number” type.

Now working again.

7

Use : https://wa.me/1XXXXXXXXXX

Don’t use : https://wa.me/+001-(XXX)XXXXXXX

8

Is there a way to select the contact from the contact list once redirected to WhatsApp with a pre-filled message from AppSheet?

9

Hola Nicolas, many thanks for your example

How, after entering the phone number, do you add the text you show us, especially so that the lines appear separately? Thank you very much

10

Boa tarde.

Eu fiz igual o amigo ensinou, mas coloquei o código 55 dentro do código(porque aqui é Brasil).

Exemplo:

concatenate(" https://wa.me/55 ",[ Telefone 1 ],

"?text = Olá, ", EncodeURL( concatenate( [ Nome Completo ] )))

Isso, no caso de aparecer já o telefone do whatsapp e o nome da pessoa, Exemplo: Olá, Fulano de tal, …ea mensagem que se quer digitar.

Abraços.

Marcos-Betim/MG

11

I’m not sure whether you’re sharing information or asking a question about a problem you encountered.

In case it’s helpful, consider modifying your expression to exclude imprecise spaces in the URL (e.g., in “text = Olá”) and column references (e.g., “[ Telefone 1 ]”), as well as to encode all the message text:

concatenate("https://wa.me/55",[Telefone 1],"?text=",EncodeURL( concatenate("Olá, ", [Nome Completo] )))
12

Olá, tudo bem?

Grato amigo, os espaços, que esqueci de explicar, foi somente para deixar o código mais limpo para a pessoa que eu respondi entender melhor.

Na verdade, foi uma ajudinha ao fórum, só isso.

Muito grato pela dica!

13

Oi, Marcos, obrigado por postar!

Ainda não consegui fazer o meu Appsheets enviar essas msgs de zap automaticamente.

Duas dúvidas:

  1. quando digito uso o " https://wa.me/55 … " direto na URL, ele cai no meu whatsapp, já com o texto escrito corretamente, mas tenho que clicar no “aviãzinho” do whatsapp para a msg ir. Supondo que eu consiga fazer o appsheet funcionar (rs), a msg realmente é enviada, sem que eu tenha a necessidade de clicar no aviãozinho, correto?

  2. vc sabe se para fazer isso funcionar eu preciso para algum plano mensal?

Obrigado!