Custom List In SharePoint 2010

Nilkantjagtap
Posted by in SharePoint category on for Beginner level | Points: 250 | Views : 3834 red flag

In this article we will have look on Custom List of SharePoint 2010.

Introduction

Custom List is a blank list in which we add our own columns and views.

As we know SharePoint 2010 provides lots of build-in lists i.e. Contacts, Announcement, External List, Calendar, Tasks, Survey, Status List, Issue Tracking, Links, Project Tasks, Import Spreadsheet, Discussion Board. If the Build-in List mentioned above does not fulfill your requirement then we can go for Custom List.

Let’s have look on Custom List.

 1) Go to your Team site

 2)  Go to “Create page”. Create Page is a central piece of SharePoint sites from where we can add List, Library, Pages, Subsites into our current site.

   A) Go to Site Actions and then click on “More Options”, Create Page will open
    Or 
   B) Click on “Lists” link available on quick launch and then click on “Create” link.

 3) After Clicking on Create link here or More Options, “create” Page would open
  
   

   A) On Create page, in filter by section click on List.
   B) Select “Custom List” Template. 
   C) Type the name for your Custom List – Here I have typed “Trainer Info”.
   D) Click on Create Button.

 4) After Clicking on create button, custom list “Trainer Info” would create with one default column “Title”.

Note we cannot delete “Title” column however we can change the name of “Title” column as per our requirement.


Now I am going to change the name of “Title” column

  A) Click on “Trainer Info” list on quick launch.
  B) Click on list ribbon, and then click on List settings.

   C) On List setting page, go to columns section.
   D) Click on “Title” link and change the Column name From “Title” to “Trainer Name”.

   E) After writing new column Name, click on ok to save changes.

 5) After changing name of “Title” column, let’s add few other columns

   A) Click on “Trainer Info” list on quick launch.
   B) Click on List ribbon, and then click on “Create Column” button.

 

   C) On create column page, In Column name type “Qualification” and select “Single line of text” as type of data for  this column.

   D) On same Page go to “Additional column settings “section and for “Require that this column contains information” select Yes. So user must provide this information while submitting information to this Custom List.

   E) Finally click on Ok to save this information.

 6)  Lets add another column
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Create Column” button.
   C) On create column page, In Column Name type “Age” and select “Number” as type of data for this column.

   D) Click on ok to save changes.

 7)  Lets add another column
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Create Column” button.
   C) On create column page, In Column name type “Date of Birth” and select “Date and Time” as type of data for this column.

   

   D) Click on ok to save changes.

 8)  Lets add another column
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Create Column” button.
   C) On create column page, In Column name type “Gender” and select “Choice” as type of data for this column.

   

   D) On same Page go to “Additional column settings “section and for “Require that this column contains information” select Yes. 
   E) Type the choice value on separate line. Here I have written Male and Female.

   

   F) For “Display Choices using” select “Drop-Down Menu”, so the choice values would display in Drop Down Menu while submitting information to this list.

 9) Lets add another column

 Now I am going to add lookup column into our list. Lookup column is used to get data from another list on the same site.

 A lookup column establishes a relationship between list items in this list and related items in the target list.

 Note: Before adding Lookup column into “Trainer Info” list, add one another Custom List into your team site as below

   

   Hint: Create Custom List with name “Country”, Change the name of “Title” Column as “Country Name” and add some items into this list.

Now let’s add lookup columns into “Trainer Info” list

   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Create Column” button.
   C) On create column page, In Column name type “Country” and select “Lookup” as type of data for this column.
   
   

   D) On same Page go to “Additional column settings “section 
      I. For “Get information from:” , select Country  ( Country is name of custom list available on our site) 
      II. For “In this column:”, select Country Name ( Country Name is Column of Country list) 
   

   E) Finally Click on Ok to save changes.

 10) Lets add another column
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Create Column” button.
   C) On create column page, In Column name type “Marital Status” and select “Yes/NO” as type of data for this column.

   

   D)  Finally click on ok to save changes. 

 11) That’s it, now we see structure of our custom list with 7 Columns i.e. Trainer Name, Qualification, Age, Date of Birth, Gender, Country, Marital Status.

   

 12) Optional: Now if you want to change the display position of your columns 
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “Modify View” button.
   C) On Edit View page, Go to Columns Section and arrange the position of column as below or as per your requirement.

   

   D) Now you can see position of our columns has rearranged as per our specification.

   

 13) Optional: Now if you want to see your columns in same order as specified above while adding new item to this list i.e. New Item Form
   A) Click on “Trainer Info” list on quick launch, if you are not on “Trainer Info” list.
   B) Click on List ribbon, and then click on “List Settings” button.
   C) On “List Settings” page, Go to Columns Section and then click on “Column Ordering” link.

   

   D) On “Change Field Order” page change the order of your columns as below and click on ok.

   

   E) Now click on add new item into “Trainer Info” list, you will get column order like below

   

     Hope this would be useful for the readers! Thanks and do let me know your comments or feedback.

     Reference: http://office.microsoft.com/en-us/sharepoint-server-help/sharepoint-lists-iv-create-a-custom-list-RZ101874360.aspx

Page copy protected against web site content infringement by Copyscape

About the Author

Nilkantjagtap
Full Name: Nilkant Jagtap
Member Level: Bronze
Member Status: Member
Member Since: 3/19/2011 6:35:11 AM
Country: India

http://www.dotnetfunda.com
Jagtap Nilkant D. MCSD,MCPD 2.0,MCPD 3.5,MCPD 4.0,MCPD SharePoint,SQL Server , MCT. Working as Technical Trainer.

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)