Databases Reference
In-Depth Information
An alert can be triggered by three events: after the document is opened, after it is
reloaded, or after data reduction. The alert can show a pop-up message or send an
e-mail to one or more recipients.
Before diving deeper into alerts, we will first look at a practical example. We will
set up an alert that will notify us with a pop-up when the average occupancy for the
top ten carriers, based on number of transported passengers, falls below 85%. Let's
follow these steps:
1. Select
Tools | Alerts
from the menu.
2. Click on the
Add
button.
3. In the
Description
input box enter
Top 10 carriers load factor %
.
4. Select
Top 10 carriers by transported passengers
from the
Bookmark
drop-down list.
5. In the
Condition
input box, enter
$(eLoadFactor) < 0.85
.
6. In the
Message
input box, enter the following message:
The average load
factor % has fallen below 85% for the top 10 carriers
.
7. Enable all events,
On Open
,
On Post Reload
, and
On Post Reduce
.
8. Click on
OK
to close the
Alerts
dialog.
9. Select
File | Save
to save the document.
10. Select
File | Close
to close the document.
11. Reopen the document.
As the condition we set is always true (occupancy for the top ten carriers is around
80 percent), when we reopen the document we will see the following alert pop up:
