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] ", ",
)))
Solved! Go to 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],
)))
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],
)))
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |