How make fungtion char(10) like that spreadheet on apppsheet

[ADAJALAN]

I see on the spreadsheet menu there is a chart(10) function, where this function functions as an enter line down,

how do i make this function in appsheet ?

I do this in a spreadsheet with this formula:
=CONCATENATE(“Customer “;”";C2;"”;" yth : “;CHAR(10);“Your STB’s remaining active period has expired : “;J2;“Days”;CHAR(10);” Active up to : “;”";TEXT(H2;“d mmmm yyyy”);"”;CHAR(10);”----------------- ------------";CHAR(10);“Immediately purchase a voucher”;CHAR(10);“For the next active period, Thank you”;CHAR(10);;CHAR(10 );“PLEASE VISION”)

and the result is like this:

Dear DARWIN UMAR customers:
The remaining active period of your STB is 5 days
Active until: January 2, 2022

Immediately make a voucher purchase
for the next active period, Thank you

VISION Charm

[Cale_QREW]

Hey ADAJALAN,

This article should be helpful in explaining the CONCATENATE function in AppSheet.

Link: Using CONCATENATE(), Ampersand, and text expressions in templates | AppSheet Help Center

Have a good one!
Cale

[Steve · Accepted solution]

AppSheet has n equivalent to the CHAR() function. The best you can do is insert literal line breaks:

CONCATENATE("Customer ";"*";C2;"*";" yth : ";"
";"Your STB's remaining active period has expired : ";J2;"Days";"
";" Active up to : ";"*";TEXT(H2;"d mmmm yyyy");"*";"
";"----------------- ------------";"
";"Immediately purchase a voucher";"
";"For the next active period, Thank you";"
";;"
";"PLEASE VISION")

[ADAJALAN]

thanks @Steve