Calendar Alert Setup
I am in FMP Adv 10. I have a table which contains a drop-down calendar field which is setup in a portal that contains other text fields as well. I want to setup a script that that looks at the first portal row and checks the date in that portal row and 3 weeks after that date send me an alert email to notify me to contact that person. I want this new script to perform when the DB file is first opened, so it would be connected to my OpenFile Script. The table this portal/calendar is in is called PERSON and the table contains thousands of records (over 12,000) people contact information.
Does anyone know how to set this up?