Show Occurrence

July 16, 200916 yr

I have looked through the entire calculation forum and have not been able to locate a solution to my question.

I just moved my student database up to Filemaker 9. I thought while I was in the process of adding some new fields I would try to set up a calculation for my students who have to take medicine, to insure that the Nurse does not overlook a scheduled dispense.

If I have a student who brings a medicine to school on Monday 8-10-09 and they need to take it every two days for the next 14 days. Is the a calculation I can implement to show that today is the day she has to take the medicine, and then again in two days.

Also, can someone tell me how to add a photo to my profile, I see the image link above the text box, is that it?

M. Logan

July 16, 200916 yr

Michelle,

There are just a plethora of ways to do this but I will start with the simplest. This is the absolute simplest:

Add a field to the student table called dispensation. In this field enter a return-delimited list of the dates a student needs to take a medication. For example:

7/16/2009

7/17/2009

7/20/2009

Then, add a calculation field that calls

Case (

ValueCount ( FilterValues ( dispensation; GetAsText ( Get (CurrentDate) ) ));

"Today"

)

This calculation will return "Today" if today's date is in the list. Make sure that the calculation is unstored. I made a sample file, attached.

It would also be helpful to add a dispensationNotes field with info like what the drug is, etc.

I should also note, the ideal way to do this would be to create a separate drugs table and then make a dispensation join table with a record for each time a nurse administers the drug to the student. You would then need some sort of looping script with parameters for occurrence that would know how to skip weekends, holidays etc to create the records. This may be a level of complexity you don't need.

Student_Record.fp7.zip

Edited July 16, 200916 yr by Guest