I am currently working on a database of patients and would like to set up an alert system that notifies us to call patients either 6 months or 12 months after a surgery date.
For example, if I input into Procedure Date "10/06/2016", I would want to receive an alert on 04/06/2016 to call the patient for a 6-month follow-up appointment.
Is there anyone with experience creating this kind of alert system? My guess is that a script of some sort would be needed. I'm a beginner when it comes to Filemaker, so any advice would be appreciated.
Two conceptual designs that I have thought of are:
1) Exclamatory icons that appear next to a patient's name when it is time for their 6 month/12 month follow-up
2) Pop-up window when you open the database that gives a list of patients that need to be notified for their follow-up