Calculated field - How to insert a carriage return WITHOUT custom code (hook, new sugar logic etc.)

Hello,

I am facing an issue that is not new but I am hoping that someone somehow got my answer !

i want to calculate a textarea field as a text summary of several other field.

My content would be like

Field 1 : value
Field 2 : value
Field 3 : value

This is something easy to do using calculated fields except that there is no easy way to insert a carriage return ; I tried \n...nope ; I tried </br>....nope.

Of course I can create a hook or design a custom sugarlogic formula but I was wondering if someone knows a trick to avoid this.

Many thanks,

Fred

Parents

0 Francesca Shiekh 3 months ago
The solution is really silly, quite literally put a return in quotes, so the opening quote is on one line and the closing quote is on the second line.

concat($field_1," ",$filed_2)

FrancescaS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Chris Raffle 3 months ago in reply to Francesca Shiekh

I tested the same earlier today and this did not work for me unfortunately.

Chris

Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh 3 months ago in reply to Chris Raffle

Interesting, I tried it in v12 and it worked.
I had also tried inserting the ascii for a line break in the quotes, it worked, but formula builder turned it into the above.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Francesca Shiekh 3 months ago in reply to Chris Raffle

Interesting, I tried it in v12 and it worked.
I had also tried inserting the ascii for a line break in the quotes, it worked, but formula builder turned it into the above.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data