Answer Question
Send an email alert to each user of the php application based on criteria
The hosted php application has a mysql database. The following conditions must be true to trigger the email notice at a specific time. I'm using general terms to get the idea across.
1. the initial "form" must be approved; form A baseline "0"
2. the "form" must be less than 100%;
3. the previous "form" must be approved; form B revisions "1,2,3..."
All three of these conditions are fields in the database.
A cutoff deadline date is set for each record for instance day 20, which could be any month.
The event is triggered when the all of the above conditions are true and 7 days prior to the cutoff day an email notice is sent to all records meeting the conditions. In this example the email will go out on day 13 each month until a false condition exists.
TEXT
Uploading file and scanning for virus...
Please Wait