Creating Site Columns and Custom Lists in SharePoint 2010
Recently a SharePoint student asked about creating columns for a list and then reusing them in another list or library. This can be solved in a couple of ways. Using the Browser in SharePoint 2010, you can either create these columns as list columns and save that list or library as a template and then use it to create a new list or library, or you can create them as site columns in which they will be available to any list on any site in the Site Collection. You can also create them as Managed MetaData columns so that they are available to any Web Application that subscribes to that Service Application even across Farms!
For this blog we'll create them as Site Columns.
We will create 2 'choice' columns; Flavor and Scoops as Site Columns at the top level site of our site collection. We will then use these columns in 2 lists.
When we are done, the advantages of creating each column once and then re using it should be apparent.
Starting at the Top Level Site of a Site Collection I choose Site Actions>Site Settings
Next I Click on Site columns under Galleries.
This takes me to the Gallery of all the Available Site Columns for this Site Collection. Although there are many available Site Columns, there isn't one for Flavor or Scoops so I'll create them here. I click the Create Link.
Here I fill in the Site Column form with the values as shown.
Other than the values indicated, I leave everything else with the defaults.
I'm then taken back to the Site Columns Gallery where I click Create again.
I fill out the form as shown.
I leave the default values other than what is shown and click O.K.
Verify the Existence of the new Site Columns by looking under the Custom Columns group.
Now I can use these for any list or library in this Site Collection.
I click on the Site Actions> More Options to Create a new custom list called Ice Cream Cones.
Since I have SilverLight installed, I get a cool Silverlight Control to pick my Template. I'm using custom so I click on Blank and Custom to filter the options.
Click on Blank & Custom to filter the options then choose Custom List. I'll fill in the Name with IceCreamCones then click Create.
Now I'll add my Site Columns to the List By clicking on List Settings in the Ribbon.
In the Columns Section I'll click Add from existing site columns.
I'll filter the choices by choosing Custom Columns from the Select site columns from: drop down list and then I'll click Add twice to add my Site columns.
After moving Flavor and Scoops to the Colunns to add side I click O.K.
I'll go ahead and leave add to default view checked.
Optionally, I'm going to change the name of the Title column to something meaningful in this context – Name, by clicking on the Title link in the Columns section.
I'm going to add a few items to this list by clicking on the iceCreamCones link in the quick launch bar.
I can always go into title description and icons in the list settings area to add spaces to the name of the list later.
I'll add a few items by clicking Add new item and filling out the new item form.
I add items by filling out the form. Here is the first one the Bigfoot – 3 Scoops of Chocolate!
When I'm done I click on Save.
As you can see, adding the Site Columns feels just like adding a regular list column to a user but it's much more flexible and will be used when creating content types.
Now I'll create a recipes list for our employees and use the site columns created earlier in this list as well. First I click Site Actions > More Options.
Again, I'll click Blank & Custom to filter the options and then choose Custom List and name it Recipes, then click Create.
I'll Click on the List Settings icon in the Ribbon.
I'm going to create a list column called, cone type which will be choice by clicking Create Column.
This creates a List Column whose scope is this list and any list created from this list if used as a template. The difference is that a Site Column is available to any list or library in the Site Collection.
I'll fill out the form as shown leaving the defaults for the rest of the values and click OK.
Now I'll add my Site Columns by clicking on Add from existing site columns.
I'll filter by Custom Columns in the Select site columns from: drop down list and then click Add to move Flavor and Scoops over to the Columns to add side and click OK.
I'm going to change the Title Column to ProductNumber by clicking on the Title link under Columns.
I fill out ProductNumber is the Column name text box and click OK.
I'm going to create a Name Column which will be a lookup to the iceCreamCones list by clicking on Create Column.
I fill out the form as shown.
I'll ignore the Enforce relationship behavior for this blog post.
I'll click on the Recipes link in the Quick Launch Bar in order to get to the All items page of the Recipes list so that I can add some items.
I'll click Add new item to add a new item.
That's it. We created 2 Site Columns, and then created 2 custom lists and added them to these lists. We can reuse these on any list or library in our Site Collection. This example is a great candidate to show the Enforce relationship behavior functionality available in SharePoint 2010 but we'll save that for another blog.
Creating Lists and Libraries in SharePoint
In this SharePoint training video, we’re going to cover creating Lists and Libraries. Wherever you create your List or Library, wherever you want to create it, you want to be there. You want to be in a particular Site that’s in a Site Collection. If I wanted to add a List or Library to this … Continue reading Creating Lists and Libraries in SharePoint
Using Navigation Controls in a Collaboration Site in SharePoint
In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint
Detailed Forensic Investigation of Malware Infections – April 21, 2015
How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015
Write a Comment
See what people are saying...
Share your thoughts...
Pingback: How to set Default Metadata Values in SharePoint 2010 | Interface Technical Training
It is Very Nice Articel.Its Good.Please Send to me this type of articels Easily understand and Easy Step by Steps. I didn't see like this.
Thanks,
Ram
Can you please please talk about the function of the Title column? Or can you point me in the direction of a thorough explanation of how to plan out a list and create it . The title column always messes me up. I never know what should go there or what it;s purpose is.
Thank you in advance.
Best explanation and detail that I have come across. Thank you!
It is very useful for me…
Thanks…