I am designing a view with several columns that display benchmark dates. I want to change the font color to red when that benchmark date is equal to or after @Now when it is viewed each time. Can this be done? In the form I think it would be easy but will it change the font color in the view? I’m thinking not.
Rick Bushey
Subject: RE: Changing font color in a view.
Read up in the Designer help about color columns.
Setting the color based on @Now (or @Today), however, is going to cause significant performance degredation because it will prevent the server from calculating column values in advance and storing them. The server normally revisits documents to see whether they are still in the view and what their column values are, only when the documents are modified (or if the view is unused for a very long time). Instead, the server will have to look at every document every time the view is used, to see whether the color should be different.
Depending how many documents you have (or expect to have) in this database, the performance may be acceptable anyway. If not, this issue has been discussed endlessly here – search for view today and you’ll find lots of useful info. Or check out my blog (link below), same search.
Useful blog: Best Practice Makes Perfect
For faster answers, be C R I S P Y
Subject: RE: Changing font color in a view.
Thank you very much! My customer will be having a few thousand detailed records initially and I think you are right. The overhead is too high for this.
Thanks again,
Rick