AnsweredAssumed Answered

Email Alert Script Help

Question asked by MMCDSMP on Jun 20, 2017
Latest reply on Jun 20, 2017 by philmodjunk

I want to run a script to automatically generate an email reminder, for each incident within 10 days of trigger date, of course only once for each incident.  I Have a field (Send out 90 Day PAM) that auto calculates 90 days post  training (End Date). I wish to receive a reminder email about 10 days in advance of this (Send out 90 Day PAM). Please see my screen capture below, this is the script I have written. However, it will return only one result and no matter what I change the (Send out 90 Day PAM) to, it keeps sending only this one case. That is, even though I have multi incidents meeting the same criteria of within 10 days! Any assistance would be most appreciated!!! Further, how can I automate to send on opening the file each day without repeating daily?

Email Reminder Script.jpg