Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Creating a custom list

From: SharePoint 2010 Essential Training

Video: Creating a custom list

The time will certainly come when you're going to look at the available lists, you're either going to use your Site Actions menu and click More Options, or one of the many ways you get to the same window. You'll look at the available lists, and you'll think, okay, this just isn't doing it for me. I need a list to keep track of my ice cream flavors, my vendor's machinery, my DVD titles. Those obviously don't exist in this fairly short predefined setup. However, what you do have is the ability to create a custom list.

Creating a custom list

The time will certainly come when you're going to look at the available lists, you're either going to use your Site Actions menu and click More Options, or one of the many ways you get to the same window. You'll look at the available lists, and you'll think, okay, this just isn't doing it for me. I need a list to keep track of my ice cream flavors, my vendor's machinery, my DVD titles. Those obviously don't exist in this fairly short predefined setup. However, what you do have is the ability to create a custom list.

Now, you'll see two options for this, Custom List and Custom List in Datasheet View. These are quite similar to each other, as we'll see in a moment. In fact, if you can filter down your list even further to the Blank & Custom, you'll basically see three choices. You can make a custom list in a different view called the Datasheet View, or you can import a spreadsheet. So, if you're storing this data already in an Excel spreadsheet, where the first columns are the titles of the fields that you're storing, you can import that in.

I'm going to go ahead and create a custom list. Let's say I am a corporate video producer and I'm going to create a list of DVD titles. We click Create. It makes me the list that already dumps me into the webpage. The list is actually created. Now, you might be thinking, well, but I didn't tell it what the list was. Well, the way that it really works is when you make a custom list, what SharePoint does is say "oh, I'm just going to make you a really simple list, and you can then change it if you want to." It's made the simplest list imaginable.

If I look at this, I have the ability to add a new item to this list. It says well, all you give me is a title. That's what this list represents. In fact, SharePoint is storing two more pieces of data under the hood. Whenever I add an entry, such as simple title, it's also going to store the fact that I created it, and that I was the person who last modified it. But right now, all we have is the ability to create a title. I want to store more information.

If I'm used to say creating databases in Access or SQLServer or FileMaker or Bento or any of the other things, I'm used to the idea of defining my own columns for data. That's what we do here as well. Two ways of getting to it. As you're beginning to see, there is always several different ways to get to the same place in SharePoint, but with the Ribbon selected, and I want to make sure I'm on the List section of the Ribbon. I'm not affecting just an individual item in the list. I am affecting the entire list itself.

I can either click Create Column, or I can also get to the columns through my List Settings on the right-hand side. I'm going to pick the simple and most direct one, Create Column. It's going to say "what's the column name?" Well, let's say that all our DVDs fall into a category. So, I want a way to store a category. Then it asks me want kind of data is this, what type of information, single line of text, multiple lines of text, a choice, a number, currency, a date and time. Well, let's say we've got a choice.

I'm going to select from three different options. When I select the radio button here that says Choice, what happens is the section further down changes, and says "well, tell me your choices." Well, let's say my corporate videos fall into Industrial, and Managerial, and all sorts of terrible, boring names. Human Resources and Best Practices. I have a few other options here. I can choose to display these choices using a drop-down menu, or radio buttons, or checkboxes.

I can allow people to type in their own choices here. I can say the default is always the first one, and then I'm going to click OK. There is a last little Column Validation, where you can put in some formulas. There is a little bit of help there. I'm not really going to get into that right now. I'm just going to click OK. Then now it says I've got a title, and I'm looking at my list here. It says Title and Category. I can go into the existing ones simply by clicking the link here. It says well, I'm showing this as a ttle and no category. Well, I want to edit it.

Luckily, I do have the Edit Item option here, where I can now select from my drop-down. Now, notice that even though I'd specified Industrial as the default category, SharePoint did not go back and enforce that on any list items I already had created. It won't do that. Those of you who might be used to working with databases, might have a bit more of a formalized idea about what would happen in those instances. I would caution you to not make too many equivalents between a SharePoint list and a database. It's not really the same thing.

SharePoint tends to err on the side of flexibility. Most databases err on the side of enforcing very strict rules, and SharePoint really doesn't. I'm going to create another column here, which will be let's say Date Released. That's going to be-- Date and Time is my only option there, but let's say I don't want Time. Well, that's okay, because with Date and Time selected, the options further down say w"ell, do you want Date Only or Date & Time?" Date Only is just fine. I don't even need a default value.

I'm going to click OK. Then I'll add one more column, which can be Price. That will be of type Currency. With that selected, we get a few more options here, such as a minimum and a maximum value. I can also choose to say this column contains information. There must be a value in it. I can do that on any column. There are options for different countries and so on. Let's just pick the United States, in this case, and click OK.

I can go and edit the existing one, either by clicking the link and then clicking the Edit button. I can check the little checkbox over here. Then move up to my items list and say Edit Item, or I can select from the little drop-down menu and say Edit Item. This is SharePoint. There is always multiple ways to do the same thing. Date Released, I get a nice date picker here, let's say the 14th of May, and price, let's say 99.99. Click Save. That will put the US currency on the front of it, and we have our data start to being filled out here.

If I wanted to do quite a lot of entry on this, one of the things I can do with this list, indeed with most lists, is from the List section of the Ribbon, I can click this option that says Datasheet View. This drops into a more of a kind of Access style, where I can start giving it titles by just very quickly typing in here. It's a quicker way to do mass entry, but it's not so friendly with kind of enforcing a data checking or error messages, that kind of thing.

So, it doesn't tend to be as friendly. But if you have a lot of things to enter at the same time, you'll find Datasheet View is the quicker way to do it. I can just click back into Standard View. Now, you might find for a couple of reasons that you don't get Datasheet View appearing. There can be different reasons why. One might be that you have an out- of-date copy of Office installed. One might be that you have Office which is too up-to-date. As of the recording of this movie, if you have the 64-bit version of Office, SharePoint doesn't want to show the Datasheet View by default, which is little bit annoying, because it's using an ActiveX control under the hood.

And all that geekery you don't have to worry about too much, if you can click the Datasheet View button and just see it. There are very few things in SharePoint 2010 that really rely on some of these weird underlying ActiveX controls, but unfortunately, this is one of them. This Datasheet View is what we'd see if, when I go back to my Lists, and say I want to make a new list. Again, I'm going to filter this right back down, not just filter by list, but filter my Blank & Custom lists. If I was to say I want to make a custom list in Datasheet View, that's essentially what we just saw by shifting our list into Datasheet View.

As it says over here, a blank list is displayed as a spreadsheet in order to allow easy data entry. You still add your own columns the way we just added them with the same options that we just had, no different. Once we start to get a bit more into this, we're also going to start working with views. So, we can start to take a lot of data that we're likely to have and present it in ways that are more useful for us. That's how we create a custom list in SharePoint.

Show transcript

This video is part of

Image for SharePoint 2010 Essential Training
SharePoint 2010 Essential Training

70 video lessons · 50039 viewers

Simon Allardice
Author

 
Expand all | Collapse all
  1. 1m 16s
    1. Welcome
      1m 16s
  2. 16m 34s
    1. What is SharePoint?
      8m 9s
    2. SharePoint roles
      2m 5s
    3. Accessing SharePoint
      4m 48s
    4. The SharePoint product line
      1m 32s
  3. 44m 55s
    1. What is a team site?
      2m 43s
    2. Navigating a team site
      9m 41s
    3. Using team site lists and libraries
      11m 38s
    4. Editing the home page
      9m 31s
    5. Adding a Web Part
      6m 19s
    6. Deleting a Web Part
      5m 3s
  4. 10m 53s
    1. What is a Document Workspace?
      4m 2s
    2. Creating a Document Workspace
      4m 3s
    3. Deleting a Document Workspace
      2m 48s
  5. 6m 3s
    1. What is a Meeting Workspace?
      2m 7s
    2. Creating a Meeting Workspace
      2m 40s
    3. Deleting a Meeting Workspace
      1m 16s
  6. 36m 3s
    1. Exploring the available lists
      5m 30s
    2. Creating a custom list
      8m 44s
    3. Creating a custom view
      6m 43s
    4. Working with libraries
      6m 18s
    5. Using versioning and Check In/Check Out
      8m 48s
  7. 45m 55s
    1. SharePoint and Word
      6m 6s
    2. SharePoint and Outlook
      7m 38s
    3. SharePoint and Excel
      3m 54s
    4. SharePoint and Access
      2m 58s
    5. SharePoint and InfoPath
      11m 42s
    6. SharePoint and PowerPoint
      3m 46s
    7. SharePoint and Visio
      6m 20s
    8. Using SharePoint Workspace
      3m 31s
  8. 32m 8s
    1. What is a site collection?
      3m 56s
    2. Creating a site collection
      6m 35s
    3. Creating a new site
      6m 29s
    4. Customizing a site
      7m 47s
    5. Creating a site template
      7m 21s
  9. 13m 53s
    1. Understanding permissions
      3m 33s
    2. Adding a user to a site
      5m 14s
    3. Deleting a user from a site
      1m 39s
    4. Creating a new security group
      3m 27s
  10. 31m 54s
    1. Using out-of-the-box workflows
      11m 1s
    2. Creating your own workflows with SharePoint Designer
      15m 20s
    3. Creating your own workflows with Visio
      5m 33s
  11. 40m 36s
    1. Using site templates
      5m 49s
    2. Using the web content management features
      10m 40s
    3. Using master pages
      3m 37s
    4. Creating an Enterprise Wiki
      7m 14s
    5. Sharing an Access database with Access Services
      7m 19s
    6. Working with rich media
      5m 57s
  12. 53m 9s
    1. Managing documents and records
      3m 0s
    2. What are content types?
      4m 22s
    3. Creating a content type
      11m 30s
    4. What are document sets?
      2m 12s
    5. Creating document sets
      7m 49s
    6. Creating a Document Center
      4m 37s
    7. Creating a Record Center
      8m 25s
    8. Defining information management policy
      11m 14s
  13. 15m 42s
    1. Using personal and social features
      7m 28s
    2. Creating a SharePoint blog
      2m 48s
    3. Personalizing SharePoint with tags and notes
      5m 26s
  14. 21m 22s
    1. Searching in SharePoint
      4m 26s
    2. Creating a Search Center
      8m 4s
    3. Customizing Search with keywords
      3m 30s
    4. Customizing Search with scopes
      5m 22s
  15. 47m 18s
    1. Using Excel Services
      10m 12s
    2. Creating a Business Intelligence Center
      3m 5s
    3. Using PerformancePoint Services
      12m 3s
    4. Using status indicators
      8m 10s
    5. Using the Chart Web Parts
      6m 33s
    6. Using Business Connectivity Services (BCS)
      7m 15s
  16. 1m 3s
    1. Goodbye
      1m 3s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed SharePoint 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.