Send Whatsapp Message

My entire message in WhatsApp appear in a single line (as shown below).

“Name: XYZ, Detail: XYZ, Start Time: XYZ, End Time: XYZ, Duration: XYZ, Rate: XYZ, Amount: XYZ”

What should I do to make it appear as below (details should be in multiple lines),

"Name: XYZ,

Detail: XYZ,

Start Time: XYZ,

End Time: XYZ,

Duration: XYZ,

Rate: XYZ,

Amount: XYZ"

Below is my code, could someone please help me

CONCATENATE(
https://api.whatsapp.com/send?phone=+91”,
ENCODEURL([Name].[Mobile]),
“&text=”,
ENCODEURL(
CONCATENATE(
"Name: ",[Name], ", ",
"Details: ", [Detail], ", ",
"Start Time: ", [Start Time], ", ",
"End Time: ", [End Time], ", ",
"Duration: ", [Duration], ", ",
"Rate: ", [Rate], ", ",
"Amount: ", [Amount] ", ",
)))

@Steve

1 Like

HI everyone,

here is the solution.

CONCATENATE(
https://api.whatsapp.com/send?phone=+91”,
ENCODEURL([Name].[Mobile]),
“&text=”,
ENCODEURL(
CONCATENATE( "Name: “, [Name],”

“,"Detail: ", [Detail],”

","Start Time: “, [Start Time],”

","End Time: “, [End Time],”

","Duration: “, [Duration],”

","Rate: “, [Rate],”

","Amount: ", [Amount],

)))

4 Likes