Solution: Dynamic Status and Deadline Color and Note Marker Description: Here is a nice visual feature to add to your solution. Dynamically mark your assignments with color and deadline notes!

August 18, 200718 yr

Solution: Dynamic Status and Deadline Color and Note Marker

Description: Here is a nice visual feature to add to your solution.

Dynamically mark your assignments with color and deadline notes!

This solution can easily be customized to fit your needs.

Deadline Marker: clc_marker will tell user how many days are left till deadline. If deadline is pass and status is NOT complete, marker will result in “TARDY” letting User know Assignment needs immediate attention. If Assignment is past due and complete, marker will result in “X”, letting user know that Assignment is finished.

Deadline Color: clc_color_deadline will result in gray, magenta, pink, yellow or green depending on days left till deadline.

Status Color: clc_color_status will result in gray for Complete, yellow for On Hold, green for Working.

Working Under:

Solution Status: Finished

Pre-requisites:

Author(s): Dr. Evil

Date: 08/18/07

Credits:

Instructions / Other Info: LESSON ONE:

In Case( ) expressions, the result associated with the first true argument is returned. Since the first test in your formula is a subset of the second, it will always be returned (ie in all cases where the first argument is valid).

I suggest you try re-ordering the expression and adjusting the arguments (so that the first test checks if the due date has passed). Eg:

Case(

date_deadline < Get(CurrentDate) and txt_status = "Working"; "TARDY";

date_deadline ≥ Get(CurrentDate); date_deadline - Get(CurrentDate);

"X"

)

LESSON TWO:

& appends two strings together:

"ab" & "cd" -> "abcd"

"and" is a boolean operator:

True and False -> False

True and True -> True

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

DynamicStatusDeadlineMarker.fp7.zip

Edited August 19, 200718 yr by Guest