Posts Tagged ‘filters’

SharePoint Reminder Webpart – version 1.7.8 now available

Date:June 14th, 2010 Author:Clare Tags: , , ,
Category: General, SharePoint Reminder, SharePoint webparts Comments:0 ;

How annoying is it when you get reminded about something you have already done?  A little email saying:

“Can you please submit your expenses claim form by 12.00 noon today”

is just sooo annoying when actually you have been a good girl and done your expenses yesterday.

We get lots of support calls from SharePoint Reminder webpart users who have annoyed their team members in just this way – by sending our Reminder emails for tasks that have already been completed.

This is easy enough to do.  Reminder will look at the whole of a list unless you tell it to do something else.  So if you ask Reminder to send out an email for everyone who is tasked to complete their expenses claim form by 12.00 today that is exactly what it will do, regardless of whether the status of that task is “Active” or “Completed”.

(more…)

How To setup a SharePoint view filter to compare 2 list fields

Date:June 1st, 2010 Author:Ryan Tags: ,
Category: Filter, SharePoint Ideas Comments:0 ;

There are many instances where you might want to view a set of SharePoint list records which have been filtered on a comparison between values in 2 columns.  You might want to view a list of all sales reps who have failed to hit their targets: Actual SalesCredit Limit, or employees who have not used their full vacation entitlement: Vacation Entitlement>Days taken.

A customer recently contacted me with just this type of question :-

They use a SharePoint list to keep track of orders waiting to be manufactured and delivered – so amongst other fields they have Scheduled Delivery Date (which they have promised to a customer) and the Estimated Delivery Date which is kept up to date with the latest estimate. Most of the time the two agree but sometimes for various reasons the delivery date slips.

They have been using Reminder to send out automated emails for upcoming orders and ones that had just been missed but they wanted to setup a view that would show only orders where the Estimated delivery date was later than the date they had told the customer. Account managers could then use this list to keep customers up to date – “There is a delay on that order we have scheduled for you for next month, we estimate it will be ready on the 17th”

Sounded pretty simple to me and I confidently told them how they could do it (more…)

Use SharePoint Filtered Views to Stop Sending Alerts to Yourself

Date:April 19th, 2010 Author:Clare Tags: , , , ,
Category: Filter, General, SharePoint Alert, SharePoint Ideas Comments:0 ;

How annoying is it when you have just created or amended an item in SharePoint, and you immediately get an Alert email about it?

You know the kind of situation: you might be working in a team list, you have the list set up to alert you when an item assigned to you is added or amended, so as soon as you add or amend an item yourself an alert email pings through to your inbox. Completely unnecessary inbox clutter.

So, lets switch off those annoying “alerts to myself” – has to be an easy one click operation, right?

(more…)

Tip – Sending an SharePoint email Alert when a Task is completed

Date:October 16th, 2009 Author:Ryan Tags: , , , ,
Category: Filter, SharePoint Alert, SharePoint Reminder, SharePoint webparts Comments:0 ;

Victor from New York asked

Is there a way to configure a Reminder webpart to send an email when task item status in the task list is set to “completed”?

Sure there is!

In this case the trick is to use a SharePoint Views to filter out the tasks you are interested in.

(more…)

Advanced SharePoint View and Filter techniques

Date:October 26th, 2008 Author:Ryan Tags: , , ,
Category: Filter, SharePoint Ideas Comments:60 ;

Introduction

We discussed in a previous article how to customise SharePoint’s built in Task List and briefly looked at the power of Views with Filters. In this article we will build upon that by demonstrating some advanced use of Filters.

This article assumes that you are already familiar with Views and Filters – if not please review the previous article.

(more…)