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?
That is great stuff…! Thank you Gopinath for providing this information. I will look into it as an option.
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
Hi Sherri,
http://office.microsoft.com/en-us/sharepoint-designer-help/workflow-conditions-in-sharepoint-designer-2010-a-quick-reference-guide-HA010376962.aspx and http://office.microsoft.com/en-us/sharepoint-designer-help/workflow-actions-in-sharepoint-designer-2010-a-quick-reference-guide-HA010376961.aspx should help. In the workflow actions guide find “Send an Email”.
I hope this helps
Thank you all for replying! I really appreciate your expert opinions.
I have created a workflow before but I’m not as experienced as I would like. Could you suggest material or keywords to google in order for me to find instruction on creating a workflow that will trigger an event upon a change to a custom list? I do not have any good documentation/reference material.
thank you
