Configure alerts in a list based on category

Question

Hi,

I have a list with couple of columns to get metadata (Country, City, Location) for the items. While creating one item, user selects different values from metadata columns and item is saved.

I want users to be able to configure alert based on category. For eg. one user wants alert only if item added belongs to country USA, City Seattle.

Please let me know how this can be done using OOB features of SharePoint 2010.

---

-Prashant

Answer 1

If personal views are allowed, you can have a user create a personal view with a filter based on categories (country, city) of their liking. Then, from the personal view, configure Alert Me. In the Send Alerts for these Changes, you will see an option: when someone changes an item in the following view (and select your view).
AK

Answer 2

You should create a workflow that sends an email. Make it fire on when an item changes and then check those two values with a condition statement.
Hope that helps,
SharePointNinja

Answer 3

I would recommend AK64 solution. Workflow will not help with dynamic filters as you described.

Hope this helps

Kind regards Stefan

 

---

http://www.n8d.at/blog
twitter: n8design
MCTS - SharePoint / WSS Configuration and Development

Answer 4

Hi,

Thanks for all your replies.

I already tried this personal view solution for alerts but the problem is user can type anything while creating a view. For eg. if user selects Area column then user has to type the name of the area. User will not get lookup kind of values in view.

And sharepoint designer workflow will not work in this case. As of now I am thinking to implement it using customization. The solution i am thinking is

Use infopath form as a subscription form, use cascaded lookup columns for area, country , city and location. An eventhandler on the list will check information related to the users subscription in infopath form library or a list based on criteria and send notification.

Please let me know if this will be a good approach for this implementation.

Thanks,

-Prashant

---

-Prashant