Please relate an action button to initiate a WhatsApp message similar to the send sms option available now

ENCODEURL()
Text encoded for use in URL
Please relate an action button to initiate a WhatsApp message similar to the send sms option available now
SUBSTITUTE(“https://api.whatsapp.com/send?phone=55seunumerodetelefone&text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”, “seunumerodetelefone”, [Celular])
where do we put this expression…
and what does this mean in the expression “seunumerodetelefone”
I suspect the gist is that you can send messages to WhatsApp using WhatsApp’s public API. You’ll need to research how to do that.
The expression for portuguese, Brazil
Yourphonenumber
This works…for general users u must replace “55seunumerodetelefone” with your whatsapp phone no.
@Aleksi @Steve how do we add variables in such an expression…the below is the message that directly appears in the chat box…how can we customise it to our table
text=Ol%C3%A1%20este%20%C3%A9%20o%20n%C3%BAmero%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter
SUBSTITUTE(“https://api.whatsapp.com/send?phone=55seunumerodetelefone&text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”, “seunumerodetelefone”, [Celular])
how do add variable data so that message created will pull data from the Google sheet
Try something like…
“https://api.whatsapp.com/send?phone=55”&[Celular]&
“text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”
“https://api.whatsapp.com/send?phone=55”&[Celular]&
“text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”
This expression opens whatsapp and the correct persons chat…but the message is empty and no data is taken from the sheet…
please help
You need to read the value from your record in the same way than the phone number like…
“https://api.whatsapp.com/send?phone=55”&[Celular]&“text=”&[Message]
Better:
"https://api.whatsapp.com/send?phone=55”&ENCODEURL([Celular])&“text=”&ENCODEURL([Message])
Text encoded for use in URL
But I need the message to contain variables from the row in question and create a message with it’s contents
Aleksi’s example includes variables from the row.
Hi everyone!
Should this work on any app if I just copy and paste and change “55seunumerodetelefone” for my phone number? What else should be changed¿?
Thanks!
Its working for me:
CONCATENATE(“https://api.whatsapp.com/send?phone=",CONCATENATE("+91”,[Faculty Number]),"&text=",CONCATENATE("Namaste ",[Name]…)
–> replace +91 by your countrycode, here Faculty Number is my column where 10 digit mobile number(except country code) is stored. And the concate the predefined message with dynamic values.
Is there an option to add photos clicked on the app to the Whatsapp message.
And also is there a way to send these Whatsapp messages to a particular group in Whatsapp
I am using this formula
CONCATENATE("https://api.whatsapp.com/send?phone=”&ENCODEURL([Celular])&“text=”&ENCODEURL(CONCATENATE("Tu solicitud número de contrato código “, [UniqueReqID], " a nombre de “, [Nombre titular],” ha sido aprobada”)))
…the app open Whatsapp chat for [Celular], but no message are included. ¿What I am doing wrong?
Your expression:
CONCATENATE(
"https://api.whatsapp.com/send?phone=”
& ENCODEURL([Celular])
& “text=”
& ENCODEURL(
CONCATENATE(
"Tu solicitud número de contrato código “,
[UniqueReqID],
" a nombre de “,
[Nombre titular],
” ha sido aprobada”
)
)
)
My suggestion:
CONCATENATE(
"https://api.whatsapp.com/send?phone=”,
ENCODEURL([Celular]),
“&text=”,
ENCODEURL(
CONCATENATE(
"Tu solicitud número de contrato código “,
[UniqueReqID],
" a nombre de “,
[Nombre titular],
” ha sido aprobada”
)
)
)