kjoewill
commented
1 year ago Mark provided some more information re: what he'd like to see on this topic:
Hi kevin, I think it would be great if we had the ability to automatically annotate the reservation page with the names of tow pilot, IP, and lube crew for the day (or at the very least the tow pilot and the instructor) As it makes it immediately obvious if there's even a tow plane available for a given day, and then also if there's an instructor available if they need one. In a perfect world your app could treat the public Google spreadsheet as a second days source and render the crew information itself. However I know you have limited time to support the reservation application so folding that functionality into your application seems like way too much work to ask for so I've developed a couple of python utilities that just treat use you application an "as is" black box and write things into cells by just creating and sending it appropriate urls. I haven't completely finished my utility that will take the Google schedule and update the reservation page yet but that is where I'm heading. I do need to check if I can arrange for my ISP to run a Cron job so that my utility would run periodically to catch any changes people make to the Google duty spreadsheet. So my intermediate level thought was if you could add a URL endpoint to your app that I could access to write the crew information and then it could render it say in bold just above the calendar widget that would make it a little more streamlined on my end. For now putting the IP and tow pilot in the 8th and 8:30 slots seemed the safest because I agree in general we could just drop those slots from normal reservations. If you do want to collaborate on this further let's maybe do a phone call and brainstorm Mark
So, I need to think about this ... I kind of like the idea of reading the google duty sheet and loading the info automagically.
Looks like I could use the 'google_drive' gem to read a google sheet.
Hightflights (Mark) is currently using the 8:00 and 8:30 time slot fields for generic information such as tow pilot and instructor for the day like this:
Mark has also asked for a way to provide this info in an email.
If I understand this request then one solution might be to provide a comment section for daySchedule and this would be displayed and editable from the home page.