SharePoint Create Calendar with a Custom Column 9

Hi All;

I just had this question on how to create a new calendar with a custom column that I thought would make a good post. I’ll document the process in SharePoint 2010, and note any differences if you are trying to do this in SharePoint 2007.

1) Let us create the calendar.

SharePoint 2010:
Site Actions -> More Options… -> List -> Calendar
Note: in SharePoint 2010 you have an extra option to create a ‘Group Calendar’. This you to roll other SharePoint 2010 calendars into one master calendar. This option is not available in SharePoint 2007.

SharePoint 2007:
Site Actions -> Create -> Tracking -> Calendar

So why is it a list? good question… Essentially calendars are just a lists with many ways to display the same set of information. That display can be a traditional wall calendar like seen below…
Wall Calendar View
or in a list as seen here…
List Calendar View
it is still the same information just presented in diferent ways. that presentation is what SharePoint calls ‘Views’.

2. Now we can add the custom column for our information.

SharePoint 2010:
Select Calendar Tools -> Calendar -> Create Column
Create Column
This will open a dialog box where you can create your own column, with the name you specify, and the options you want. I’ll create a new required column called ‘Market’ as a ‘choice’ type. Now as we see below whenever I create a new event it will look like this:
New Event
Next, if I modify it to my default ‘All Events’ view and add the ‘Market’ as the fifth column I can now see it like this….
New All Events
From there I can sort and filter this view to my heart’s content.

SharePoint 2007:
Settings -> Create Column
This will open a dialog box where you can create your own column, with the name you specify, and the options you want. I’ll create a new required column called ‘Market’ as a ‘choice’ type. Next, if I modify it to my default ‘All Events’ view and add the ‘Market’ as the fifth column I can now see it like this….
New 2007 Calendar View
From there I can sort and filter this view to my heart’s content.

–Javi

  • paxet

    Nice, but is it possible to remove any existing columns?

  • Javier Barrera

    Yes, you can remove some the existing columns. In practice though it would be better to create new custom columns how you need them and simply not show the existing columns. You never know when your calendar requirements will change.

  • Megan

    Is there any way to move around the columns?

  • shanthosh

    can you say how to do it programatically

  • Javier Barrera

    yes. remember that a calendar is still just a list in SharePoint. It is a bit out of scope for this post but look up ‘create sharepoint 2010 list pogrogramatically’ in google.

  • John

    I might be missing something here (sharepoint 2010 Ent – full control).
    I am adding new columns to the calendar list but nothing new is showing up on the newitem form. Just the default columns. The only place I see them is on the “all events” view.

  • Javier Barrera

    Make sure you have the ‘add to default view’ checked. If you need it to show up in the list view then you will need to make those changes list settings > views > (whichever event you want to change)

  • Prafull Sharma

    I have added a column of type ‘People and Group’. when is try to add a filter to view like GroupName is equal to [Me] it isn’t working right. but when I replace the name of the group by UserName the filter works fine. Any idea why this problem is occuring. 

  • milton

    still doesn’t work. pos

Switch to our mobile site