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 

Fullscreen
1
2
3
Field 1 : value
Field 2 : value
Field 3 : value
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

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
  • 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.

    Fullscreen
    1
    2
    concat($field_1,"
    ",$filed_2)
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    FrancescaS

Reply
  • 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.

    Fullscreen
    1
    2
    concat($field_1,"
    ",$filed_2)
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    FrancescaS

Children