Hello! Is it possible to include "new line" c...

[Mobile_Tubercul]

Hello! Is it possible to include “new line” characters to strings/text inside formulas? How would new lines (or carriage returns) be represented? Thank you! Edit: for example, I want to add a linebreak in a concatenate function. CHAR() doesn’t seem to work.

[Grant_Stead]

I don’t understand what you’re trying to say here? Example?

[Mobile_Tubercul]

I want to include a linebreak in a concatenate function, for instance

[Grant_Stead]

@Mobile_Tuberculosis hrmmm not sure… @Aleksi_Alkio

[tony1]

@Mobile_Tuberculosis Just put a line break in quotes:

“this is line one and this is line two”

[Mobile_Tubercul]

Thanks

@tony. I tried it before and it didn’t work; I guess the function was put in when I wasn’t looking. This is great. Thanks again!

[Green_Gorilla]

I wanted to do this, and it worked putting a line break in. The only problem was, when I came to export that column out to a pdf template, the line breaks disappeared, and the words ran into each other in the pdf template.

[Aleksi_Alkio]

When using the CONCATENATE expression, you can use it like this…

CONCATENATE(“This is line one”,"

“,“This is line two”,”

",“End of”)

[John_Henry_Jose]

Will this work for virtual Longtext column? I have tried the same. but it doesn’t work. please advise.

Thanks.
John

[Steve]

Please post a screenshot of the complete expression you’re using.

[scott_marquardt]

This works well. However…

I’m using a table in a template, with multiple field references in the right-hand column across many rows. It’d be nice to have some rows appear conditionally. Thus:

---------------
Yadayada<<if(Eval=”Y”,”
---------------
“&[Evalfield1]&”
---------------
“&[Evalfield2]&”
---------------
“&[Evalfield3]&”
---------------
“&[Evalfield4]&”
---------------
“&[Evalfield5]&”
---------------
“),””)>>Yadayada
---------------

This method will not work in that case; the actual html of the table causes an error for each table row traversed by the line-broken literal:

(I can’t post the text of the error here for the same reason)

It would be nice if that could all be escaped, but I wouldn’t have any idea how to do that, much less do it and make the html still be effective in creating the table. 😕

CRLF is pretty simple, so I can see how that can work. Unfortunately it can’t handle anything more complex (note that I tried tripple quotes to break the literal up; it didn’t work with single quotes either).

It also can’t handle comments in the template document (which is darned unfortunate, since documenting what the heck one is doing with complex conditionals in a template would be handy to have in the document itself using something one would hope would be totally meta, such as document comments), as someone has noted elsewhere. Here, the word “Level” (a fieldname) has a comment attached to it:

Argh.

[Steve]

Maybe this?

CONCATENATE(
  "This is line one”,
  "<BR/>“,
  "This is line two",
  "<BR/>",
  ...
)

[fulippio]

That doesn’t work with Doc templates. How can we insert line breaks in the template?

[Green_Gorilla]

In the App, yes. It writes them on separate lines in the spreadsheet (within the same cell). But not in a pdf template in a workflow… it doesn’t maintain the line breaks.

[Aleksi_Alkio]

@Green_Gorilla That’s true. It will work with the Email body, but not with the Doc template.

[Jonathan_S]

Possible to be able to implement something for this? Starting to see some future use cases for it.

[fulippio]

Has anyone found a way to insert line breaks via code in Doc templates?

Like <<CONCATENATE("Hello, br attribute goes here, “World!”)>>

[John_Henry_Jose]

The Virtual LongText Column name is “xUserInfo” to be printed like below

John Henry Joseph
QA/QC Manager, SHEQ Department, Bahrain
Raised on 11/6/2020 12:40:39

I want to show in Card type… screenshot is below.

Please advise.
Thanks.

[Steve]

It would appear the card view cannot display LongText values.

[John_Henry_Jose]

You mean multiline in virtual column text field will serve the purpose?

[Steve]

That question makes no sense to me.

[alphacp]

I think Steve is right as I just tried to do the same thing. I have a LongText field with CR/LF in it and Card View just ignores this and displays as a single line of text, wrapping as it sees fit.

[Mike_T]

Somewhat related…I added a line break but my line spacing is way off. i’m trying to build a dashboard and show a large number. Format rule is bold, green and bumped up to 1.2 font size. How do I space this out so it’s legible?

Forgot to mention this is a Show Type column in a Detail View…only showing the one row.

[Mike_T]

I solved by using an extra line break for spacing.

Expression:

COUNT(filter(Monitoring,[Status]=“Active”))&"

“&“Active Monitoring”&”

"&“Events”

Result:

[Entrenador_Hisp]

CONCATENATE( [ColumnA],"

“,[ColumnB],”

",[ColumnC])

Im not sure if it works, but it has been marked as solution in other posts

[MYKYMAGO]

En la expresión CONCATENATE, no funciona nada de lo que habéis publicado aquí, yo lo escribo como habéis dicho:

CONCATENATE([CCAA/FSS] ,"

“,[AF INAP],”

",[HORAS])

y se me queda todo junto en una linea con un campo tipo "longtext", en una vista tipo "Card", llevo más de 5 horas con este tema y si no se puede hacer, lo que se tiene que comentar es que es imposible y ya está.

[markbowhill]

On:

Card View
Virtual column type LonText

Neither CONCATENATE and & works for me.

[MelBTP]

What is the context around what you're trying to do? ie onboarding view, Show column, Display text??