Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
6 years ago

Rich Text Field

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. 

9 Replies

  • 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>
    • MarkComish's avatar
      MarkComish
      Qrew Assistant Captain
      Thank you for your quick response.  The field is automatically populated so how do I make it only do bold red text on the word "From"?  Can this be done with a formula rich text field?
    • JeffRichey's avatar
      JeffRichey
      Qrew Trainee
      Mark,

      I'm not sure I understand your exact use case, however the code above may be used in a formula rich text field to produce Bold Red Text similar to below.

      Note: The code must be enclosed in double quotes



    • MarkComish's avatar
      MarkComish
      Qrew Assistant Captain
      So the field gets populated by another app and brings in email chains.  The email chains are all grouped together.  I want the formula to basically say if "From:" exists in the field make it bold and red.
  • 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


    • MarkShnier's avatar
      MarkShnier
      Qrew Cadet
      :) Fortunately for you I'm addicted to solving native Quick Base puzzles.