Posts Tagged ‘Filter’

Date Range filtering with the new version of FilterPoint, PivotPoint and Planner.

Date:December 13th, 2011 Author: Tags: , , , ,
Category: Calculated Columns, Filter, FilterPoint Web Part, PivotPoint Web Part, SharePoint Planner, SharePoint webparts Comments:0 ;

FilterPoint has had the ability to send Date Filters but a common request has been Date Ranges – like showing everything this month, last year or between two arbitrary dates.

FilterPoint - Date Range Filtering

The good news is that we’ve added this in to FilterPoint as of version 1.2

The bad news is that this will only work with our other SharePoint products – Planner and PivotPoint – it won’t work with SharePoints built in List View web part (LVWP).

That’s disappointing!

Yes it is – it’s just a limitation of SharePoints filtering I am afraid, but all is not lost!

This page shows how you can do things like Month filtering using calculated columns and this blog article shows how you can setup “Current Month/Previous Month” views using nothing more than Calculated Columns and View filters.

Upgrading

As always you can upgrade without losing any settings by downloading and running the latest trial version and selecting “Upgrade” when prompted (don’t forget you need the a recent version of Planner (v2.6.9+) and PivotPoint (2.2.0+) to accept date range filters.

SharePoint FilterPoint New Version Release; now with personal defaults

Date:February 22nd, 2011 Author: Tags: , , ,
Category: Filter, FilterPoint Web Part, General Comments:0 ;

We’ve just released a new version (v1.1.3) of our FilterPoint web part for SharePoint. We have had plenty of user feedback over the past few weeks and this new version has some added features and functionality that we hope you will all find useful.

As you know, FilterPoint already gives you the ability to set default values globally, to help get users to the most relevant information quickly.

And now new functionality in v1.1.3 will help each user get to their own individual information more quickly too.

There are 2 ways FilterPoint does this.  First by re-loading the last used filter values when you revisit a page.  And secondly by looking for FilterPoints on different pages that filter on the same fields, and getting them to fetch records with the same values.

So how could this help you?

Well, let’s take the example of 2 national sales account managers.  Freda’s biggest client is Big Corp and Sophie’s most important customer is Enormous Inc.  They each want to know what is going on with their key accounts on a daily basis.

So Freda and Sophie both look at dashboards that show sales activity, financial account status, cases and help tickets etc.  Freda always filters to see the stuff on Big Corp and Sophie always filters to see what’s happening with Enormous Inc.

Because FilterPoint will now save filter values between visits to a page each account manager will see information on her main client account as soon as she opens a page – so long as that was the last thing she looked at when she last visited the page.

Even better, once one FilterPoint is set up to filter for “Client = Big Corp” by Sophie, all other FilterPoints on the site will also look for information on “Client = Big Corp” and display this for Sophie, so long as this field and value exist in the lists and web parts they have been applied to.

These two new features should be a real time saver for many users.

In addition, there are other new features in FilterPoint v1.1.3:

If you’re an existing customer or trial user you can download and upgrade to the latest version.

And if you haven’t yet tried FilterPoint why not download a 30 day free trial now?


FilterPoint Web Part – on sale now!

Date:January 27th, 2011 Author: Tags: , , , ,
Category: Filter, General Comments:0 ;

After many months of work we are delighted to announce that FilterPoint is now available to purchase.

Filtering is one of the things that any serious SharePoint user is going to need to do at some point. As you put more data into SharePoint lists become longer and you will need a quick and easy way to get to the items you are looking for.

When you create applications and dashboards, bringing together information from different data sources and displaying it in different ways with Web Parts adding filters will make your applications and dashboards dynamic – giving users the information they need, when they need it.

But when you start filtering you are going to quickly come across things that you wish you could do with SharePoint’s built in filters, but frustratingly just can’t.

So in the same way that we built Reminder to improve on the functionality of SharePoint Alerts, and Planner to improve on Gantt charts and calendars, we have built FilterPoint to give a little more power to your SharePoint filtering.

If you are working with SharePoint 2010 Foundation or WSS your filtering options are limited to static filtered views. Filtered views are great for getting at data sets that you want to see regularly – like “this month’s sales” for example. Set the view up once and it’s there whenever you need it.

But what if you have 100 clients and want to be able to look at “this client’s sales” for any of them? Setting up a filtered view for each client, and navigating to it is going to be quite a drag.

With FilterPoint your filter can be set up in seconds, allowing users to flip between the different data sets they need with just a couple of clicks.

With MOSS and 2010 Enterprise you get more filter power. But we still felt there were some things missing. So for example even with MOSS filters you can’t:

  • Set up several Filters within one filter web part
  • In 2007, send many filters to one filter consumer list or Web Part (e.g. filter on both customer and product).
  • Use different styles of filter, like Free Text, drop down lists or Radio Buttons
  • Clear filters with a single click.

So even though MOSS offers more filtering options, there are still some significant gaps and we believe that FilterPoint goes a long way towards filling these.

Of course FilterPoint isn’t the only 3rd party filtering web part on the market and you can see how we match up to the competition by taking a look at our comparison chart here.

When we were looking at the competition one thing we noticed was that some of the most useful filter Web Parts – the ones offering the most functionality – were incredibly complex to set up. You would need the patience of a saint and a PhD in SharePoint (if such a thing existed!) So we have worked very hard to keep the setup of FilterPoint quick and simple. Take a look at our short on-line demo here, and let us know whether we have succeeded.

We’ve also tried to keep the prices competitive. Our Starter Pack license comes in at $199 and a Single Server License is $595.

And of course, like all of our products FilterPoint comes with a 30 day free trial and a no quibble money back guarantee.

And for existing customers we are offering a 25% discount for purchases made by 31st March 2011.  Email sales@pentalogic.net for your discount code.

So why not give it a try today?

As FilterPoint is our new baby we are very keen to know what you think of it – so please let us have your comments and feedback.

Download free trial

FilterPoint Update

Date:November 30th, 2010 Author: Tags: , , , , ,
Category: Filter, General, SharePoint Development, SharePoint Ideas Comments:0 ;

We have spent a lot of time over the past month working on the beta version of FilterPoint. Our team of professional testers have been working hard to check for compatibility with all versions of SharePoint 2007 and 2010 and a wide range of browsers, as well as looking for bugs and challenging us on some aspects of the usability of the UI.

And we also owe a huge vote of thanks to our beta volunteers who have been testing out the product in the real world.  Our volunteers and not only uncovered some bugs, but also come up with suggestions for additional things that we could include in the first release.  Some of these we have already added and they include:

(more…)

SharePoint Archive Round-up

Date:June 17th, 2010 Author: Tags: , , ,
Category: General, SharePoint Ideas Comments:0 ;

As you’ve probably noticed we have had a few changes on our SharePoint blog in recent weeks.  We’ve been doing some work on making it a little more user friendly and a bit nicer to look at (hope we haven’t spoiled it with the photos!)

Whilst I was working on the blog I noticed that we have quite a few little gems hidden away in the archives. Old posts – things that were written maybe a couple of years ago, that those of you who are new to the blog might not be aware of, but might find useful.  The useful ones fall into a few categories – general SharePoint tricks, tips and ideas, and ideas and tips for users of our web parts.  So here they are, I hope you find them useful.

SharePoint tricks tips and ideas

Extend and customise SharePoint Task lists

Task Lists are one of the best loved and most used features of SharePoint and this post shows you how to better tailor them to meet your particular needs.

Advanced SharePoint View and Filter techniques

This article explores some of the uses of SharePoint Views and Filters.

Working Days, Weekdays and Holidays in SharePoint Calculated Columns

SharePoint Out of the box doesn’t automatically distinguish between working days and weekends but if you are setting things like job duration or due dates you may need to – this article shows you how.

The Truth about using [Today] in SharePoint Calculated Columns

This article explains why the often repeated trick for using [Today] in SharePoint calculated columns does not work, and suggests workarounds.

The … ehem… Truth about using [Today] in SharePoint Filters

This one looks at the differences between SharePoint 2003 and 2007 when using [Today] in filters.

Setting a default duration for new SharePoint Calender Events

So you might be a medical receptionist scheduling appointments for doctors, appointments are always 45 minutes long unless the doctor tells you differently, how much easier would it be to just have SharePoint create an end time 45 minutes after the start time automatically?

How To Use Filters in SharePoint to show items in the current Calendar Month

It’s easy to think of occasions when you might want to filter a SharePoint list to show items falling in the current calendar month: “sales this month” springs to mind, or “subscriptions due for renewal this month”. This post shows you have to achieve this using calculated columns.

SharePoint Reminder Webpart Ideas

SharePoint Reminder Webpart – Setting a variable Due In or Overdue By time

Lots of people use Reminder to send an alert when a message is due soon or overdue.  Usually its fine for the message to go out at a fixed time before or after the event, for all list items, but there are occasions where you might want to vary the times at which you send your alerts.  For example, sending alerts for overdue helpdesk items: for high priority items you might want to send an alert when an item is 1 hour overdue, whereas for low priority an alert for items 1 day overdue might be fine.  This article shows you how.

Customize SharePoint Reminder Emails with Merge Data

Whilst SharePoint’s out of the box alert emails come in a standard format, with Reminder its possible to customize the alert emails you send by merging data from your list items.

Tip – don’t send SharePoint email alerts for old items.

There are some situations where, when you are setting up a Reminder for the first time, you could end up sending out alerts for a lot of very old list items, this post shows you how to avoid doing that.

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

If you are using Reminder to drive simple workflow you may very well want to send an email when a task is completed – maybe when a holiday request form has been filled in for example.  This post shows you how.

SharePoint Planner Webpart Ideas

Tip – Showing multiple columns in SharePoint Planner Webpart

There may be times when you want to display timeline or category information from more than one list column in a gantt chart. For example in the chart below we have taken information from the “priority” and “title” columns of a list to populate the category labels.

5 things you never knew you couldn’t do with SharePoint Gantt Charts

Shows you a few of the things that aren’t possible with SharePoint OOTB gantt charts, but can be done with Planner.

Use SharePoint Filtered Views to Stop Sending Alerts to Yourself

Date:April 19th, 2010 Author: 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…)

How To Use Filters in SharePoint to show items in the current Calendar Month

Date:November 26th, 2009 Author: Tags: , , ,
Category: Calculated Columns, Filter, SharePoint Ideas Comments:106 ;

Its very easy using the Filter feature of SharePoint views to show only items completed in the last 30 days or items due in the next X days; for example :-

Completed >= [Today]-30

On the Advanced SharePoint View and Filter techniques post Ed asked how you could filter for the current calendar month rather than a rolling 30 day period (for example all tasks due this calendar month).

Like all great questions it seemed simple enough – something like only showing items where the Month and Year of the due date = the Month and Year of the current date.

(more…)