Creating the Timesheet List and Assigning the Timesheet Content Type in SharePoint

We offer private, customized training for 3 or more people at your site or online.

In my previous article, I created the Timesheet content type, which contains all of the columns that we will be using in our Timesheet InfoPath form. The InfoPath form requires a SharePoint repository to store each of the entries created in our Timesheet form. In this article, I will show you how to add the Timesheet content type to the Timesheet custom list. The Timesheet content type will be the source of columns for the list.

There are two methods of storing the timesheet data. The first method is to store the information in a standard SharePoint list. This method is the easiest, because the form is linked directly to the list as the data source and requires minimal work to save the form data. The second method uses a SharePoint form library to store the XML data file for each form. The XML file is stored as a document in the library, but requires additional steps to promote the form data values into columns in the form library. There are pros and cons to each approach.

In this example, I am going to use a SharePoint list to store the Timesheet form data in and use the Timesheet content type as our column source.

  1. Begin by clicking the Setting gear icon in the upper right hand corner to open the Settings menu.

    Open Settings Menu

  2. In the menu, choose Site Contents. This will take you to the page that contains all of your apps (List and Libraries).

    Choose Site Contents
  3. On the Site Contents page, click the Add an App icon to create a new list app.
    click the Add an App icon


  4. On the Site Content for Your Apps page, click Custom List, which should be listed in the Noteworthy group.
    Custom List
  5. On the Adding Custom List dialog, click Timesheets in the Name: box and click Create.

    Adding Custom List > Timesheets


  6. On the Site Contents page, click the new Timesheets app you just created.

    Click Timesheets

  7. Now it is time to add the Timesheets content type to our new Timesheets list. By adding a Content Type of a list (or library), the content type becomes the source of our columns in the list. If the Timesheets Content Type is updated with new columns, this list will automatically receive the new columns as well.

    Before you can add additional content types to a list, you must configure the list to allow management of content types. To do this, click the List tab in the ribbon, then choose List Settings.

    List Settings


  8. On the List Settings page, click the Advanced Settings link under the General Settings heading.

    Advanced List Settings

  9. The Advanced Settings page is where a number of custom configuration changes for the list can be made. For the Allow management of content types? option, select Yes.

    Management Settings
  10. Scroll to the bottom of the Advanced Settings page and click OK to save the changes. Back on the TimesheetsSettings page, you will see a new Content Types section appear. Notice there is already one (1) content type listed, which is Item.

    Timesheets Settings


  11. To add our Timesheet content type, click the Add from existing site content types link (directly below the Item content type).
    Add Content Type

  12. On the Settings Add Content Types page, select Custom Content Types from the Select site content types from: dropdown. The Timesheet content type will appear in the Available Site Content Types list.

    Make sure the Timesheet content type is selected in the Available Site Content Types From: list and click the Add> button. This action will move the Timesheet content type from the Available… list to the Content Types to Add: list. Click OK to save the change.

    Move List
  13. The Timesheet content type is listed in the Content Types list along with Item and the columns you created in the content type are shown in the Columns list directly below.
    Timesheet Content Type


  14. Since this list is only going to contain Timesheet entries, we want to configure the list so that Timesheet is the default and visible content type. To accomplish this, click the Change new button order and default content type link in the Content Types section, which is shown below:
    Change New Button Order

  15. With two content types, it is an easy change. On the Settings Change New Button Order page, simply uncheck the Visible checkbox for the Item content type and click OK.

    Settings > Change New Button Order

  16. You should now have a Timesheet list that uses the Timesheet content type as its source of columns and looks similar to the screenshot below:

    Timesheets

In the next article, I will walk you through how to create and publish the Timesheet InfoPath form.
Until next time, Happy SharePointing!


Author: Eric Stepek, one of Accelebrate’s SharePoint instructors

Next: Creating the Employee Timesheet Form in SharePoint

Previous: Creating a Content Type for the Timesheet InfoPath Form



In-Depth SharePoint Training

For in-depth SharePoint training, click here to view all of Accelebrate's SharePoint training courses for you and your staff.

Request Pricing 

Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan