Forum Discussion

KaranJoshi's avatar
KaranJoshi
Qrew Member
3 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
------------------------------
  • 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
      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
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------