Create a Virtual Time Card System

May 14, 2008 at 2:28 pm Leave a comment

Disclaimer: I found this tip on the web in a forum or site – but I can’t remember/locate the original source. If anyone knows the original source, please let me know.

I haven’t attempted this yet, and I would probably add some more detail to the instructions – but I want to get the basic idea up on the blog so I don’t lose the piece of paper I scribbled it on.

The Basic Scenario

The user clicks a button to “punch in” when the start work. The button creates a new item in a list and the system records the UserName, Time, Date, Department and TimeIn.

At the end of the workday, the user clicks the “punch out” button. The button creates a new item in a different list and that launches a workflow that edits the original item and recrds the UserName, Time, Date, Department and TimeOut. The workflow then populates a rich text field with the contents of both items.

At the end of the week, compile the contents of all of the records for all of the days of the week into one rich text field for the manager.

My Updates

Can the punch in process not be automated? When the user opens the Intranet Home page – you can grab the user logon credentials from server variables and then create the item automatically?

Instead of a rich text field with all of the records dumped into it, a multiple item dataview which is filtered by a drop-down (select username) would be much more organised.

Add an approval process and allow the manager to email the approved timesheets to the HR department – or send unapproved timesheets back to the original users to correct any mistakes. 

 

Advertisements

Entry filed under: Web Application. Tags: , .

Design Tip 4: Turn Any Field in a Dataview into a Hyperlink Logging Workflows for Troubleshooting

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed



%d bloggers like this: