​​​​​How to filter SharePoint calendar?

​​Apply to: SharePoint 2010, SharePoint 2013, Office 365

 
You can add many events in your SharePoint calendar. You can use one or more categories in your SharePoint calendar.
How about if you want to filter your SharePoint calendar based on your category.
You can filter other list on the fly by adding FilterField and FilterValue but you cannot do the same in SharePoint Calendar. Unless you create separate views in calendar you cannot filter it.
Following Service allows you to Filter calendar on the fly without creating different views.

​Click on the following link to see how Filter Calendar works. Look at the result below after you click the link:

http://www.aasoftech.com/Demo/SitePages/FilteredCalendar.aspx?FilterField1=room&FilterValue1=Room%20A1&FilterField2=Category&FilterValue2=Meeting
http://www.aasoftech.com/Demo/SitePages/FilteredCalendar.aspx?FilterField1=room&FilterValue1=Room%20A4&FilterField2=Category&FilterValue2=Birthday
http://www.aasoftech.com/Demo/SitePages/FilteredCalendar.aspx?FilterField1=room&FilterValue1=Room%20A3&FilterField2=Category&FilterValue2=Business​​​​​​​​​​​​​​​​
< September 2019 >
 Sun  Mon  Tue  Wed  Thu  Fri  Sat 
 1 
 2 
  <div Category='' Room='Room A1'>Weekly Meeting</div>
 3 
  <div Category='Business' Room='Room A2'>Status Meeting</div>
  <div Category='Meeting' Room='Room A2'>Department Meeting</div>
 4 
  <div Category='Business' Room='Room A3'>Marketing Status</div>
 5 
  <div Category='Birthday' Room='Room A4'>Birthday - Employee of the week</div>
 6 
  <div Category='Meeting' Room='Room A1'>Hr Meeting</div>
 7 
 8 
 9 
  <div Category='' Room='Room A1'>Weekly Meeting</div>
 10 
  <div Category='Business' Room='Room A2'>Status Meeting</div>
 11 
  <div Category='Business' Room='Room A3'>Marketing Status</div>
 12 
  <div Category='Birthday' Room='Room A4'>Birthday - Employee of the week</div>
 13 
  <div Category='Meeting' Room='Room A3'>Requirement Review</div>
 14 
 15 
 16 
  <div Category='' Room='Room A1'>Weekly Meeting</div>
 17 
  <div Category='Business' Room='Room A2'>Status Meeting</div>
 18 
  <div Category='Business' Room='Room A3'>Marketing Status</div>
 19 
  <div Category='Birthday' Room='Room A4'>Birthday - Employee of the week</div>
 20 
 21 
 22 
 23 
  <div Category='' Room='Room A1'>Weekly Meeting</div>
 24 
  <div Category='Business' Room='Room A2'>Status Meeting</div>
 25 
  <div Category='Business' Room='Room A3'>Marketing Status</div>
 26 
  <div Category='Birthday' Room='Room A4'>Birthday - Employee of the week</div>
 27 
 28 
 29 
 30 
  <div Category='' Room='Room A1'>Weekly Meeting</div>
 1 
  <div Category='Business' Room='Room A2'>Status Meeting</div>
  <div Category='Meeting' Room='Room A2'>Department Meeting</div>
 2 
  <div Category='Business' Room='Room A3'>Marketing Status</div>
 3 
  <div Category='Birthday' Room='Room A4'>Birthday - Employee of the week</div>
 4 
  <div Category='Meeting' Room='Room A1'>Hr Meeting</div>
 5 

​​

Do it in 20 minutes:
No installation! Simple instruction:

 
 
1- Use SPFilterCalendar template and create calendar using the template.
2- Make sure you don't delete the following Fields from the calendar.
Title
Category
Meeting Room
AllFields
3- Add data to your calendar
4- You can change Choices in Lookup Fields for Category and Meeting Room but don't change Field names.
5- Provide the following links at the bottom of your calendar page in your Content Editor Web Part.
​​
6- Use the following query string at the end of your URL to filter data.
FilterField1=room&FilterValue1=yourroom&FilterField2=Category&FilterValue2=yourcategory
Examples:​​
http://www.aasoftech.com/Demo/SitePages/FilteredCalendar.aspx?FilterField1=room&FilterValue1=Room%20A2&FilterField2=Category&FilterValue2=Business​

http://www.aasoftech.com/Demo/SitePages/FilteredCalendar.aspx?FilterField1=room&FilterValue1=Room%20A3&FilterField2=Category&FilterValue2=Business​​​​​​​​​​​​​​​​​​

 


 


​​