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

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.

 

Contact Us:

Accelebrate’s training classes are available for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us.

Contact Us Train For Us

Toll-free in US/Canada:
877 849 1850
International:
+1 678 648 3113

Toll-free in US/Canada:
866 566 1228
International:
+1 404 420 2491

925B Peachtree Street, NE
PMB 378
Atlanta, GA 30309-3918
USA

Subscribe to our Newsletter:

Never miss the latest news and information from Accelebrate:

Microsoft Gold Partner

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

Alabama

Huntsville

Montgomery

Birmingham

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

San Francisco

Oakland

San Jose

Orange County

Los Angeles

Sacramento

San Diego

Colorado

Denver

Boulder

Colorado Springs

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Miami

Jacksonville

Orlando

Saint Petersburg

Tampa

Georgia

Atlanta

Augusta

Savannah

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Ceder Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

Baton Rouge

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Hagerstown

Frederick

Massachusetts

Springfield

Boston

Cambridge

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Saint Paul

Minneapolis

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Reno

Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains

New York City

North Carolina

Charlotte

Durham

Raleigh

Ohio

Canton

Akron

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Tulsa

Oklahoma City

Oregon

Portland

Pennsylvania

Pittsburgh

Philadelphia

Rhode Island

Providence

South Carolina

Columbia

Charleston

Spartanburg

Greenville

Tennessee

Memphis

Nashville

Knoxville

Texas

Dallas

El Paso

Houston

San Antonio

Austin

Utah

Salt Lake City

Virginia

Richmond

Alexandria

Arlington

Washington

Tacoma

Seattle

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Edmonton

Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

© 2013-2019 Accelebrate, Inc. All Rights Reserved. All trademarks are owned by their respective owners.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.