Jump to content
  • 0

How to add line breaks to calculated values?


BeffreyJezos
 Share

Question

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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:

image.png.6e3a10d19af8d0e31d28ee6818039f98.png

I hope you find this useful.
 

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...