How can I filter a calendar (ListViewWebPart) web part?

Question

I've entered a lookup field to a calendar list that corresponds with the values in a list of links. I would like to show only calendar entries on the web part that correspond with the selected link. How can I select only the entries that contain the value of the selected link in the lookup field?

Answer 1

You could use a filter web part:

http://office.microsoft.com/en-us/sharepoint-server-help/work-with-filter-web-parts-HA010033786.aspx

If the filters are not changing you could also create the specific views in the calendar to filter those values, and point the links to the URL of the views.

Answer 2

Filters cannot be associated with a calendar view. Since the calendar view of a list will not support web part connections.

Answer 3

I don't think there is a simple, out-of-the-box way to do this, however, there may be a workaround.

First, is the list of links that may be selected relatively static? If so, you could create a separate view for each link and your drop-down could control which view is displayed.

Alternatively, you could customize. You could create a calculated column that concatenates the title of your calendar event with a delimiter (such as ||) and the value of the lookup field. On the calendar view settings page in the "Calendar Columns" section you would change the "Title" fields to the calculated field you created.

Now if you look at your calendar you will see your events with the Title, the delimiter, and then the lookup field value. Next you would add some jquery to the page via a CEWP that would locate all the events on your page, split the string on the delimiter, check the lookup field value against the value of the web part selected value, and if necessary hide the event if it does not match.