Discussions

 View Only
  • 1.  Corrected formula coding in Color-Coding

    Posted 03-15-2023 08:29

    I currently have this code 

    Case([Follow-Up],"Check on Inspection","#7FE2EA", "Waiting on email response","#f69100")

    and I wanted to add a code to highlight a record based on a date field. I tried both of these and they are not correct. Can anyone assist me with how this field should be formatted?

    If(Today() > [Adj. By], "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", [Record ID#])

    Case(
      Today() > [Adj. By], 
      "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", 
      [Record ID#]
    )

    Thank you!

     



    ------------------------------
    Rhonda Jones
    ------------------------------


  • 2.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:10

    Are you trying to highlight a whole row with Row colorization, or are you trying to highlight a single field in a report?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:13

    I am trying to highlight the whole row on the table



    ------------------------------
    Rhonda Jones
    ------------------------------



  • 4.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:16

    Try this

    IF(Today() > [Adj. By],  "#FF0000")

    Laura Thacker, made a nice app here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000009&dr=1 with all the hex color codes but you can also use many of the color name works like blue, green, pink etc.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:22

    So like this?

    Case([Follow-Up],"Check on Inspection","#5e9dff", "Waiting on email response","#aff5f1") 

    IF(Today() > [Adj. By],  "#FF0000")

    It is giving me the "extra characters beyond the end of the formula"



    ------------------------------
    Rhonda Jones
    ------------------------------



  • 6.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:40

    OK, sorry I didn't originally understand that you wanted to check for three different situation and colour code accordingly.  

    IF(

    [Follow-Up] = "Check on Inspection","#5e9dff", 

    [Follow-Up] ="Waiting on email response","#aff5f1", 

    Today() > [Adj. By],  "#FF0000")

    You have to consider the sequence of the tests above because it will go with the first one that is true. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Corrected formula coding in Color-Coding

    Posted 03-15-2023 09:45

    Understood. That worked, thank you. That color page is also very helpful.



    ------------------------------
    Rhonda Jones
    ------------------------------