We are currently trying to use a Custom List in our Team Site in SP2010 to manage our customers requests.
The idea is creating a set of rules to alert the relevant contact as follows;
1. When the request is submitted by the customer (external SharePoint user with access to the site fills in a request form) a first alert should be received by the Business Owner/Approver.
2. The Business Owner/Approver revises the request and validates the information and from a drop down list sets Approved or Not Approved status. If the selected option is Approved then a second alert should be triggered and sent to the Administrator.
I feel comfortable creating the first alert so a particular contact gets an email every time a new item is added to the Custom List. However, I don't know how to create the second alert to the Administrator when the Business Owner has selected Approved in the corresponding Drop Down section.
Could you please help? Thanks :)