Get all that? Allow me to elaborate.
We have patient records that record both an admit date and a discharge date. My users want to see a calendar view that shows when the patients were admitted when and when those patients will discharge.
Currently, I’m showing this info in the calendar view by setting the first column of the view to:
@TextToTime ( @Text ( DCDate ) : @Text ( AdmitToDP ) )
This shows the patient name in the calendar twice; once for the admit and once for the d/c. The problem we now have is that there’s no way to differentiate which one is which.
I need a way to be able to colorize (or otherwise indicate) that one date is the admit and the other is the d/c. I’ve tried every function I can come up with and I’m lost. The closest I’ve come is @GetViewInfo, which has an option to return the columnvalue for a given row.
That’d be fantastic, except that the function cannot be used in column formulas.
Any suggestions on how this might be done would be most appreciated. I’m willing to concede that it can’t be done, but I want to exhaust all possibilities before admitting defeat.
Thanks!
Subject: Showing multiple fields from one document in different colors in a calendar view.
Put this code in a column before the column of the Field in question
In the column properties make sure that the Option ‘Use Value as Color’ is checked
I have done much work with Medical Applications within Lotus Notes and have used the above code too many times to count
Subject: RE: Showing multiple fields from one document in different colors in a calendar view.
Sorry…I should have been more clear.
I am already coloring the data in the view in the way you describe. The problem is showing the admits in one color and the discharges in another. I can show everything in one color or the other, but there’s no way that I can see to determine when to color a patient red or green (d/c or admit).
How would I tell the system, “Okay, when the day whose entries you’re painting on the screen is the same as the current entry’s admit date, do it in green. If it’s the same as the d/c date, do it in red.”
And yes, I’ve tried doing @Text ( 0:128:0 ) : @Text ( 128:0:0 ) to try to mimic the pattern done on showing the dates themselves…no luck.
Thanks for the try though.
Subject: RE: Showing multiple fields from one document in different colors in a calendar view.
my code must not have posted, it handled just what you are aksing for
gCustomerOrder := 230:241:253:211:9:99;
gNew := 255:254:216:0:0:0;
gReturn := 255:204:204:0:0:0;
gKilled := 194:206:153:74:26:81;
gApprove := 204:255:204:0:0:0;
@If(Form = “iCustomerOrder”; gCustomerOrder;
@If(Form = “iApproval” & @LowerCase(Status) = “approval rejected”; gReturn;
@If(Form = “iApproval” & @LowerCase(Status) = “approval killed”; gKilled;
@If(Form = “iApproval” & @LowerCase(Status) = “new”; gNew;
@If(Form = “iApproval” & @LowerCase(Status) = “approval ready”; gApprove; “”)))))
Subject: RE: Showing multiple fields from one document in different colors in a calendar view.
I see where you’re going with that, but it still won’t help me.
The nutshell of the problem is that I have to be able to highlight the date of discharge in one color and the date of admit in another. Unfortunately, I have no way of testing “the date currently being processed in the calendar view” so that I can compare it against the admit or d/c dates for the patient.
Thanks for trying though!
Subject: Showing multiple fields from one document in different colors in a calendar view.
Can’t be done with a Notes calendar view. That doesn’t mean it can’t be done at all, though. There are alternate ways to display the data – an outline view designed to look like a Gantt chart, a rich text table that looks for all the world like a calendar (the Midas Rich Text LSX would be EXTREMELY handy putting that together) or an HTML calendar similar to the Open WebCalendar I posted to the Code Bin over at OpenNTF.org, and so forth. You may need to bargain a bit with the stakeholders to find out exactly what they need (you know, like what kind of overview period they actually need to be able to see graphically).