How about an email produced once a day, or once a week listing all patients that need to be notified?
Your approach requires that someone actually review a list on the screen and spot those that have a visual alert next to their name.
You can set up a calculation date field such as:
If ( Not IsEmpty ( FollowUp ) and Not Notified ;
Date ( Day ( apptdate ) ; Month ( Apptdate ) + FollowUp ; Year ( apptDate ) ) )
Then a script can, on a regular schedule, perform a finds specifying criteria in this field to find patients that need to be notified and you can set the Notified field to 1 or True to clear this field to indicate that they have been notified. FollowUp would be either empty, 6 or 12 in order to calculate no follow up, a 6 months follow up or a 12 months follow up
This is a fantastic solution, I appreciate it.
After the script is created based on the fields in question, what would be the best way to setup my database to get an email sent to me?
You'll need to figure out how many days "lead time" you need.
If the Followup date is 10/20/16, do you want to be notified 5 days prior? 10? or ???
For this example, I'll pick 7 days, but you can insert any figure that works for your "business rules" in place of that value:
Set up a script that performs a find on that field to find all records with a date 7 days from today through today.
Enter Find Mode ---> no pause, no stored criteria
Set Field [Appts::FollowUpdate ; Get ( CurrentDate ) - 7 & "..." & Get ( CurrentDate ) ]
Set Error capture [on]
Perform Find 
If [ Get ( FoundCount ) > 0 // records were found for patients needing notification ]
Send Mail [ ]
At first, run the script manually without send mail--to pull up the list of appointments with upcoming follow up appoints where you have not yet marked them as "notified". Once you are satisfied with the results you can auto-mate the process. A server scheduled script could run each night for example.
And you can then see about how best to pull the needed info into an email to send out. A "list of" summary field can list data from all records in a found set and you can use it to pull that data into the body of your email, or you can save a PDF of your layout and email it as an attachment.