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 

Solved Solved
1 1 504
1 ACCEPTED SOLUTION

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],

)))

View solution in original post

1 REPLY 1

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],

)))

Top Labels in this Space