Field color change with calculation
I have a layout that tracks processes according to dates entered by the user.
Currently I have conditional formatting calcs that either turns the field RED if current date is greater than or equal the entered PLAN date and YELLOW if the PLAN date is greater than current date and less than current date + 7 days.
After thinking this over I realized that conditional formatting is not going to work as this only works when the user actually "touches" the field. Instead I need a script trigger OnLayoutLoad where I can use the same calcs to change the field background colors accordingly.
Is this possible.
Version:1.0 StartHTML:0000000167 EndHTML:0000000641 StartFragment:0000000454 EndFragment:0000000625
(not IsEmpty ( ProcessTracking::P10PlanDate )) and (ProcessTracking::P10PlanDate ≤ Get ( CurrentDate ))
Version:1.0 StartHTML:0000000167 EndHTML:0000000657 StartFragment:0000000454 EndFragment:0000000641
(ProcessTracking::P10PlanDate > Get ( CurrentDate )) and (ProcessTracking::P10PlanDate ≤ Get ( CurrentDate ) + 7)
I do have a sample DB setup if needed.