You need to sign in to do that
Don't have an account?
Middha
New line character in default value of Text area field
Hi,
I am trying ot create a new Long text area field with some default value which should look like:
1. This is line One.
2. This is line Two.
Can anyone tell, how do i set the above text in the default section of the field as the section does not accept new line charachters. I am only able to set the text as:
"1. This is line One. 2. This is line Two."
I also tried using a formula function BR(), <BR>, \n\r, \r. But none of them works. Can anyone helpout with the correct syntax?
Thanks in advance.
I am trying ot create a new Long text area field with some default value which should look like:
1. This is line One.
2. This is line Two.
Can anyone tell, how do i set the above text in the default section of the field as the section does not accept new line charachters. I am only able to set the text as:
"1. This is line One. 2. This is line Two."
I also tried using a formula function BR(), <BR>, \n\r, \r. But none of them works. Can anyone helpout with the correct syntax?
Thanks in advance.
Can we see an example of the code as it currently stands?
mousetrap
"1. This is line One. 2. This is line Two."
But i want it to be :
"1. This is line One.
2. This is line Two."
which is not accepted by the formula section.
I need to do the same as described in post. how can I add new line in the string when using in a formula
For those still looking for solution
"1. This is line One." + BR() + " 2. This is line Two."
This works OK if you just want to display the results, but if you have to export the formula field or do a mail merge, then the value appears as "This is line 1 <BR> This is line 2." We really need a true newline function and I don't think there's a workaround for the lack of newline.
David
Try
"abc" & BR() & "xyz" this is correct formula for line break in long text area field
Use "\r\n" instead of "\n" and BR(). It will work..