A System i need setting up - help!

[woody22]

We currently have a cause for concern system where staff send emails t
the relevant people when they have a problem with the student. Is i
possible to set up a resource that would automatically email it to th
correct people

This would need

Year (select from list)

Student Name (select from list) – could this just be the students i
the year

Teachers Initials (same links as the cover page)

Teachers Department:- (select from list) – Maths, English, Science
History, Geography, RS etc. and not in lesson

Date of Incident:- (select from list)

Time of Incident :- (Period 1, 2, 3, 4, 5, 6, Before School, Lunch
After School, Form Period)

Incident:- Blank Space

This would then email to

Head of Department (known from Teachers Department)

Tutor (known from tutor group attached to name)

Head of Year (known from year)

Admin person to log it (fixed name)

Could it also send an email to the teacher to say your report has bee
logged and sent to (head of department) for further action.

Whats the best ways of going about this using asp and sql??????

Thanks!!

Woody :


-
woody2

 

[Kevin Spencer]

It isn't necessary to use SQL or any other database if all you want is to
have a user fill out a form and send emails. However, you're going to need
to do some server-side custom scripting using ASP or ASP.Net (assuming your
server is Windows) to customize how many emails and to whom they are sent.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Jim Buyens]

I seems to me that you'll need:

o A "students" table, with one record per student
containing a student id, student name, and year.
o A "classes" table with record per class session.
These record would contain a class id and a
teacher ID.
o A "teachers" table with one record per teacher,
containing teacher id, teacher name, e-mail
address, and department id.
o A "departments" table with one record per department.
This would contain a department id, department name,
and the teacher id of the department head (assuming
that all department heads are also teachers).
o A student_classes table that relates students to
classes. Each record would contain one student id and
one class id.
o A teacher_classes table that relates teachers to
class sessions. Each table would contain one teacher
id and one class id.

After populating these tables, you would program some
cascading drop-down boxes for Year, Student, and Class
Session.(Observe that knowing the class session, you can
look up the teacher, and knowing the teacher you can look
up the department head.)

To program the cascading drop-down boxes, you would have
to write JavaScript code that reacts to onchange events in
the Year and Students lists by setting the value of a
hidden form field and then submitting the form.

ASP code on the server would check the value of the hidden
form field, determine whether the submission occurred
because:

o The visitor changed the Year selection.
o The visitor changed the Student selection
o The visitor clicked the Submit button.

In the first two cases, the ASP code would reload the
appropriate drop-down boxes accordingly and redisplay the
form.

In the third case, the ASP code would verify that the
incident date, time, and description were properly
entered, and then send the mail, or update an incidents
table, or whatever.

Other than the code, the hard part will be populating the
various tables with data and keeping them up to date.
Unless you can get this data from some other database or
system, you should also plan on writing maintenance pages
so the school secretary (or whoever) can update the
various tables.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------