Google Scripts can do some really cool things

I've been doing lots of fun things at my new job (that only I use). When somebody calls to book an appointment there's about twelve questions you have to ask. I tried writing them all down on a post-it but I was always at a different desk and I was always forgetting something.

So I made a Google Form and linked it to the calendar. All the questions get answered, it gets added to the correct calendar and I even found an add-on that emails an email confirmation to the customer! Small things but I've never used Google Scripts for anything.

The only thing is that you have to have the calendar on one side of the screen and select the date on the form on the other side of the screen. So I want to make an extension that will make a pop-up while you're on the calendar page. However, since I'm the only one actually using this at the moment and nobody else asked for it this is dead last in the priority list.

Other things I can do with Google Scripts? So this one is actually saving everyone time - not just me! There are appointment slots in the Google Calendar that have to be re-made every week. One way to do this would be making a repeating calendar event. However frequently somebody saves new customers details as 'save for all events' rather than 'only this event' which means a lot of long term pain when I have to dig out the calendar back-up to find out what we lost.

So! I made a cool script that takes cell 1 as the title, cell 2 as the start time and cell 3 as the end time! Repeat until end! One click and it's all done. Not a super exciting awesome thing but 100% saving people time. 20 minutes a week? Plus time saved when things screw up.

So yeah! Two cool things Google scripts can do!