tag:blogger.com,1999:blog-6274613198416400788.post8542649273653784173..comments2023-10-16T09:31:38.087+01:00Comments on Collaborative Tools Project: 3. Building a Booking System ( the afterthought )Tom Smithhttp://www.blogger.com/profile/01422061334608169812noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6274613198416400788.post-77567545093773193282012-05-31T20:00:37.360+01:002012-05-31T20:00:37.360+01:00Cheers, I like the look of that onEdit tinker. I c...Cheers, I like the look of that onEdit tinker. I could imagine maybe popping up a mini Gui when you click into a "bookable" cell...Tom Smithhttps://www.blogger.com/profile/01422061334608169812noreply@blogger.comtag:blogger.com,1999:blog-6274613198416400788.post-50735709471745769602012-05-31T17:37:03.624+01:002012-05-31T17:37:03.624+01:00Hi Tom,
Like the comment from Chris it's gre...Hi Tom, <br /><br />Like the comment from Chris it's great to see you work through this problem. I don't know if you've considered using the onEdit trigger to handle changes (might help in case users forget to go to the menu option) https://developers.google.com/apps-script/guide_events#Simple<br /><br />Looking forward to seeing what else you come up with,<br />MartinMartin Hawkseyhttps://www.blogger.com/profile/15374805883358566843noreply@blogger.comtag:blogger.com,1999:blog-6274613198416400788.post-27263413707794679932012-05-31T16:57:20.760+01:002012-05-31T16:57:20.760+01:00Chris, are you using Google AppsScript much? Or wa...Chris, are you using Google AppsScript much? Or want to...<br /><br />I'd like to get a group together to share basically stuff we've done, ideally in the form of shareable libraries. Paul Bushnell is already doing some great stuff and may have a great "mail merge" library to share....<br /><br />I'm just learning, but I'm trying to share what I learn as I go...Tom Smithhttps://www.blogger.com/profile/01422061334608169812noreply@blogger.comtag:blogger.com,1999:blog-6274613198416400788.post-61817274751175834762012-05-31T14:22:21.411+01:002012-05-31T14:22:21.411+01:00Thanks... I don't think Appointment slots help...Thanks... I don't think Appointment slots help - they're for a conceptually different thing (segments of time ) as opposed to items of a resource ( desks ). I'd be happy to be proved wrong on that though...<br /><br />Also, there's 70ish of them...Tom Smithhttps://www.blogger.com/profile/01422061334608169812noreply@blogger.comtag:blogger.com,1999:blog-6274613198416400788.post-91351971695092191642012-05-31T13:20:38.547+01:002012-05-31T13:20:38.547+01:00Tom
Awesome post series - really cool to see how ...Tom<br /><br />Awesome post series - really cool to see how you have explored the problem. Just wanted to add a few suggestions myself.<br /><br />Have you looked at Appointment Slots in Google Calendar? I have considered those for room bookings (or anti-bookings...) - could be relevant?<br /><br />Also, I made something in my spare time which uses AppScript to book something, generate a UUID, and send an email with a cancel link - don't know if that's something that would be of interest.<br /><br />Finally, have you thought about having a system which merely lists the number of free perches (I think there's a similar system for washing machines on campus!), and users just 'swoop by' to use one, if one is still free. Then you get away from the 'booking and not using' problem. <br /><br />If the desks all have PCs, onto which you assume users will log, you could (could you? I don't know. Let's assume so) have some script which runs at logon for each machine and calls some web service, to log that the perch is in use, and again when they log out.<br /><br />Anyway, good luck with the quest!Anonymousnoreply@blogger.com