{"id":807,"date":"2011-01-26T12:37:48","date_gmt":"2011-01-26T20:37:48","guid":{"rendered":"http:\/\/www.little.org\/blog\/2011\/01\/26\/getting-more-detail-in-sharepoint-calendar\/"},"modified":"2011-01-26T12:37:48","modified_gmt":"2011-01-26T20:37:48","slug":"getting-more-detail-in-sharepoint-calendar","status":"publish","type":"post","link":"https:\/\/www.little.org\/blog\/2011\/01\/26\/getting-more-detail-in-sharepoint-calendar\/","title":{"rendered":"Showing more detail in SharePoint Calendar"},"content":{"rendered":"

\"image\"<\/p>\n

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\u2019s tastes. The calendar structure is pretty rigid, so we can\u2019t 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.<\/p>\n

Here\u2019s what we want: when looking at the calendar we\u2019d 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\u2019d like for our site members:<\/p>\n

SharePoint gives us:<\/em> \"image\" We Want:<\/em> \"image\"<\/p>\n

Here\u2019s what we\u2019ll do in brief:<\/p>\n

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

    Create new calculated field columns<\/h2>\n

    \"image\"In our SharePoint calendar we’ll navigate over to the Calendar tab and click the "Create Column" ribbon button. We\u2019ll call this column "Month View Title" and set the type to "Calculated". Now, let\u2019s build up the formula. Remember, we want the end result to look like this:<\/p>\n

    Event Title (Location)<\/p>\n

    To create that string, our formula will look like this:<\/p>\n

    [Title] & " (" & [Location] & ")"<\/p>\n

    SharePoint\u2019s 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.<\/p>\n

    For consistency with the month view, we also would like the location wrapped in parentheses for the day and week views. Let\u2019s create another calculated column for this. Repeat the steps to create a column and call it \u201cDay Week View Sub Heading\u201d. The formula will look like this:<\/p>\n

    "(" & [Location] & ")"<\/p>\n

    Modify the calendar view<\/h2>\n

    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.<\/p>\n

    \"image\"In 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.<\/p>\n

    Go crazy<\/h2>\n

    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<\/a> to get your creative juices flowing.<\/p>\n

    \n

    Update: We’ve cross-posted this on the SharePoint for End Users blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    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\u2019s tastes. The calendar structure is pretty rigid, so we can\u2019t just add columns to the view like we do in other SharePoint lists. We can, however, […]<\/p>\n","protected":false},"author":2,"featured_media":806,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[116,124],"class_list":["post-807","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-techsharepoint","tag-techtips"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/posts\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/comments?post=807"}],"version-history":[{"count":0,"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/posts\/807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.little.org\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/categories?post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.little.org\/blog\/wp-json\/wp\/v2\/tags?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}