We use our SharePoint Online environment to collaborate on all our projects with a subsite for each project. On the parent site we have general information about all our projects including a calendar that contains all projects key dates. What we need to be able to do is show this calendar on the individual project subsites but with the information filtered to only contain events relevant to the project.
I've been playing around with this challenge for a while and haven't found any solutions that will work. Below are the approaches I have tried.
1. Calendary Overlays - Using a separate calendar on the subsite and overlaying a view from the parent site calendar achieves the desired result. The problem with this approach is that it requires a lot of admin (creating the view on the parent site calendar, adding the overlay to each appearance of the subsite calendar etc.) that can't be automated. There are simply too many projects starting and finishing for us to keep on top of this. This approach also creates problems when a user creates an event on the subsite calendar as it does not update in the main calendar.
2. Page Viewer webpart - This webpart displays the calendar's individual page in an iframe. Functionality and layout is poor and the data can't be filtered without having to still create the individual views.
3. Workflows that copy items between calendars - this doesn't work between sites, both calendars would need to be on the same site.
4. Copying and pasting code between pages in SPD - If this solution worked it would provide all the functionality required as it would add the calendar from the parents site as an app/webpart to the subsite. The webpart is added but there's something wrong with the code that means the calendar is not displayed. Is there a way to fix this?
Thanks in advance,