Forum Discussion

KaranJoshi's avatar
KaranJoshi
Qrew Member
2 years ago

Highlighting a record in a table

Hello!

I have a simple app with 4 tables containing information regarding documents. One of the fields on the form for each table is the date the document was implemented. How can I potentially highlight the record for a specific document to red/yellow if it has been over 1 year since the implementation date. I would like to do this without having to create relationships or additional tables. Is it feasible? If so, what's the best way to achieve this? 

Thanks for the help!

------------------------------
Karan Joshi
------------------------------
Formulas and functions
reports and charts

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    Are you trying to highlight rows of a table report?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • KaranJoshi's avatar
      KaranJoshi
      Qrew Member
      2 years ago
      Preferably Yes, to highlight the whole row on the main table so employees know it needs to be re-implemented. If that is complicated, I'm also okay with having a field on the form itself for each record that highlights if its been 1 year or more

      ------------------------------
      Karan Joshi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        Try this as a row colorization formula on the Table Report configuration

        IF(AdjustYear([Implementation Date],1) < Today(), "yellow")

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