how do I add a newline in app formula? I am ...

(zhujian Tang) #1

how do I add a newline in app formula?

I am trying to use use App formula to add some long text in one field. Just wondering is there any way I can add new line in the long text.

For example, I want Value from Column A, B, C display in Column D. Instead of having

Value A Value B Value C in one line, can I have

Value A Value B Value C in three lines?

#2

Hi @zhujian_Tang What

are you trying to achieve. Could you explain your question a bit more thanks.

(Aleksi Alkio) #3

Would you please describe your request little deeper, thanks.

(zhujian Tang) #4

Hello All, I am trying to use use App formula to add some long text in one field. Just wondering is there any way I can add new line in the long text.

For example, I want Value from Column A, B, C display in Column D. Instead of having

Value A Value B Value C in one line, can I have

Value A Value B Value C in three lines?

(Aleksi Alkio) #5

Yes it’s possible…

CONCATENATE([ColA],"

“,[ColB],”

",[ColC])

(zhujian Tang) #6

@Aleksi_Alkio I will try now. Thanks a lot!

(Aleksi Alkio) #7

You’re welcome