Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to set an email notification when expiring/end date is approaching?

skendy
Tera Expert

Hi,

I have a custom table which is in relationship with the pm_project table.

It populates the alert (a kind of critical issue) for the project. The alerts have also two fields: start date & end date.

How to create a notification rule (email type) to let the specific user that the end day is approaching?

I read this similar thread (Knowledge Base Article Expiration Notification), but I wanted to ask if there was any way without event scripting...

Thanks,

Skender

1 ACCEPTED SOLUTION

Form the query on the table and filter and get the sample results.. Once done, copy the query and make use of it in a encoded query.


View solution in original post

18 REPLIES 18

Actually you don't even need to use this wiki article as there is a somewhat undocumented feature you can use instead.   Configure your related lists and you will find one called reminders.   Add that to your form and you can set a reminder for any date/time field on that table.   These records can also be added via script as well.


Hi Michael,


I do not see any such Related List in my custom table (except Attachments)...



Skender


Sorry mis-read your post.   The Reminder feature works for any table extended from task.   Since your table is not, unfortunately it doesn't appear.   It should on pm_project though.



Glad Kalai got you taken care of.


Ok Michael. No worry, I got it.


Anyway I didn't know that possibility in the related lists. It could be helpful for project tasks, maybe for future client's requisites...



Have a nice day,


Skender