Cause for concern system and email

[woody22]

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

This would need

Year (select from list)

Student Name (select from list) – could this just be the students in 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 been logged and sent to (head of department) for further action.

Whats the best ways of going about this???

Thanks!!

Woody

 

[Ethan]

You could probably do some of it with PHP and MySql, but you could do a complicated JavaScript one if you didn't have the resources for PHP and MySql.

 

[woody22]

unfortunately our servers dont support mysql and php - i dont suppose anyone could give me a brief starting point on how to do it using asp pages and sql - this is what id need to develop it in and i havent a clue where to start!!!



thanks