Skip Ribbon Commands
Skip to main content

Laura Rogers @WonderLaura

:

Top Link Bar

Quick Launch
Laura Rogers @WonderLaura > Posts > Out of Box Timecard and Holiday Lists
​Hi everyone,
My blog now has a new URL!
You can now find me at http://www.wonderlaura.com
February 22
Out of Box Timecard and Holiday Lists
by  Laura RogersNo presence information  on 2/22/2011 12:55 PM
Category: Views

In SharePoint 2010, there’s a little-known built in feature.  There are list templates that can be used for time card tracking, with a holiday calendar that ties into the time card.

ch5[118]

Here’s how to get to it:

  1. On your SharePoint 2010 site, go to Site Settings, Site Features, and activate the “Group Work Lists” feature.
  2. Open your site in SharePoint Designer 2010.  Click the File Menu, click Add Item on the left, and click More Lists.
    ch5[119]
  3. Click the Time Card list, and click the Create button on the right.
    ch5[120]
  4. After creating the Time Card list, repeat steps 1 and 2 and create a Holidays list.
    ch5[121]
  5. Now go to your SharePoint site in the browser, and open the Time Card.  Pretty fancy!  There you’ll see what I’ve shown at the top of this post, a fully functioning time card system.  Try entering a few dates and times in it, and you’ll see that it automatically calculates the number of hours, etc.
  6. Go to your new Holidays list and enter a couple of holidays as non-working days.  Then when you go to your Time Card, you’ll see that it has put those days in yellow just like weekends.
  7. In your time card in the browser, click the Time Card tab in the ribbon.
    ch5[122]
  8. Click Time Card Settings.  There are several other items that can be defined here, such as when are working hours.  The Non work days view actually comes from the other (Holidays) list that you created.  If there is no Holidays list, this drop-down is blank.
    ch5[123]
  9. By default, Calculate details is set to No.  After you change it to Yes, you’ll be able to go in and tweak the times of each of the listed hours like morning and afternoon.  After it has been changed to Yes, and you go back to the main view of the list, there will be several more columns in the view.
  10. To get to the list settings in the browser, I clicked the My Time Card view, clicked Configure Views for this Location, and clicked “List Settings” in the breadcrumb trail at the top.

Pretty neat little discovery!  Have fun trying out the built in time card system!

 

Permanent Link to Post | Email Post Link | Number of Comments 22 Comment(s)

Comments

Dave Coleman

Thanks Laura great post we will implement this at Twynham rather than use a spreadsheet for holidays.  Thanks Again  Dave
Shane YoungNo presence information on 2/22/2011 1:16 PM

Dave Pritchard

Thanks Laura,  This is indeed a little hidden gem although I feel it will need some additional customisation before it meets my org's needs.  Just a quick question do you have to click save each time you enter something?  I am noticing that as I go between the start time to end time the data I enter disappears unless I click save before focusing the cursor on the next text box!
Shane YoungNo presence information on 2/23/2011 7:34 AM

Pritesh Gandhi

Simply Good
Shane YoungNo presence information on 3/24/2011 5:05 AM

Laura

Dave, I haven't seen values disappear like that in my environment, I was able to enter values in several fields before saving.
Laura RogersNo presence information on 4/21/2011 9:01 PM

Kim Frehe

Thanks Laura!  I found this somehow and couldn't remember how I found it!  I was looking everywhere in the browser and it was driving me crazy.  In response to Dave Pritchard's comment, my numbers disappeared unless I put the colon and minutes in the time fields. 
Shane YoungNo presence information on 6/28/2011 12:37 PM

Richie

This doesnt allow me to make any changes in Sharepoint foundation, did you try this on sharepoint foundation?
Shane YoungNo presence information on 9/27/2011 9:54 AM

Jon

Thanks, I would have never found this feature!  Any recommendations for creating a workflow for management approval at the end of each month?  
Shane YoungNo presence information on 10/5/2011 2:42 PM

Laura

Richie, No, I haven't tried that.   Jon, if you'd need to approve a big chunk of items all at once, that would be pretty complicated, and I don't know how. Most workflows only run on one item at a time.
Laura RogersNo presence information on 10/11/2011 11:25 AM

Ryan

Hi Laura - I've put a link to this page on our round-up of all your options for doing TimeSheets in SharePoint  http://blog.pentalogic.net/2011/11/sharepoint-timesheets-free-solutions/
Shane YoungNo presence information on 11/10/2011 8:33 AM

Carole

Laura,  I do not have time card or holidays in my options under more list settings. What would cause this?
Shane YoungNo presence information on 11/28/2011 4:27 PM

KenFury

After installing on SP2010Ent (14.0.6029.1000) I am getting a error.  Tracking down the correlation ID gives me "One or more field types are not installed properly. Go to the list settings page to delete these fields"  This is only with the mytcard.aspx; Disphol.aspx works just fine.   
Shane YoungNo presence information on 12/8/2011 9:52 AM

Ken

I am getting an error on the sharepoint logs.     "One or more field types are not installed properly. Go to the list settings page to delete these fields."  "System.Runtime.InteropServices.COMException: One or more field types are not installed properly. Go to the list settings page to delete these fields.     at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView)      at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView)"  The vacation page works fine, only the MyTcard is erroring like this.  
Shane YoungNo presence information on 12/9/2011 9:30 AM

Laura

Carole, All I can think of is that the feature needs to be activated. (Step 1).  Ken, I don't know, I've never gotten that error.  All I did was discover this feature, try it out and write a blog post about it.  I haven't used it since.
Laura RogersNo presence information on 12/17/2011 5:05 PM

Nikita Schetko

Hi laura ! I have the same problem, like  Carole. But i've activated Feature in Step 1. I can only create few lists from all:
Telephone call list, location and vocabulart list IME, and i can't create holiday list and time card list.
I simply see no new group lists from new list/library creating web-interface , but i can find it from SP designer. When i click "create" on them, nothing happens :( Have you any idea about that fact?
 on 2/16/2012 8:57 AM

Bob Nelson

This feature is exactly what I am looking for - if you create the list, each user who has permissions to get to the site gets their own view of the timecard which nicely stores whatever data they input.
What I need, however, is a way to provide a higher level view such that someone who administers the site collection can see ALL the timecards for all the users that have filled them out and then generate a report on it (i.e. user enters timecard data, workflow kicks off approval process, approver approves, then HR wants a report of all the approved timecards).  Has anybody done anything like this?
 on 3/2/2012 2:07 PM

Laura

Nikita,
No, I've never seen that happen.

Bob,
Can you just use the built in content approval functionality for that?  What do you mean by "report"?  Try SSRS?
lauraNo presence information on 3/14/2012 10:23 PM

Udion

Hi Laura,
I implemented it on my office 365 sharepoint server, thanks. how to i see all the time cards for all the employees? currently i can only see my own.
 on 3/15/2012 10:54 PM

Laura

You guys, if you want to see all time cards, you have to go into the list settings and scroll down to the bottom and create a new view from there.  That should let you see all of them.
lauraNo presence information on 4/12/2012 10:13 PM

Robert

Hi Laura,
Do you know where could I read more about this feature?
 on 4/23/2012 12:09 PM

Lee F

In reply to Udions comment, I tried to add the Time Card list but do not see it in the More List Templates Section ? How did you find it ?
Thanks.
 on 6/20/2012 9:17 PM

Max Dowaliby

Laura, Question: My environment disables the use of SP designer. Is there anothe way to create this list? maybe using web services?
 on 6/21/2012 10:16 AM

Laura

Robert,
No, I thought that was strange, which is why I blogged about it.

Lee,
All I can think is you didn't do step 1.  Other than that, I don't know.

Max,
No, that's strange, isn't it?  I don't know of any other way.
lauraNo presence information on 6/27/2012 10:12 PM
​I have disabled any new comments on this, because my blog has moved to a new site.  Please go here: http://www.wonderlaura.com
RSS FeedFacebookYouTube
 

 Our Books for End Users