At FHU we use http://schedulet.com/.   I like it a lot because it uses periods instead of actual time.   The script I am working on will work similarly.

Bjorn Behrendt M.Ed ~ Never Stop Learning
   [log in to unmask] | (802) 772-0003
   Google Apps For Education Certified Trainer & Administrator
My Sites
 ~ Edlisten.com Educational Podcast
 ~ AskBj.net ~ Online Training and Ed Tech Resources
 ~ VTed.org ~ Vermont's Personal Learning Network

gClassFolders ~ Create Google folders for your class.


On Wed, Jun 4, 2014 at 10:03 PM, Eric Hall <[log in to unmask]> wrote:
We use calendars and appointment slots for eight labs, and it works very well. The calendars are owned by a generic account and when a cancellation occurs the slot is immediately opened again for others. The only "hitch" is that the original appointment is not deleted, but the calendar account gets an email (forwarded to someone else) so it can be manually deleted.


Eric Hall
Technology Integration Specialist
Mount Mansfield Union High School
Chittenden East SU

No trees were injured in the creation of this message, but a significant number of electrons were inconvenienced.


On Wed, Jun 4, 2014 at 4:46 PM, Bob Wickberg <[log in to unmask]> wrote:
Hmm, we use calendars instead of spreadsheets, but it's the same idea.
This isn't something that's come up here.  I wonder if it's because we
have enough tech to meet the demand, or because teachers just don't go
into the calendars and delete their reservations when they don't need
stuff. That would be kind of rude, but I'm sure it happens, too.

I wonder if the staff who are clamoring for notification when a slot opens
up are a majority, or if you're going to have as many people annoyed by
the notifications as will have people who are happy to be getting them.
If the latter, you'll need a way to opt in or opt out of the notices.

I wonder if you could just create a mailing list of folks who want these
notices, and ask teachers to email the list when they delete a
reservation, and not bother to program it?



Bob Wickberg
Technology Coordinator
Brattleboro Union High School District # 6
802-451-3418



School Information Technology Discussion <[log in to unmask]> writes:
>Hi Friends,
>
>
>Here at MCS we used a series of shared Google spreadsheets as sign-up
>sheets for  reserving the building's various laptops, Chromebooks and
>iPad carts.  All teachers have access and schedule the resources as
>needed.
>
>
>This time of year all the equipment is in very high demand but often
>teachers have other things come up  at the last minute (field trips and
>assemblies and such) and do not need one of the carts. On Monday I was
>asked if there was any formal way of alerting the staff, automatically,
>if a cart became available. Can we all get a mailing if someone cancels a
>time slot in the lab?
>
>
>In doing a bit of searching it seems that with Google Spreadsheets, via a
>script, automatic notification is possible to a specific mailing group,
>and I will look into it.
>
>What concerns me is that, to the best of my knowledge, that script would
>alert the group about any changes to the spreadsheet. Meaning a teacher
>adds a time, deletes a time, changes a period of time, they reserved a
>cart.  In looking at the revision history, in a single day, one sheet
>might be modified a dozen times.  We don't want to notify everyone on the
>staff of every change on the sheet; only the if someone removes
>themselves from a time slot and thus that time is now open.
>
>
>Do you think it's possible/ do you know how I might create a notification
>for changes to a spreadsheet but only for certain criteria?
>
>
>
>Think it is possible? Thoughts?
>
>Thank you.
>
>john
>
>--
>John Minelli
>Curriculum and Technology Coordinator
>Marion Cross School
>22 Church Street
>Norwich, VT 05055
>Office: (802) 649 - 1703 x212
>Cell: (603) 715-0629
>
>
>-----------------------------------------------------------------------
>
>[ http://list.uvm.edu/archives/school-it.html ] Search  the SCHOOL-IT
>Archive
>
>[ http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1 ] Manage your
>Subscription to SCHOOL-IT
>


This e-mail may contain information protected under the Family Educational Rights and Privacy Act (FERPA). If this e-mail contains student information and you are not entitled to access such information under FERPA, please notify the sender. Federal regulations require that you destroy this e-mail without reviewing it and you may not forward it to anyone. 

-----------------------------------------------------------------------

Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT


-----------------------------------------------------------------------

Search the SCHOOL-IT Archive

Manage your Subscription to SCHOOL-IT