Daily School Announcements

[Nick_Parker]

We use Google Docs. We have a Google Spreadsheet with different sheets for everyday of the week with up to a month in advance.

Staff have the document shared with them, they open it up, load of the sheet for the day they want the notice to go out and type it into one of the cells.

At 9:30AM everyday there is a script that runs and takes all the notices for that day and emails them to the staff & students.

[fiza]

I have been busy this week, I will try to make it available this weekend.

 

Any progress? Would love to try this out in my school.

[Max_Power]

Looks like a really slick and easy to use system, would give that a try if you are willing to share as a download with instructions on how to setup.

[dalehopper]

Looks great, id also like to give this a go to replace an aging system we have, let me know when its available

Thanks

Dale

[fiza]

@mrdolan any update on when you could release this for others to test/use?

[Edu-IT]

We use Google Docs. We have a Google Spreadsheet with different sheets for everyday of the week with up to a month in advance.

Staff have the document shared with them, they open it up, load of the sheet for the day they want the notice to go out and type it into one of the cells.

At 9:30AM everyday there is a script that runs and takes all the notices for that day and emails them to the staff & students.

How exactly does that script work?

[mrdolan]

I have now packaged my Messages System for others to try and have written an overview and some instructions.

 

The details are in a new thread to make it a bit easier for people to find and so as to not distract from the other things in this thread.

 

http://www.edugeek.net/forums/web-development/144188-student-messages-bulletin-system.html

 

Sorry it has taken a while.

[fiza]

@mrdolan - much appreciated.

[Nick_Parker]

How exactly does that script work?

 

Hey @Edu-IT, sorry about the delay, I only saw your reply now.

Below is the Google Apps script code, I've set a trigger to run at 9 every day.

The script finds the sheet that matches the days date, checks it hasn't been sent already, takes all the contend and emails it to the staff & students then marks the sheet at sent.

 

Daily Notices script.txt