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------------------------------
Original Message:
Sent: 07-28-2022 12:57
From: Karan Joshi
Subject: Highlighting a record in a table
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
Original Message:
Sent: 07-28-2022 12:35
From: Mark Shnier (Your Quickbase Coach)
Subject: Highlighting a record in a table
Are you trying to highlight rows of a table report?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 07-28-2022 12:34
From: Karan Joshi
Subject: 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
------------------------------