Discussions

 View Only
  • 1.  COLORIZE FIELD

    Posted 12-13-2019 15:01
    I need to colorize a new "Rich Text Formula Field" (formula is equal to another field) based on a status field.
    new field: [NEED EWO#]
    formula 1: [JOB NUMBER2]

    Then, I need the field to be red if [EWO# STATUS]="GET EWO#"

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------


  • 2.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:05
    Do you want the words red or the background red?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:09
    The words

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 4.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:15
    new field: [NEED EWO#]
    formula 1: [JOB NUMBER2]

    Then, I need the field to be red

    IF([EWO# STATUS]="GET EWO#","<font color=red>" & [field to be colorized], [field to be colorized])

    .... but if the field to be colorized is numeric, then you will need to have

    IF([EWO# STATUS]="GET EWO#","<font color=red>" & ToText([field to be colorized]), ToText([field to be colorized]))




    i


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:17
    I don't need to do an "and" or anything after the 1st line in the formula [JOB NUMBER2]?

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 6.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:22
    the field that needs to be colorized is the new field [NEED EWO#]
    I'm trying to combine the formulas
    [NEED EWO#] is
    [JOB NUMBER2]
    IF([EWO# STATUS]="GET EWO#","<font color=red>")

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 7.  RE: COLORIZE FIELD

    Posted 12-13-2019 15:24
    Trying to do this
    [JOB NUMBER2] and
    If([EWO# STATUS]="GET EWO#","<font color=red>")

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 8.  RE: COLORIZE FIELD

    Posted 12-13-2019 16:03
    Is this what you want?

    IF([EWO# STATUS]="GET EWO#","<font color=red>" & [JOB NUMBW2], [JOB NUMBW2]) 

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------