Music, hey Joanna, for Friday's event. I'm trying to make sure our volunteers know when and where to go. Is there a way for me to export schedules from our spreadsheet into our team calendar? So, like putting all these shifts into the event calendar automatically? Yeah, exactly. Absolutely! You can use Apps Script. Apps Script is a really easy way to customize your apps with really simple code. Awesome! So, what do we do first? Give me one minute. Okay, so I went ahead and set some things up in a spreadsheet to make it a little easier for us. First, I reformatted the dates to make them easier for the code to understand. I just did this by clicking "format number date and time". Trust me, you do not want to have to learn how dates work in programming. And then second, I went ahead and wrote some skeleton code for you in the script editor. So, if you want to open it up, it's under "tools" > "script editor". Cool, yeah. So, what do I do now? Well, any coding task is much simpler if you break it into smaller tasks. First, you wanted help syncing a sheet to a calendar, yeah? Okay, so task 1: What calendar? Our team calendar. We need to open that. Task 2: What part of the sheet? The part with the dates and shifts. Okay, so we need those cell numbers. Task 3: We need to actually take that information, make an event, and then test for bonus. And I did it for you to make it easy for everyone to use. Oh, thank you. Cool, so now what? Now we begin test number one: opening the calendar. It's really simple. The call is "calendarApp.getCalendarById". Now, to get the ID, we're...
Award-winning PDF software
Video instructions and help with filling out and completing Are Form 8865 Schedules
