PDA

View Full Version : Display multiple calendars for different locations but same database


Ubong
07-13-2009, 02:41 PM
This is the plan: Is this possible?
Display one calendar holding all company events( 1 sql database), a user can select a company location ( 3 locations) and display a calendar with events that are a subset of the main calendar but specific to the location

Brian
07-13-2009, 03:46 PM
You'll want to use categories to set the location for each event. Then use the Filter Plugin so users can filter the events. Or, you can use the showCat variable to create you own links or embed it in the code of your page.

There are lots of posts how to do this in the forums. If you get stuck, just let us know. :)

Ubong
07-14-2009, 01:28 AM
Brian Thanks. The filter plugin displays only the selections in the main category. How do I get the dropdown to display other categories ( locations) I have created?

Brian
07-14-2009, 12:30 PM
The provided filter is designed to be used with the main category. So, make your main category "Locations" and add each location to it. Then assign the correct location to the events to be filtered.

Ubong
07-14-2009, 03:26 PM
Brian thanks.. it works as you have said.. I have 3 locations and 5 type of events across all locations...is there some filter combination where user can chose location and event type?

Brian
07-14-2009, 03:31 PM
You could create you own filters using the showCat variable. But if you just want a ready-built solution for filtering multiple categories, you may want to contact our forum moderator ve9gra through the web site www.epctutorials.com.