How can I send a SharePoint alert only when a particular column is changed?

Question

I need to trigger alert, if value of particular column (say marks<8, send mail to manager) changes.

What should I do?

Answer 1

You can implement an event handler on the list to do this : http://www.c-sharpcorner.com/UploadFile/Chandresh.P/EventHandler04292009070324AM/EventHandler.aspx

Answer 2

Some kinds of lists (e.g. tasks) allow to send alerts when someone changes an item that appears in a particular view. Read the article Use SharePoint Filtered Views to Stop Sending Alerts to Yourself to get all the details (appropriate section begins with Well you need to set up a filtered view).

If you list supports this feature, first create a view that shows only the items that satisfy your marks<8 condition and then configure an alert that uses this view.