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:
Immediately make a voucher purchase
for the next active period, Thank you
VISION Charm
Solved! Go to 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")
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
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")
thanks @Steve
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |