Add Line Breaks to Concate

I am using Sugar On Demand Pro. I have the ability to create calculated fields for a text area I am working on. I want to know how I can create line breaks between items.
Here is an example:
concat($first_name_c," ",$last_name_c)

I wish for the result to be as :
John
Doe

I have tried basic php and html in there, but I just can not seem to break lines. Any suggestions on how to get that in there?

0 Joshua Baer over 9 years ago

Some added info.
I found createList which seems to be a good fit for what I am doing. Im actually trying to simplify a handful of fields into one simple text area. If creatlist is more appropriate, I will use it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 martuzs martuzs over 9 years ago

May be concat($first_name_c,"<br/>",$last_name_c)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rolustech Rolustech over 9 years ago

Hi,

Try adding <br/>\r\n between the fields.

Rolustech: SugarCRM Engineering
Website: www.rolustech.com
Ph (US): +1 - 310 - 492 - 5564
Ph (UK): +44 - 207 - 9938 - 524
Email: info@rolustech.com
Skype: rolustech
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Joshua Baer over 9 years ago

I originally tried both the above, and I gave it another shot.
the <br/> gets stripped by the formula builder. I feel like this is the right idea, I just need to figure out the correct syntax.

Here is what I tried with no success:

concat($first_name_c,"<br/>\r\n",$last_name_c)
concat($first_name_c,"\r\n",$last_name_c)

I tried the same variation with createList ( instead of concat.

I also tried two lines, like this, but the editor shows error and will not save.
concat($first_name_c)
concat($last_name_c)
If this could be made to work, I can settle with this idea to create two lines.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rolustech Rolustech over 9 years ago in reply to Joshua Baer

Hi,

Please try sending 'limit' => -1, 'max_results' => -1.

Rolustech: SugarCRM Engineering
Website: www.rolustech.com
Ph (US): +1 - 310 - 492 - 5564
Ph (UK): +44 - 207 - 9938 - 524
Email: info@rolustech.com
Skype: rolustech
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Joshua Baer over 9 years ago in reply to Joshua Baer

Could you clarify this some with an example Rolustech?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Joshua Baer over 9 years ago in reply to Joshua Baer

Any further ideas on this? I still cannot find a solution to break lines with formula builder.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Frédéric Rinaldi over 4 years ago in reply to Joshua Baer

Hello,
One of my customer asked me the same question ; with custom code no problem. But how to handle this with standard Sugar Logic formula ?
Best regards,
Fred
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel