2010 – Create Site Column Example
article we can explore the creation of Site Columns inside SharePoint user
provides a central, reusable column definition. A site column can be used
across sub sites or lists inside the site collection.
a Lookup Site Column
example we are creating a new Site Column of type Lookup. The site column is
needed to capture the supported state for courier services.
the following countries are supported:
As time goes
by more and more states are supported by the courier company. The site column
provides the advantage of making the change in only one place and all the
associated lists are reflected with the change.
Step 1: Create a site column
SharePoint site and select Site Actions > Site Settings > Site Columns.
In the appearing page use the Create button to create a new site column.
Step 2: Enter the Column Details
column details as shown below:
Click the OK
button to save the changes.
Step 3: Create a new sub site
Create a new
sub site using Site Actions > New Site. After creating the site, create a
new List inside it deriving from Custom List.
creating the list go to the List Settings screen and select the Add from
existing columns option in the Columns section.
Step 4: Add the new site column
appearing dialog select the Service State which should be listed.
Add button to add the column into list. Click the OK button to save the
changes. Going back to the list you can try adding a new item.
Column is ready with the values in the add dialog as shown below:
Step 5: Testing the new site column
concludes our creation of Site Column and using it across another sub site
Step 6: Adding New Value
there are around a dozen of lists using the above site column. Now the courier
service added support to the state Colorado. In this case do not need to
change all the lists. Instead modify only the Site Column.
Go to Main
Site > Site Actions > Site Settings > Site Columns and select our Site
Column for editing. Add the new value Colorado and save the changes.
Back to the
list try adding a new item and you should be able to see the new value there.
article we have explored the creation of site columns using SharePoint 2010 and
the convenience of changing it. In real world scenarios
Site Columns are good aid to maintain the consistency across sites.
Jean Paul is a Microsoft MVP and Architect with 12+ years of experience. He is very much passionate in programming and his core skills are SharePoint, ASP.NET & C#.
In the academic side he do hold a BS in Computer Science & MBA. In the certification side he holds MCPD & MCTS spanning from .Net Fundamentals to SQL Server.
Most of the free time he will be doing technical activities like researching solutions, writing articles, resolving forum problems etc. He believes quality & satisfaction goes hand in hand.
You can find some of his work over here. He blogs at http://jeanpaulva.com