Hey guys,
How do i break line on the text message?
For Exemple:
YOUR ORDER SUMMARY
DATE: [ORDER DATE]
LOCATION: [LOCATION]
PRODUCT: [PRODUCTS]
COLLABORATOR: [attendant]
PRICE:[TOTAL]
STATUS:[STATUS]
currently I use this formula on behavior :
CONCATENATE(
โwhatsapp://send?phone=โ,
SUBSTITUTE(EXTRACTNUMBERS([No. Hp]), " , ", โโ),
"&text=Kode%20Pelangggan : ",
ENCODEURL([Kode Langganan]),
ENCODEURL([Nama Langganan])
)
and then result :
Kode Pelangggan : 0001220412PVDHj. AISAH SENEN
Hi @ADAJALAN
You may want to insert a break line within the quote brackets ?
CONCATENATE(
"whatsapp://send?phone=",
SUBSTITUTE(EXTRACTNUMBERS([No. Hp]), " , ", ""),
"&text=Kode%20Pelangggan :
",
ENCODEURL([Kode Langganan]),
ENCODEURL([Nama Langganan])
)
For Exemple:
YOUR ORDER SUMMARY
DATE: [ORDER DATE]
LOCATION: [LOCATION]
PRODUCT: [PRODUCTS]
COLLABORATOR: [attendant]
PRICE:[TOTAL]
STATUS:[STATUS]
Try first, come back with what you ended up, then we could do the rest after your first effort
I donโt understand the placement, this addition.
Try adding \n
inside the text thatโs inside ENCODEURL()
or %0A
can you help me write this in my formula :
CONCATENATE(
โwhatsapp://send?phone=โ,
SUBSTITUTE(EXTRACTNUMBERS([No. Hp]), " , ", โโ),
"&text=Kode%20Pelangggan :
",
ENCODEURL([Kode Langganan])
ENCODEURL([Nama Langganan])
)
Try adding \n
inside the text thatโs inside ENCODEURL()
or %0A
Method described by @Aurelien works great though
I used \n in every line inside ENCODEURL(), and it worked perfectly
Hi! can you show how to add the "\n" inside the ENCODEURL()?
Hola... This is an example. I hope this helps!
"https://api.whatsapp.com/send?phone=58"&TEXT([Celular])&"&text="&ENCODEURL(
"Gracias por confiar en nosotros, el servicio para tu " &[Modelo] & " del dia " &[Fecha] &" fue el siguiente: "&
\n "
"&
\n"
Lubricante: "&"*"&lookup([_thisrow].[Id].[Lubricante],"Inventario","Cรณdigo","Nombre")&"*"&
\n "
)
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |