AnsweredAssumed Answered

Calendar Alert Setup

Question asked by KAmsinger on Mar 25, 2011
Latest reply on Mar 25, 2011 by philmodjunk


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?