Expand all | Collapse all

field with color condtion

  • 1.  field with color condtion

    Posted 08-29-2018 08:33
    Case([Status :], "COMPLETED", "<div style=\"color:black; background-color:#00FF00;\"> COMPLETED</div>",
    "IN-PROGRESS","<div style=\"background-color:#0000FF;\"> IN-PROGRESS</div>",
    "OVERDUE", "<div style=\"background-color:#FF0000;\"> OVERDUE</div>",
    "REJECTED", "<div style=\"background-color:#FFFF00;\"> REJECTED</div>",
    "QUERIED", "<div style=\"background-color:#FFFF00;\"> QUERIED</div>",
    "DELAYED","<div style=\"background-color:#FFA500;\"> DELAYED</div>", "")

  • 2.  RE: field with color condtion

    Posted 08-29-2018 14:09
    Hi Aroof,

    Were you having some specific trouble with the formula listed above? 

  • 3.  RE: field with color condtion

    Posted 08-30-2018 03:26
    I need to add another filed in this formula 

    "status" is a parent field and it consist of dropdown option ,and it is unable to process for formula in the same field .is there any option to add both dropdown and formula.

    status - filed 

    field type : dropdown 

    final view  in field : if any drop down list is selected color of the field need to change automatically .