ETA | Incident Colour Change

johnpeckcvc
Giga Contributor

Hi there,

We've recently implemented ETA times in our Incident Managements and I'd like this to be highlighted when the time approaches:

As you'll see bellow, the ETA (last column on the right) represents a time which an update must be provided by to the user.

find_real_file.png

What I would like to do is the following:

ONE hour BEFORE the ETA expires - the entire row text turns orange.

30 minutes BEFORE the ETA expires - the entire row text turns red.

Can somebody please explain how I can do this.

Thank you.

JP

2 REPLIES 2

Ct111
Giga Sage

Simple way would be to use Field styles on Task_SLA table or the table from where the ETA comes.

 

Then put the condition inside the value field

 

NOte : Best way to do this is create the filter first and then copy that filter value and paste it with javascript like below 

 

javascript: your query

 

style : the color you wanted 

 

 

I am attaching the example snapshot so you get the clue .

 

find_real_file.png

 

Mark my ANSWER as CORRECT and HELPFUL if it helped.

oshina1
Kilo Contributor

can you explain in brief?

I do have a record producer on service portal and I want to calculate ETA. how to do that ? can you help me ?