Discussions

 View Only
Expand all | Collapse all

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

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

    Posted 09-18-2017 15:23
    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?


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

    Posted 09-18-2017 17:22
    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>


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

    Posted 09-18-2017 17:29
    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".