How do i break line on the text message in whatsapp?

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

0 8 2,660
8 REPLIES 8

Aurelien
Google Developer Expert
Google Developer Expert

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 "

)

Top Labels in this Space