How to add line breaks to calculated values?

[BeffreyJezos]

Hi everyone.  I was  wondering if there is a way to put line breaks in  calculated values? Like I can concatenate strings without problem but I want the next field under my first field instead of just a space in the middle.

Example:
Field1
Field2

What I have now is: Field1 Field2

I cant use <br> or press the Enter key. It does not do anything. I cant find it in Localizations either. Anyone has a workaround for this?

Thanks,
Hexy

[Tubby]

I think you can actually use <br> for Calculated Values. However, you will need to enclose it with a single quote. 

Refer to this syntax:

'[@field:Line1]'+'<br>'+'[@field:Line2]'

You can also use CHAR(13) which is a SQL Function called "Carriage Return" since Calculated Values accepts SQL statements.

Refer to this syntax for CHAR(13):

'[@field:Line1]' + CHAR(13) + '[@field:Line2]'

This will output the values like shown in the screenshot below:

I hope you find this useful.
 

[BeffreyJezos]

Sorry for replying late @Tubby.

I have tested both of this. They both work perfectly for Calculated Values! Thanks!

I went with the '<br>' as I am most familiar with it and because I think CHAR(13) only works with calculated values and not formula fields. I am not sure if this is expected since formula fields and calculated values looks and works very similarly.

Anyways, thanks for the help.

Hexy

[RuisiHansamu]

Hello, I just wanted to add these helpful articles that are very useful. These documents helped me a lot on my end. 

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/function-reference/

https://developer.mozilla.org/en-US/docs/Web/HTML/Element/br

Cheers!