Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
6 years ago

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

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's avatar
    EverettPatterso
    Qrew Captain
    6 years ago
    Use IOL and one line of script

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

    ​

    ------------------------------
    Everett Patterson
    ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      6 years ago
      Wow... Duh.

      and here I use IOL pretty much everyday... and I didn't even think of that.

      ------------------------------
      Ryan Stanford
      ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      6 years ago
      Have you happened to do any work regarding IOL with the new mobile app? It appears the most recent update kinda broke my stuff on the mobile app.

      ------------------------------
      Ryan Stanford
      ------------------------------
      • EverettPatterso's avatar
        EverettPatterso
        Qrew Captain
        6 years ago
        No sorry, I haven't had much need to use IOL on mobile.

        ------------------------------
        Everett Patterson
        ------------------------------
    • kheatley's avatar
      kheatley
      Qrew Member
      21 days ago

      Is there anyway of doing this now that IOL is obsolete? 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    21 days ago

    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)