Forum Discussion

PBInewbie17's avatar
PBInewbie17
Helper I
4 years ago

Create Two Data Alerts

I want to create two separate data alerts that will be used to trigger automated emails to employees depending on the number of days they have to meet their project deadline. The data alerts must meet the following criteria:

 

  • Alert 1: Data alert to email Certified employees with exactly 30 days until project deadline. I realize data alerts must be above or below a numerical threshold, so how can I measure this?
  • Alert 2: Data alert to email Certified employees with an Overdue project status (i.e., negative days until deadline). Once the data alert meets the criteria of having a negative number of days, is there a way to prevent the alert from triggering the overdue items twice? The dataset will be refreshed every day, and I don't want the alert for overdue items to be triggered every single day, only once.

EmployeeCertificationProject DeadlineDays Until DeadlineStatus
AmyUncertified4/29/2020-651Overdue
SaraCertified12/4/2021-67Overdue
XavierCertified2/9/20220In Process
JohnCertified3/10/202229In Process
BrittanyCertified3/11/202230In Process
DemetriCertified3/12/202231In Process
MarkCertified3/15/202234In Process
PaulCertified4/6/202256In Process
QuintoyaUncertified6/1/2022112In Process
RaviUncertified5/13/20251,189In Process

 

 

2 Replies