I manage a single (flat) database. I track the dates of patients documentation due by the clinical staff in calculated feilds. So bascially i enter the admit date of a patient and based in that input the different dates of various documents that need to be generated for that client are automatically displayed in their respective feilds. I used to manage this database on Excel, but would like to now use filemaker 8. So I imported these records into their fields. I would now like to write a script to turn the fonts to red if they are not already changed from black to gray. I change the fonts from black to gray when the documentation for that particular patient is recd. So basically, if the current date on the computer = the date on the date on the database and the font is black, I would like FM to turn it to red. Is this possible at all?? Any comments or feedback would be appreciated. Yes..I am a newbie.Ritu

I'm not sure it's nessersary to script it, or rather I wouldn't! But yes it's indeed posible to make a script process all fields "links" and change the field colour accordingly:

http://www.filemaker.com/help/FunctionsRef-388.html

http://www.filemaker.com/help/FunctionsRef-390.html

But I guess that my solution to you issue would land in the vicinty of this template instead:

http://www.kevinfrank.com/download/county-highlight-in-portal.zip

--sd

Thank you for the feedback. Will look at your template.

I believe it could be done in a much more simpler way:

Untitled.fp7.zip

Thank you. i looked at it and some questions.

Let (

d = BaseDate + 90

;

TextColor ( d ;

Case (

RecvDate ; RGB ( 150 ; 150 ; 150 ) ;

gToday > d ; RGB ( 220 ; 0 ; 0 ) ;

0

)

)

)

Pardon my ignorance but what is d?

and why + 90

so in other words if i have 10 different documents per client 3 documents due on the base date, then 2 documents 14 days later and then 3 documents 44, 74 and 104 days later and 4 other documents 14 days later based on another base date (which I could add, just like you did for the first) is the +90 the variable number? Thank you so much for your help though. Ritu

In my example, BaseDate is the date against which the deadline is computed ('admit date' in your original post). d is the computed deadline - in this example, it is 90 days from BaseDate. gToday is a test field - in the real calculation, it should be replaced with Get(CurrentDate).

If you have 10 documents per client, perhaps you should consider adding a related Documents table, and tracking their status in a portal.

thanks so very much :)