Line break

[ROHAN_SHAH]

hey apppsheet,

i want to use a line break function in concatenate function in app formula section…

please help

[LeventK]

CONCATENATE("This is a line before LB","
","And this is a new line after the LB","
","
","This is another line after an empty LB or CR"
)

[Simusolar]

This does not work in PDF attachments generated from Google Docs templates. I'm trying to generate lines in the doc from a list view, and they appear next to each other even when they have a newline in the formula. Is there another way to generate lines in a PDF attachment?

[1minManager]

So this will only work with LONGTEXT columns.  But try something like this:

CONCATENATE(

"foo",

"

",

"bar"

)

Note the carriage return in the 2nd element of the CONCATENATE

Simon@1minManager.com