0

Rich text in Formula field

HI how can i make some text bold within a formula field ,

i know it uses html but i dont know how to put that in.

 

below is exapmle of the code i have and i made bold the fields i want display as bold text 

let xCurrRec := Id;
let xOrderdetail := "";
for i in select 'Order item lines' where Orders = xCurrRec do
xOrderdetail := xOrderdetail + "ITEM #" + " " + i.Items.Number + " - " + i.Items.Description + " - " + "QTY" + " " + i.Qty + "
" + "
" + i.Formula
end;
xOrderdetail

4 replies

null
    • Ppc
    • titanium_fish
    • 3 yrs ago
    • Reported - view

     "ITEM #"

     "QTY" 

     i.Formula

    • Sean
    • 3 yrs ago
    • Reported - view

    Build your xOrderdetail string first, then use the html() function.

     

    xOrderdetail := xOrderdetail + "<b>ITEM #</b>" + " " + i.Items.Number + " - " + i.Items.Description + " - " + "<b>QTY</b><br>" + i.Qty + "<br><br><b>" + i.Formula + "</b>"

    html(xOrderdetail)

     

    I can't test it exactly as you have it, but I think it will work. Since you will be using the html() function, you can't just embed a line feed in the string. You'll need to use the <br> tag instead.

    • Sean
    • 3 yrs ago
    • Reported - view

    xOrderdetail := xOrderdetail + "<b>ITEM #</b>" + i.Items.Number + " - " + i.Items.Description + " - " + "<b>QTY </b><br>" + i.Qty + "<br><br><b>" + i.Formula + "</b>"

     

    I forgot to clean up some of the spacing.

    • Ppc
    • titanium_fish
    • 3 yrs ago
    • Reported - view

    Thank you , good start for me. tnx

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 1036Views