using Filemaker as a calendar to link to contact information
Hi. I am completely new to relational databases. I prepare the call schedule at my hospital for the doctors. So, for years, I have used EXCEL to basically provide the names of the doctor for each day, as follows:
GROUP SUN MON TUE WED THUR FRI SAT
Anesthesia dr. 1 dr 2 dr 3 dr 4 dr 1 dr 2 dr 3
Pediatrician x y z a b x x
Surgeon j k l m m m m
The problem: EXCEL can not display the Doctor's pager (or contact information). So, at the end of the day: if the nurse needs the doc, she needs to go out of Excel, into an old-fashioned Roladex (or use a second spreadsheet).
So, I am looking for a way with filemaker to display ALL that information together. I use iCAL, and iCAL is basically Okay, but it has a few drawbacks:
a. Ical won't let me list the group of Docs to the left-hand side
b. Ical won't let me have different colors for different groups
c. Most important: iCAL won't let non-MAC users make changes.
Right now, I am trying to figure out a solution using the trial version. Thank you in advance for any help.
This is not something I would recommend as your first project. However, do take a look at the demo posted here (you will need to change People into Groups and Tasks into Doctors).
You could define the diplayed Task/Doctor as a button that goes to related record to display more details.