Rich Text Field

Question

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

jeffrichey · Answer

Hi Mark,You can easily do this with inline style tags. Something like this should get you started.&lt;span style=\"color: #008000;\"&gt;&lt;b&gt;Bold Red Text&lt;/b&gt;&lt;/span&gt;

markcomish · Answer

Thank you for your quick response.&nbsp; The field is automatically populated so how do I make it only do bold red text on the word "From"?&nbsp; Can this be done with a formula rich text field?

jeffrichey · Answer

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 · Answer

So the field gets populated by another app and brings in email chains.&nbsp; The email chains are all grouped together.&nbsp; I want the formula to basically say if "From:" exists in the field make it bold and red.

quickbasecoachd · Answer

Can you post an example of the inbound raw email?

Forum Discussion

Rich Text Field

Related Content

Rich text field html whitelist

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Creating a Formula Rich Text Field

Pulling A date from anther form based on a text field name

Search for Multiple/Many Unique Asset IDs in text Field.