Need to trigger NOTIFICATION on record update

[_Gaurav]

Hi Everyone,

I got a requirement in which I need to trigger a single email template with different values whenever there is any change made on any table in the instance.

In Detail:

1. For this, I have created an email template with different fields like - Number, Assigned to, Assignment Group and Other.

2. Whenever I make an update on any table (table can be incident, problem, change, call ....) this particular notification should be sent from the instance with table values. For ex: If I made any changes on "Incident" this particular notification should contain Incident filed values and If I made any changes on "Change" this particular notification should contain Change field value and so on.
Any help on this would be appreciated.

Thanks.

[_Gaurav]

Hi David,

Yes, agree with you on this. But what if the table is not extended by TASK table? The table can be a custom table as well.

[Dubz]

You could generate the notification from an event and populate the content with a mail script using generic terms but it might get complicated. 

I think there is a point at which the additional complexity outweighs the administrative effort of having multiple notifications, it's up to you to decide where that point is 🙂

[Brian Bouchard]

Agree with David. I would also suggest if you have tables that are not extended from task, but include things like Assignment information that you want in your standard notification, you might consider whether or not those tables should extend from task.  There would be some work in making those modifications, but it could save you a lot of effort in maintenance in other areas down the road if you find yourself writing code around those tables to emulate task-extended table functionality.