Forum Discussion
MCFNeil
8 years agoQrew Captain
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", "")
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", "")