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
Solved! Go to Solution.
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.
SUBSTITUTE(โhttps://api.whatsapp.com/send?phone=55seunumerodetelefone&text=Olรก%20este%20รฉ%20o%20nรบmero%20de%20co...โ, โ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.
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%20co...โ, โseunumerodetelefoneโ, [Celular])
how do add variable data so that message created will pull data from the Google sheet
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
Amazing, it works perfectly, thanks for sharing. Just for clarification for other people, I think the formula is just missing a closed bracket at the end -> )
The expression for portuguese, Brazil
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.
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โ
)
)
)
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โ ) ) )
Thanks Steve!
It is working great
Hi, I found this discussion and tried your suggestion, but Iโm not getting things right. Whatsapp is called and opened correctly, the text is in the right place also, but the msg comes with " %20 " everywhere.
CONCATENATE(
"https://api.whatsapp.com/send?phone=",
ENCODEURL([customer_id].[Whatsapp]),
"&text=",
ENCODEURL(
CONCATENATE(
"Seu pedido foi reservado, confirme seu Endereรงo e pedido para prosseguir com sua compra, ",
[customer_id].[Address]
" Address ",
[order_id],
" ha sido aprobada"
)
)
)
If you take a look on this video Base de datos AppSheet Lecciรณn 6: Papelerรญa Micra parte 4 Mensaje de WhatsApp - YouTube, youโll see the whole process done in 30 min. He also created a virtual column, not sure yet whatโs that for. Your expression is a way cleaner, Iโd like to know how to avoid the %20 between every single word.
Something like this would be amazing:
Hello there, your order needs to be confirmed. Please check your information and ____.
Name: [Name]
Address: [Address]Order: [Order_ID]
Items: [List of Items_ID],
Products : [Product_ID][Name]Quantity: [Quantity]
Total: [Sum_order]
youโll find this expression on that youtube link I shared above.
"https://api.whatsapp.com/send?phone=52"
&TEXT(SELECT(Clientes[Telefono], [No. de cliente] = [Cliente])) &
"&text="
&ENCODEURL(
"*No de venta:* "&[No de venta]&
" *Vendedor:* "&TEXT(SELECT(Empleados[Nombre], [No. Empleado] = [Vendedor]))&
" *Cliente:* "&TEXT(SELECT(Clientes[Nombre], [No. de cliente] = [Cliente]))&
" *Producto* *Cantidad* *Precio* *Monto*"&" "
&SELECT(Venta[WhatsApp], [No de venta] = [_THISROW].[No de venta])&" *Total:* $"&SUM(SELECT (Venta[Monto], [No de venta]=[_THISROW].[No de venta])) )
Hi!
Thank for your help. I used it and it's run perfectly but only in Whatsapp WEB version. If I use the appsheet in my movile phone, that action only open the chat whith the person, whitout any message. I'm doing something wrong? or it's normal?
Thank so much
CONCATENATE(โ[https://api.whatsapp.com/send?phone=",CONCATENATE("+91 ](https://api.whatsapp.com/send?phone=",CONCATENATE("+91)โ,[Faculty Number]),"&text=",CONCATENATE(" Namaste ",[Name]โฆ)
use this expression and replace the values in square brackets to dynamic headers as in your dataโฆi am using it without any issue and is working superblyโฆalso remember +91 to your country code
CONCATENATE(โ[https://api.whatsapp.com/send?phone=",CONCATENATE("+91 ](https://api.whatsapp.com/send?phone=",CONCATENATE("+91)โ,[Faculty Number]),"&text=",CONCATENATE(" Namaste ",[Name]โฆ)
Is there any way to send images and url to the whatsapp groups from the images i have clicked using Appsheet
Once i click the action Image and Url in the Appsheet App should go to the phone number or group please let me know if it is possible and process to do it
Thanks in Advance
Yes you can just add the name of the colum in the message in square bracketsโฆwhat will happen is the image will be added in the message as a linkโฆupon clicking on it the image will appear
I am getting like this in WhatsApp
Share on WhatsApp Out the task- Link for Dev entry to HangOut
Link- https://www.appsheet.com/start/{9fe64564-684c-4cb3-9704-62b3d6f24836}
But the actual one looks like this
Wrap [Titile]
with ENCODEURL():
ENCODEURL([Title])
Also, you only need CONCATENATE() once in your expression.
See also:
Text encoded for use in URL
GREAT! Works Perfect! Thanks @Steve ve
Can we send a whatsApp to a group (not an individual)?
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |