Categories
Tech

Showing more detail in SharePoint Calendar

image

The SharePoint calendar is an ideal place to give people a quick overview of team events, but the overview can be a bit thin on detail for some people’s tastes. The calendar structure is pretty rigid, so we can’t just add columns to the view like we do in other SharePoint lists. We can, however, pick which column to display in the calendar view. Using calculated fields we will build a new event title to have our calendar events communicate extra information at a glance.

Here’s what we want: when looking at the calendar we’d like our site members to see the title of the calendar event AND the location of the event in parenthesis. The pictures below show what SharePoint gives us out of the box compared to what we’d like for our site members:

SharePoint gives us: image We Want: image

Here’s what we’ll do in brief:

  1. Create two calculated fields, one to be the month view title and one to be the sub heading for day and week views.
  2. Modify the view to show our new columns instead of the default columns.

Create new calculated field columns

imageIn our SharePoint calendar we’ll navigate over to the Calendar tab and click the "Create Column" ribbon button. We’ll call this column "Month View Title" and set the type to "Calculated". Now, let’s build up the formula. Remember, we want the end result to look like this:

Event Title (Location)

To create that string, our formula will look like this:

[Title] & " (" & [Location] & ")"

SharePoint’s calculated field will (among other things) combine, or "concatenate", strings. To concatenate strings we use the "&" (ampersand) symbol much the same way we use the "+" (plus) symbol for adding numbers. Building a string is as easy as double-click a column, type an ampersand, type some text in double quotes ("). We use the double quotes to make sure SharePoint knows we’re concatenating a string and not just another field.

For consistency with the month view, we also would like the location wrapped in parentheses for the day and week views. Let’s create another calculated column for this. Repeat the steps to create a column and call it “Day Week View Sub Heading”. The formula will look like this:

"(" & [Location] & ")"

Modify the calendar view

Now that we have the strings we want, we can change the calendar view to show our new calculated columns instead of the default, "out of the box" (OOB) event title.

imageIn your calendar, head back over to the Calendar tab again and this time click the "Modify View" button. In the Edit Calendar View settings we’ll change the "Calendar Columns" to show our new calculated fields. The title fields we’ll change are the "Month View Title", the "Week View Sub Heading" and the "Day View Sub Heading". Since we’re extra clever, we gave our calculated columns names which match up very nicely with these field titles. Click the OK button to save changes and we’re done.

Go crazy

The SharePoint calculated column feature gives a lot of flexibility and can be used without having to open SharePoint Designer or learn to write custom SharePoint solutions. Check out this article on MSDN to get your creative juices flowing.


Update: We’ve cross-posted this on the SharePoint for End Users blog.

Categories
Idle

Compact

Perhaps it’s a little redundant… but it’s certainly clear.

Categories
Tech

InfoWorld likes SharePoint 2010

image

On January 12th InfoWorld released their Technology Of The Year Awards list for 2011.

Best collaboration platform? SharePoint 2010.

"it’s clear that SharePoint 2010 is setting a new bar for what employees and users — and their IT organizations — will expect from a collaboration platform"


Makes me proud.

Categories
Idle

Microwave popcorn that’s just popcorn

popcorn

Think back to the last time you microwaved popcorn. Remember what the kitchen smelled like after you were done? Sure it tastes great, but take a look at the ingredients on the box… it may explain the smell. 🙂

So tonight when Paula and I were craving popcorn we decided to try out Squawkfox’s DIY microwave popcorn recipe (found via LifeHacker). Instead of partially-hydrogenated, artificially flavored popcorn food, we had popcorn. Yes, we ate unprocessed food and it was delicious.

The formula is pretty simple: toss a cup of popping corn into a brown paper lunch bag, fold the top down a couple times and nuke for 3 minutes. When done, season to taste and enjoy.

We found it to be simple and delicious, but have a couple of notes to add:
1. It took 4 minutes in our weak little microwave, not 3 (your mileage my vary, but don’t go too long, you may burn it).
2. One cup of pop corn kernels generated a lot of popcorn (at least 1.5 times what we normally get from a typical bag of microwave popcorn). We’re going to use a half cup next time.

All-in-all, we were super pleased. Paula’s review: "I’m certainly never buying another box of microwave popcorn again!"

I’m with Paula on this, without a doubt. I’m certain it’s better for us. It’s clearly less expensive. And the best part: our kitchen doesn’t smell nasty afterwards.