Discussions

Expand all | Collapse all

Color coding a field based on anything or nothing data

  • 1.  Color coding a field based on anything or nothing data

    Posted 03-26-2018 18:26
    I am working on some color coding and I can not figure out the formula needed to color a row based on if a field contains anything...can you help me with this? Do I still use Case or do I use If? Example: I have a field labeled Payroll Notes, I want the field highlighted if there are any notes in the field regardless of what they are and not highlighted if the field is blank.


  • 2.  RE: Color coding a field based on anything or nothing data

    Posted 03-26-2018 18:35
    The row colorization formula would be 

    IF(Trim([Payroll Notes])<>"", "pink")

    or else you can use hex codes

    IF(Trim([Payroll Notes])<>"", "#F9A7B0")

    Here is an app from another QSP Laura Thacker to see the effect of lots of hex color codes.

    https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1


  • 3.  RE: Color coding a field based on anything or nothing data

    Posted 03-26-2018 18:57
    Awesome!!! Thank you soooo Much!!!