Skip to main content
Question

Rich Text Field

  • June 20, 2019
  • 0 replies
  • 81 views

Can you make a Rich Text (formula) field bold and color a word if it exists?  I use SendToQuickbase to pull in emails received in outlook.  I would like anywhere the message has "From:" to be automatically made bold and / or made to be red. 
This topic has been closed for replies.

Forum|alt.badge.img+2
  • Registered
  • June 20, 2019
Hi Mark,

You can easily do this with inline style tags. Something like this should get you started.

<span style=\"color: #008000;\"><b>Bold Red Text</b></span>

here is some code that seems to work

var text MakeRed = SearchAndReplace([Raw text],"From:","<br><br>From:<font color=red>");
var text EndRed = SearchAndReplace($MakeRed, "<", "</font color><");
var text DateBreak = SearchAndReplace($EndRed, "Date:", "<br>Date:");
var text SubjectBreak = SearchAndReplace($DateBreak, "Subject:", "<br>Subject:");

$SubjectBreak



  • Author
  • Registered
  • June 21, 2019
As always you are the man!!!!