timesheet on intranet

[rufc]

I`ve been asked to look into having timesheets on our intranet. Basically people need to log in with a username and password then goto a timesheet.

The timesheet needs to contain
Date - Site (drop down) - Job (drop down) - Description (free text) - Time Taken (free text) fields

Then at the end of every week/month, a database with all the details can be drawn up to see who did what on what site and what job, how long it took etc.

Any ideas guys?

 

[Empeethree]

we use a product called timekeeper by deltek. with the latest version you can set it up that way. it is on the pricey side, and sometimes is problimatic but it does do what you are asking.


rob

 

[Bentley22]

Not too complicated, so an Access database setup would be plenty for you. Unless we're dealing with 100,000+ employees!

Q: Date field, will this be static (as in todays date) or can they enter it in? I would suggest static, then you don't have to worry about them entering an incorrect date format.

I think just a small ASP application would fit all your needs.

I would build the database first, and if I get your requirements correctly, 4 tables ought to do you.

Table 1: User Name/Password
Table 2: Sites
Table 3: Jobs
Table 4: Timesheet data, your combination table.

If anyone has a better idea, I'd like to hear it too! "The surest sign that intelligent life exists elsewhere in the universe is that it has never tried to contact us"
Bill Watterson, Calvin & Hobbes

 

[rufc]

Thanks for the quick responses....

It`s only for about 50 employees and the company at present use a very old excel spreadsheet and manually print each one out and use a highlighter pen, so they aren`t going to buy a system unfortunately.

Bentley is spot on with what I need, but I only know html and haven`t built any sites in asp before. As for the date, I suppose they could select the week beginning date which brings up say Monday, Tuesday etc with the drop down options below each one.

Is this easy to do or am I being optimistic?

 

[Bentley22]

Well, it depends. Did you create your code by hand, or did you use a WYSIWYG editor, like Frontpage? If your a coder, you shouldn't have any trouble picking up ASP.

There are several good tutorials out there, for starters check out

http://hotwired.lycos.com/webmonkey/backend/databases/

, the first tutorial. Excellent introduction to ASP and Access databases. "The surest sign that intelligent life exists elsewhere in the universe is that it has never tried to contact us"
Bill Watterson, Calvin & Hobbes

 

[rufc]

I learn html about 4 years ago but moved onto Dreamweaver about 6 months ago, so pretty much taught it myself I guess.

I don`t know any programming languages though or much about setting up pc's. I know the server has asp capability, should I have a go at doing it myself then, is it pretty straight forward if I have my clever head on?

 

[Bentley22]

I found it pretty easy to pick up, but I do program for a living. Take a couple of days to go through the tutorials, play around with it a bit, and you should be able to pound something out.

There is an ASP forumn as well, so if you get stuck, you can always ask a question there. "The surest sign that intelligent life exists elsewhere in the universe is that it has never tried to contact us"
Bill Watterson, Calvin & Hobbes

 

[Empeethree]

you could also check download.com for shareware or possibly freeware.

just an idea
hth
rob

 

[unicorn11]

go to a couple of sites like asp101.com or 4guysfromrolla.com or aspin.com or 15seconds.com one of them may have a readymade article for this

regards Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive smile is earned.[red]