Highlighting a record in a table

Question

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?&nbsp;Thanks for the help!------------------------------Karan Joshi------------------------------

markshnier__you · Answer

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
------------------------------

markshnier__you · Answer

Are you trying to highlight rows of a table report?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

karanjoshi · Answer

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
------------------------------

Forum Discussion

Highlighting a record in a table