Action button to send message on WhatsApp

Questions
#1

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

2 Likes
#2

SUBSTITUTE(“https://api.whatsapp.com/send?phone=55seunumerodetelefone&text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”, “seunumerodetelefone”, [Celular])

#3

where do we put this expression…

and what does this mean in the expression “seunumerodetelefone”

#4

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.

#5

The expression for portuguese, Brazil

#6

Yourphonenumber

#7

Screenshot_20200321-151548
Screenshot_20200321-1515481080Ă—2160 170 KB

#8

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

#9

how do add variable data so that message created will pull data from the Google sheet

#10

Try something like…
“https://api.whatsapp.com/send?phone=55”&[Celular]&
“text=Olá%20este%20é%20o%20número%20de%20contato%20do%20WhatsApp%20da%20FaPetSitter”

#11

This expression opens whatsapp and the correct persons chat…but the message is empty and no data is taken from the sheet…

please help

#12

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]

1 Like
#13

Better:

"https://api.whatsapp.com/send?phone=55”&ENCODEURL([Celular])&“text=”&ENCODEURL([Message])
4 Likes
#14

But I need the message to contain variables from the row in question and create a message with it’s contents

#15

Aleksi’s example includes variables from the row.

1 Like
#16

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!

#17

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.

2 Likes
#18

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

@Durgesh_Shirsath @Suvrutt_Gurjar

#19

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?

#20

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”
    )
  )
)
2 Likes

Company

Platform

Pricing

Solutions

Support

Account

Built in Seattle, WA | Copyright 2019