Forum Discussion

RhondaJones's avatar
RhondaJones
Qrew Cadet
8 years ago

Highlight record when new record added to related table

I am not great at writing original code and I can't find this anywhere.  I am trying to automatically highlight a record on a table when a new record is added to a related table.  In this case I...
Formulas and functions
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
You can accomplish this a few different ways with some summary fields.  

My questions;
 How would those records become 'un-highlited'?  Over time, or do you do something to the request that would indicate you have acknowledged it?

Once that is determined you will want to make sure you count for that in the logic of the summary field.
But you could just summarize the '# of new requests' that are not acknowledged.

Then your highlighting criteria would be 

If([# of new requests]>0, "#color", "")