First of all... NEWBIE alert! I can follow most menus, wizards etc. but if you’re going to suggest code you’ll need to tell me exactly where to stick it :-)
We’re using SharePoint 2007, deployed by a head office (sort of) who are very hands-off. We’re a team of 40-50, mainly nurses and admin staff with low-level IT skills. I’m probably low-to-medium with reasonable experience in Access and Excel, so as the best of a bad bunch I’ve been designated as the site owner and I have created several sub-sites with standard “shared documents”, some custom lists, etc. This is to give you a vague idea of my skills, such as they are!
We work across sites and hot-desk all over the place, so keeping track of each other is tricky. I have set every user up with their own individual SharePoint calendar to which everyone else has read access and each Friday everyone updates their calendar with details for the following week, e.g. Monday – site A, Tuesday – site B, etc. So that kind of works, but I’d like to go one better.
I’d like a simple view somewhere on the home site that would update automatically based on everyone’s calendar. So SharePoint would go “Today is 27th…here’s what everyone has entered for today”…and then tomorrow it would update automatically with entries for the 28th. Does this make sense?
I’m not overly concerned with how it looks. Some kind of table would be nice, or even just a standard list view. I’m visualising a filtered list where the filter is “= Date()” or “=Today” or however you say it in SharePoint. The question is, how do I get all the entries from the individual lists (i.e. calendars) to appear in my new list?
Grateful for any help or suggestions. Thank you.