Jump to content

Highlighting Overdue Tasks in Portals


robert2504
 Share

This topic is 6482 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everyone,

I am trying to highlight an overdue tasks on my portal.

This is what I have so far. The name of the task has a calculated value:

Case (Get(CurrentDate) - T_DUE_DATE > 0;

TextStyleAdd(Red(T_NAME);Bold);

TextStyleAdd(Black(T_NAME);Plain))

Red and Black are custom functions; They do work.

Now here is my problem. If I create a task and I entered the due date and that due date is prior to today's date, The task is colored red. For all those tasks that were entered prior and show a due date prior to today, they are ignored. If I go back and reenter the same date, they change the text color to red. I am beginning to think that tomorrow, all those tasks that were due today will not change color to red unless I reenter the date of yesterday. Is there a better solution to marking overdue tasks red. What is the best way to mark them; the field text or the row color?

Thanks

FileMaker Version: Dev 7

Platform: Windows XP

Link to comment
Share on other sites

I haven't tried your example, but it looks like your problem could be because the Get(CurrentDate) makes your calc unstored. Unstored calcs don't automatically update.

I think marking overdue tasks in red is a good idea, but you may have to run a script to update the records, or set a flag.

Link to comment
Share on other sites

This topic is 6482 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.