I have a form library and when a form gets uploaded it sends email with packet information. In the form it has a approve/disapproved drop-down. What I would like to do is send email to a person based on approved/disapproved , i.e. approved = email@example.com , disapproved = firstname.lastname@example.org. One thing I would like to happen is that it does not send the email to email@example.com until all approvers select "approved"
In SharePoint Designer, on item change, kick off a workflow, if approval status = approved email one person, else if approval status = rejected, email someone else
Add some custom columns to the form that are not displayed in any views in the library. Whenever an approver makes an action, update a value in one of those columns. Afterwards (each time a column is updated) check to see if all the other necessary columns have been updated.
If all the other necessary columns have not been updated then perform no action. If all the other columns are now complete then send the email. After sending the email update another column that indicates an e-mail has been sent. You will also need to check this "email sent" column each time the workflow meets the conditions to send the email. In this way only one e-mail will be sent.
I can't remember if this can all be done with variables... but it will work with columns.
|show 1 more comment|