Employee Check in and Status

R

Ron Gallon

Please Help.

I need to create a internal website that employees can log in and select if
there are in or out off the office and the secreatary can see real live
update if an employee is in or not.

Thanks in advanced
 
C

coreybryant

You will need some type of server side language (ASP / PHP) to use to
communicate this back and forth

-Corey
 
P

p c

Yes. But you would need custom scripting run at the server, and a back
end database would make it a litle easier to program and track if you
want to keep history.

Another option is to buy a program that does what you want.

...PC
 
N

Nicholas Savalas - http://savalas.tv

Dear Ron,
The answer is a simple one, and you already own it: the FrontPage
Database Results Wizard.
Create a registration page where employees create a username &
password, and a log-in page where access to the 'availability' area is
limited to logged-in employees. An example of this can be found at
http://home.att.net/~codeLibrary/FrontPage/drws_p.htm - this uses
nothing but the FrontPage Database Results Wizard.

Create a page in that area with the form for employees to input their
availabilty; include a timestamp (it's built in). Then create a page
that returns their info, including time, and listed by employee or by
latest entry using the Database Results Wizard (Insert -> Database ->
Results...). Since you want only that employees to access their own
specific records in the database, the passed session variable (meaning
identifying that specific employees from their log-in credentials) can
be used in the Database Results Wizard SELECT SQL statement, such as:

SELECT * FROM TableName WHERE UID = ::uid::

A page, for the secretary, showing availability, is then created using
the Database Results Wizard. Either it can auto-refresh every so-often,
or she can do it manually.

Good luck, Ron; I expect fantastic things from you.

Nicholas Savalas - http://savalas.tv
--------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top