Skip to main content
Question

Color Coding of reports, but only high light the cell in question

  • August 26, 2019
  • 0 replies
  • 68 views
The conundrum I'm having is how can we highlight just a cell that triggers a Color-Coding situation.

if(Contains(toText(<any Field at all>),"??", "#FF0000)

We want to implement a rule like this for a report... for every field, and ideally only highlighting the cell/field that has the ?? in it.

Is there anyway to do this, besides having a custom rich text field copy of the text field with a <div> around it and using case for background-color... or Code Page IOL that parses the entire page?

------------------------------
Ryan Stanford
------------------------------

    EverettPatterso
    Forum|alt.badge.img+10
    Use IOL and one line of script

    $("#VR_tableDBID_reportID td:contains('No')").css("background-color","red");

    ​

    ------------------------------
    Everett Patterson
    ------------------------------
      MarkShnierYou
      Forum|alt.badge.img+24

      You would need to create a new formula field.  I usual name them like [Field A.] with a period so I know it's a mirror type field.  The use this syntax.

      https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields

      Background Shading

      var text DateText = ToText([Delivery Date]);

      var text ColorCode =

      If(

      [Delivery Date]-Today()<Days(1),"pink",

      [Delivery Date]-Today()<Days(3),"yellow",

      [Delivery Date]-Today()<Days(5),"green");

      var text DateText = ToText([Delivery Date]);

      Case($ColorCode,

      "pink","<div style=\"background-color: pink;\"" & ">" &  $DateText & "</div>",

      "yellow","<div style=\"background-color: yellow;\"" & ">" &  $DateText & "</div>",

      "green","<div style=\"background-color: #00C957;\"" & ">" &  $DateText & "</div>", $DateText)

       

      Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement