Changing Field Style for Problem Tasks if due date is passed

Joe Taylor
Giga Guru

I'm trying to change the font color of the due dates in the list view of PTASKS if the due date is past, but no matter what I try it doesn't seem to work.

Here's what I have now:

Table: Problem Task [problem_task]

Field Name: Due date

Value: javascript:gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) <  0 ;

Style:  color:red;

What am I doing wrong?

Also, where can if find a comprehensive list of styles  (colors, background, font sizes, etc.) ?

 

 

1 ACCEPTED SOLUTION

If its exceeding the field limits then you can put the code in script include and from there return true/false.

Like for yellow you could do this.

1) Create a script include (I named mine as TestDate)
find_real_file.png

 

2) Then call the script include (and function - which I named isYellow) from Styles
find_real_file.png

 

Could you please mark my answer as correct? It gives me few points on community.

Thank you!

 

-Tanaji

Please mark reply correct/helpful if applicable

View solution in original post

22 REPLIES 22

Joe Taylor
Giga Guru

Where do I include this?  In the Value window?  Like this?

 

 javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())); answer; current.sys_class_name == 'problem_task'; 

Joe Taylor
Giga Guru

Hi MB.  Any guidance for my last question?

 

Open the same style sheet which you created for problem_task table >> change the table to Task [task] >> insert and stay. With this you will have a copy of this style for task table.

 

-Tanaji
Please mark response correct/helpful if applicable

In case you only want it to be only for problem_task record (but visible on task and problem_task) then ignore my previous comment and update the existing style which you have on problem_task table to look like this-

Table: Task [task]
Field name: Due date
Value:

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task'; answer;


Style: background-color: red

-Tanaji
Please mark response correct/helpful if applicable

Sorry about that.  Don't know how I missed that update.  Tanaji's answer below should do the trick for you.