Skip Ribbon Commands
Skip to main content

Laura Rogers @WonderLaura

:

Top Link Bar

Quick Launch
Laura Rogers @WonderLaura > Posts > Alerts Based on Views
​Hi everyone,
My blog now has a new URL!
You can now find me at http://www.wonderlaura.com
February 11
Alerts Based on Views
by  John RossNo presence information  on 2/11/2009 9:09 AM
Category: Views

This is a "SharePoint Tip of the week" email that I sent out to our site administrators in November of 2007.  Thought I'd share it...

In SharePoint 2007, alerts can be set up based on filtered (specific) data, using views!

This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.).  The following example will include how this is done on a document library with custom fields.

Example Case

n  An example hospital has different floors on their hospital.  They have created a new field in the Patient Admissions list called “Floor”.  Users are given a drop-down box of options for what floor a patient is admitted to.  Users would like to know if they can set up Patient Admissions list alerts so that they are only notified when patients are admitted to THEIR floor.  SURE THEY CAN!

n  First, the appropriate VIEWS need to be created, one for each “floor”.  Create 4 new views for: 1 North, 1 South, 2 North, 2 South

n  The first view will have a filter of: Show the items when column Floor is equal to 1 North
Create the other 3 views with filtering for each of their appropriate floor names

Creating the Alerts.

n  On the Patient Admissions list, click <Actions> and choose <Alert Me>

n  In the Send alerts for these changes section, choose the very last option called “Someone changes an item that appears in the following view”

n  Then, in the drop-down box for that option, choose the name of the floor for which you’d like to receive alerts.

n  In summary, any data in any field of your list can be filtered into a View.  Alerts can be created based on any *filtered* view, even “Personal” views.

Oh, and another good way to use this feature would be on an Announcements list.  Each announcement would have a category, such as the department that the announcement is targeted to.  Create a view for each category.  This way, your users can set up their own alerts on the announcements list, and choose to only be alerted when a new one is added for their department.

Technorati Tags: ,
Permanent Link to Post | Email Post Link | Number of Comments 22 Comment(s)

Comments

retexas@tx.rr.com

How could you implement this using an infopath form with multiple checkboxes. I would like a check box to look at a sharepoint row ID  and the column named "Available" then set the conditional format to hide checkbox if checked out flag is set. (available)  Any thoughts?
Shane YoungNo presence information on 1/20/2010 2:26 PM

Laura

retexas, Are you using InfoPath 2007? Web based or not? You can create a new data connection in InrfoPath to receive data from the same library that you submit items to.  Off the top of my head, I think there's a checkbox when you're creating the connection, to only pull information about the current item.   Then you could the conditional format to compare to the field from the library.
Laura RogersNo presence information on 1/20/2010 11:06 PM

maryjo.bednar@alleghenycounty.us

Is there a way to send a summary of a view in total? I'm trying to figure out how to set up an alert for Late Work Orders. Some of the work orders might just be sitting there, not having anything change and wouldn't trigger a regular alert.
Shane YoungNo presence information on 1/25/2010 2:21 PM

rgoldade@mbbc.edu

Is it possible to have content approval enabled and a view filtering announcemtns by "approved" items by a "post date"? And still do the above method? I'm unable to get the view to show up in the dropdown menu. Any other ways to create an alert email that sends a daily summary of "today's" Post Date announcements and not the original submission, the edit, or the rejected announcements for that "Post Date" day?
Shane YoungNo presence information on 8/10/2010 2:54 AM

Brian Merrifield

Just remember if you are trying to filter on a status column, you'll need to enter a numeric value instead of the actual status.
Shane YoungNo presence information on 4/29/2011 9:12 AM

Laura

Maryjo, Nope, there isn't.  Rgoldade, what's the post date you're referring to?  The Created date field?  Not sure what you mean by "today's post date announcements"
Laura RogersNo presence information on 5/4/2011 5:54 PM

james

Hi Laura,  I have SP2010 and I have an update alert based on a view.  However, when a workflow updates a column which is not in the view, it still sends out an alert?  do you think this is by design?  Do you know of a way to prevent an update alert if the update was made by a workflow?  Thanks.  - james
Shane YoungNo presence information on 6/12/2011 9:40 PM

Laura

James, Yes, this is by design.  The alert is simply based on all of the items in the view, and doesn't have anything to do with any particular columns being in the view.  Basically, if an item falls within the range of whatever the filter is, you'll get alerts on it.  No, I don't know of a way to prevent it, you'd just have to not use alerts at all and only create a bunch of custom workflow emails.
Laura RogersNo presence information on 6/22/2011 1:33 PM

Len

Laura,  I have created a filtered view and then create the alert based on that view.  I receive the intial email notification that the alert has been created but I do not receive an email when an item within that view is modified?  As far as the alerts themselves go, if i configure an alert for when anything changes i do receive that alert.  Any assistance you can provide would be greatly appreciated.
Shane YoungNo presence information on 7/27/2011 9:53 PM

Laura

Len, I don't know, it's pretty straightforward.  Just try different alert settings, I guess.
Laura RogersNo presence information on 8/8/2011 5:22 PM

Roland

I have SP2010 but no matter what list or library I try to create an alert on, I don't seem to have the ability of basing it on a view.  I only ever have 4 options under the "Send Alerts for These Changes" area and none refer to views anywhere.  Do you think this is some kind of server config issue or is something else going on here?  Any thoughts would be much appreciated.
Shane YoungNo presence information on 8/17/2011 12:50 PM

Laura

Roland, Your list or library must have a filtered view for this to work.  Just create any filtered view and then you'll see it.
Laura RogersNo presence information on 8/19/2011 9:10 PM

Paul

I wonder if Len's experience is based on a document library. We have SP 2010 and when I base an alert on a view for a doc library it gives me the initial alert set up confirmation email, BUT * for existing documents that are in the view (e.g. documents that were in sharepoint prior to the view being set up) - if there are changes to these documents I get no email alerts * for new documents that are in the view - if there are changes to these documents I do get email alerts (Change type = All Changes) Any ideas what is going on here? Paul
Shane YoungNo presence information on 10/25/2011 8:47 PM

Laura

Awesome observation, Paul!  I have seen the same behavior.  Must be a bug.
Laura RogersNo presence information on 11/11/2011 7:26 PM

Theresa

I have several filtered calendar views, but like Len, when I create the alert, I do not have the option to select the view --
Shane YoungNo presence information on 12/12/2011 1:36 PM

Laura

Theresa, Try creating a view and don't use the "calendar" type of view.  Then see if that makes a difference.
Laura RogersNo presence information on 12/19/2011 10:17 AM

talha

Laura Please help me in twitter search webpart for sharepoint 2010.i am confused.i have this one but failed..  http://www.thesanitypoint.com/archive/2009/03/05/binary-free-sharepoint-twitter-search-web-part.aspx   Please help....
Shane YoungNo presence information on 1/12/2012 12:01 AM

David Crosswy

I am working within a Blog and we have  categories setup within the blog. I created views for each of these categories so that users could setup alerts to the specific categories. In this respect, the alerts act more like feeds to certain information (the blog has multiple contributors that focus on different topics/categories). We are very interested in promoting these alerts; however, we are finding that sending out instructions to set up a New Alert is not improving compliance. Do you know of a way to develop a one-click alert for a custom view? I think this would greatly improve sign-up.
 on 3/14/2012 6:29 PM

Laura

David,
That's a great idea, but I've never done that.  Maybe something with the alerts.asmx web service?  Not sure.
Oh, maybe you  can use the content query web part instead of alerts.  When you use this web part, there's a check box option to create an RSS feed from the results.  So the web parts could each be filtered by each category, which would allow a separate feed for each category.
lauraNo presence information on 3/14/2012 10:43 PM

David Crosswy

Thank you. I will try the content query web part and let you know if it works.
 on 3/15/2012 6:33 PM

Rob

Hi there, I am curious how the alerts are triggered. Does it occur because of a user action? Here's  the scenario:

A "list" is created for tasks in a project, in that list a view is created to show all tasks that are "overdue" based on a finish date. If I set up an alert to tell me when new items are added to that view, will the alerts trigger even though no one has physically touched a list item? The date field on the list item simply came within range of my filter.

Thanks!
 on 4/25/2012 6:00 PM

Reed Carr

I successfully created a filtered view on a SharePoint 2010 Task List (Filter:Due Date is equal to [Today]) and successfully created an alert based on that view. I then went in and based on the specific user requirement, changed the filter on my view called "Due In 2 Days" (Filter:Due Date is equal to [Today]+2). This new filter is valid and the view indeed returns all tasks where Due Date is two days from today.

This is where I was totally thrown off. When I then click to set an alert on the list and go to set the view to monitor for changes, my view (Due In Two Days) is not available on the drop down.

What gives!?
 on 8/1/2012 12:36 PM
​I have disabled any new comments on this, because my blog has moved to a new site.  Please go here: http://www.wonderlaura.com
RSS FeedFacebookYouTube
 

 Our Books for End Users