2 Replies Latest reply on Aug 2, 2011 12:51 PM by mfl666

    Field color change with calculation

    mfl666

      Title

      Field color change with calculation

      Post

      Hello,

      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.

      Thanks

      Michael