ENTERPRISE

Sharepoint 2007: Add a Column to a List or Document Library

2/11/2011 9:00:26 AM
Problem : You want to create a new column and add it to an existing list or document library. For example, you might want to add a date column called Birthday for a contacts list or a choice or lookup column called Client to a document library so that the users can choose which client the document is about.

Solution : To add a column to a list or document library, select the Create Column option from the Settings menu in any view of the list or document library, as shown in Figure 1.
Figure 1. Open the Settings menu and choose the option to add a column to the list or library.

Tip

The Create Column option creates a new column in the list or library but does not let you select from the site columns that are already set up in the site


Choosing the Create Column option opens the page where you can define the type of column you want to add, as well as set the settings on that column (see Figure 2).

Figure 2. Creating a new column.

The first choice to make is the name of the column. Column names must be unique in the list (you cannot have two columns with the exact same name).

After choosing the name for the column, you must choose the type of the column, as shown in Figure 2. There are numerous types of columns, and developers may add to those types, so you might see more than the built-in types.

All column types require you to choose a name for the column. They also allow you to specify the description for the column and whether the column is required (making the column mandatory in the list—forcing the user to fill it in when creating or editing an item), and whether the column should be added to the default view of the list or library (see Figure 3). Other than the column type all options can be modified in the future. Changing the column type for a column is possible but is limited to certain column types.

Figure 3. Defining the settings for a new column.

However, each column type can offer different configuration options for that column; for example, a Single Line of Text column type has a Maximum Number of Characters setting, whereas Multiple Lines of Text column type has a Configuration option for how many lines it should allow.

Other  
  •  Sharepoint 2007: Create a New Document Library
  •  Sharepoint 2007: Open the Create Page for Lists and Libraries
  •  Exchange Server 2010 : Developments in High Availability (part 3) : Backup and restore
  •  Exchange Server 2010 : Developments in High Availability (part 2) : Configuring a Database Availability Group & Managing database copies
  •  Exchange Server 2010 : Developments in High Availability (part 1) : Exchange database replication & Database Availability Group and Continuous Replication
  •  High Availability in Exchange Server 2010 : Exchange Server database technologies
  •  SharePoint 2010 : Cataloging the Best Scripts to Automate SharePoint Administration
  •  SharePoint Administration with PowerShell (part 2)
  •  SharePoint Administration with PowerShell (part 1)
  •  Sharepoint 2007: Approve or Reject a File or List Item
  •  Exchange Server 2007 : Configure the Client Access Server - Enable POP3 and IMAP4
  •  Exchange Server 2007 : Configure the Client Access Server - Enable and Configure Outlook Anywhere
  •  Exchange Server 2007 : Configure the Client Access Server - Create and Apply ActiveSync Mailbox Policies
  •  SharePoint 2010 : Understanding Windows PowerShell Concepts (part 3)
  •  SharePoint 2010 : Understanding Windows PowerShell Concepts (part 2)
  •  SharePoint 2010 : Understanding Windows PowerShell Concepts (part 1)
  •  Managing and Administering SharePoint 2010 Infrastructure : Using Additional Administration Tools for SharePoint
  •  Managing Exchange Server 2010 : Archiving and compliancy (part 3) - Discovery
  •  Managing Exchange Server 2010 : Archiving and compliancy (part 2) - Messaging Records Management
  •  Managing Exchange Server 2010 : Archiving and compliancy (part 1) - Exchange 2010 Archiving
  •  
    Top 10
    Qooq - The First Culinary Tablet Made For The Kitchen
    HP Envy 23 TouchSmart - All-in-One Desktop PC
    Kobo Aura HD - An Excellent Ebook Reader
    Razer Edge Pro - It Combines Tablet, Laptop And Gaming PC In One
    Samsung Galaxy S4 Review (Part 8)
    Samsung Galaxy S4 Review (Part 7)
    Samsung Galaxy S4 Review (Part 6)
    Samsung Galaxy S4 Review (Part 5)
    Samsung Galaxy S4 Review (Part 4)
    Samsung Galaxy S4 Review (Part 3)
    Most View
    Canon EOS M – Is The Final Big Player?
    Windows 7 : Networking and HomeGroup Sharing - Sharing Between PCs (part 1) - HomeGroup Sharing
    KWA 150 SE – The Most Expensive Amplifier Of ModWright
    MSI FM2-A85XA-G65 Motherboard Review (Part 1)
    Nikon D600 Digital SLR Camera - Full-Framed Temptress
    Tips & Tricks Of November 2012 (Part 1)
    Popular GPS Apps Shootout (Part 1)
    Cambridge Audio Azur 751R - The Importance Of Being Earnest (Part 1)
    Google vs Apple vs Microsoft (Part 5)
    Roll Your Own Home Server (Part 1)