Hello….my department uses a custom list to update the status on several columns. We need an alert or email sent based on the value of a status and column to be sent to different people. I have tried creating a view on just the column value and setting the appropriate alert but this doesn’t work well. I get alerts for any change not just the specific value.
Does anyone know how this can be accomplished?
Hi Sherri,
You cannot put condition for sharepoint alerts. Alerts only works if new item created or any change in existing item but not on conditional basis.
You two ways you can achieve :
1. SharePoint Designer Workflow
2. Event Receiver
If you are not able to use designer workflow, you can go with Event Receiver.
You can create a C# Event Receiver, you can implement ItemCreated event and ItemUpdated event where you will check the column status value upon it you can trigger the email with specific format.
Creating a simple Event Receiver in SharePoint 2013
Create an Event Receiver for a Specific List Instance
Sending emails from event receiver
I hope this helps..!
Thanks..
Gopinath V
