Changing the color of a font automatically

[Ritz]

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

[Søren Dyhr]

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

[Ritz]

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

[comment]

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

Untitled.fp7.zip

[Ritz]

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

[comment]

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.

[Ritz]

thanks so very much :)