Being not the most technically ept developer (I'm learning as I go) I'm stuck with a question I've been asked to find a solution for in regards to Sharepoint 2010 and list data.
Situation: Each day we are adding 70+ items to a list. Each item needs to be individually reviewed and then 'assigned' to a 'Region' based on where the requester is located. What we want to do is to upload the 70+ jobs into a list, then edit the records to a 'Region' which in turn populates an email to the relevant area notifying them a new/changed item has been added to the list.
For the benefit of this question I was using three fields: AMER, APAC, EMEA
So far I have a basic workflow that checks to see if the 'Region' field is empty and then waits. Once we then change the region via edit item the workflow sends an email to the region in question to notify them new work has been added and then stops. I added the stop to prevent any more emails being sent when other fields for a given item is changed (I only want the email to send once the region field has been changed, not each time the list data is changed)
Adding any more workflow checks in for the other regions (APAC, EMEA) does not send the email I've setup. AMER is the only workflow that seems to work flawlessly.
My Question: Is it possible to :
a) Create a workflow that only picks up changes to the 'Region' field and then emails out accordingly
b) The workflow email contains a list of newly added/changed items (rather than doing it on a singular basis, it would email anything with the region APAC to the people in APAC)
If I'm unable to do any of the above, can someone help me to find a solution? (Preferabbly in lamen's terms so I can understand it)
As always thanks for any assistance guys!