Creating Custom Site Columns in Microsoft Office Sharepoint Server 2007

Posted on 7/6/2006 @ 10:41 PM in #SharePoint by | Feedback | 6705 views

In this post I will talk about a step by step approach of setting up custom site columns inside Microsoft Office SharePoint Server 2007.

Let us say, I am a car collector. I wanted to create a site column to represent the brand of the car (Toyota, Honda etc.). I'd like to be able to maintain the brands as a separate list. So let us go ahead and setup a new group called "Cars", and a new column in there called "Make".

Start by clicking on Site Actions -> Create

When in there, click on "Custom List" under "Custom Lists".

Go ahead and create a list called "Car Brands". By default it will give you 3 columns - "Title", "Created By", and "Modified By".

That is good enough for now, go ahead and fill in some data as shown below.

Great. Now click on Site Actions once again, and choose Site Settings as shown below.

In there, choose "Site Columns" under "Galleries".

Click on the "Create" button in the toolbar, and type in "Make" as the Column Name. Choose "Type of Information" as "Look up (information already on this site", and under "Get Information from" choose Car Brands and Title. Also, put this new column under a new group called "Cars".

Hit OK. That's it !! Your new site column is setup and ready to use. It should look like as below -

The next step is to obviously use this new site column that you just created (next blogpost).

Sound off but keep it civil:

Older comments..

On 2/22/2007 11:00:46 PM Reny said ..
Ok adding a custom column is fine, but please tell me how it is possible (if possible) to fill this custom column with a value through the Sharepoint API's or any event based process.

On 2/23/2007 11:13:57 AM Sahil Malik said ..
Reny - just tap into an event receiver, google for "Creating a Rigged Survey" for more info.

On 3/6/2007 12:55:34 PM Joe said ..
Any idea how to make that key column be something other than text? The custom list seems to force your key column to be text.

On 3/6/2007 1:27:28 PM Sahil Malik said ..
Joe - you gotta drop to CAML for that. I know, I was shocked too, but this is the best I know. If you find a better way, please do illuminate us :).


On 7/24/2007 7:46:42 AM Vasu said ..
This is not working with sites across a site collection but within the same serve

On 6/4/2008 8:52:37 AM sonu said ..
nice well coded