Skip to main content
Question

Colored text from formula field, when displayed in another field using the ""Part"" function, does not display in color.

  • September 18, 2017
  • 0 replies
  • 42 views
I have information which goes through several formula fields, and seems to lose it's color along the way. Information, such as "serial numbers", are entered by the end-user  into one of three text boxes: Type One, Type Two, and Type Three.  Each serial number is separated by a comma. Then, all three "types" are combined within one formula text field, [All Serial Numbers in this Project], after checking for other conditions using an "If".
 Each "type" has a unique color, here is the formula : If ([Check for Blank Type 1] = false, ""&[Serial (Type 1)]& ",\n" &"")& etc. for each box. This field displays serial numbers in three different colors, corresponding to the "type".
 Afterwards, the serial numbers are split up into individual fields, using the "Part" function: Part([All Serial Numbers in this Project], 1 , "," ) , with each field containing a different "Part". The problem is that in these individual fields, only "Part 1" retains it's color, any subsequent color displays as black. Is there a better way to color the [All serial numbers in this project] field so that this should not happen?
      This topic has been closed for replies.

      • ArchiveUser
      • Registered
      • September 18, 2017
      Every field where you want something to show in a particular color will have to have that built into the formula. For example:

      <span style="color:blue">blue</span>
      I accidentally left out some of the formula.  The original formula box contains  If ([Check for Blank Type 1] = false, "<div style=\"color:Green; \">"&[Type 1 (Cures)]& ",\n" &"</div>")&   etc, with a different color for each "type".  These colors display fine, I would like the very same colors to carry over to a different formula field which selects certain serial numbers using "Part".
      Terms & ConditionsAccessibility statement