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!!
Solved. Using CONCATENATE formula.
Thx!
I would like to see that made into a simple demo to be put under ‘Tips and Tricks’ please!
Sure, Colin, this is what I´ve done. Really easy.
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.
Hope this helps!
Neat idea.
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. 
Is there a way to select the contact from the contact list once redirected to WhatsApp with a pre-filled message from AppSheet?
