Apps Script

By

I've been working on creating some resources for teachers in my district and trying my hand at Google apps script. Below are some samples of what I've tried and some templates to use them, if you wish. Some of them will be coded as Add-ons while others are just Google Apps Scripts created to do some custom processing. Much of what I've used I have found on Google's App Script Developer's Guide and by looking/asking on Stack Overflow.

I will add more to this page as I develop more applications and scripts.


Apps Script Slide Deck



Script Name Task Link
Mass Docs Create a desired number of copies of a template document.
Form On/Off Use time based triggers to automagically turn form response collecting on and off.

 bit.ly/FormOnOff
TimeStamp A Google Apps Script that runs with a formula in a google sheet and will input the date when the corresponding cell has been edited or meets a specific condition. bit.ly/EditTimeStamp
DupTab Sample A Google Apps Script Sample that will duplicate tabs for a roster list. Based on Alice Keeler's RosterTab tutorials. bit.ly/DupTab

Comments

Post a Comment

Popular posts from this blog

Private Comments in Google Classroom

By
Image
One of my most favorite ways to give feedback to students is using the Private Comments feature in Google Classroom. Much of my love for them has come from what I've learned from Alice Keeler, both on her blog and from her session at our Tech Kickoff this past August. I like this so much because it allows for personal, instant, and constant feedback to students on an individual level from anywhere, anytime. I know many teachers in my district don't like the fact that they are getting notifications from students at all times of the day, but I think it's great to see that my students are interested in their work for me when they have the time to do it. Plus, it gives me a great way to talk to students about time management, commitments, and prioritizing the things in your life (even if it ends up that my class works isn't the priority, it still opens up that window!). One quick note: I've found that many people don't see the difference between the Private Com
Read more

Leverage Data Validation in Google Forms

By
Image
Although it sounds very dry, data validation in Google Forms is actually a great help to anyone wanting to collect information or give assessments. Plus, it's only a couple of clicks away from making your forms work better for you and your target audience. What is data validation? To begin, we need to know what we are talking about. Data validation is basically a way for the person who is creating the form to "force" those that are filling it out to follow their directions, or they can't submit their answers. That's right! Forms won't allow them to submit until those criteria have been met. This creates predictable answers from your students so that using the information in the spreadsheet is simplified (numbers where you need numbers, text that is the correct length, the right number of answers in a specific question, etc.). How to make it happen: To begin, create a from in Google Forms and create a question in that form (data validation works in sho
Read more

Google Drive: Share Google Files as Templates or View Only

By
Image
I've learned a lot lately about what can and can't be done with a Google doc to manage what happens when I share it with other people. In most instances, I use the built in sharing settings when I want to collaborate or convert my docs to PDF and share that so that my original can't be changed by anyone. Recently, I found that this was not the only way to do this and really it probably wasn't the most convenient way to share my documents. I've tried publishing my Google docs, but have found mixed success with the formatting. It seems that publishing works best with Google Slides, but other file types are not as friendly. To get around these hurdles, adjusting the URL can be a really useful way to  make your work or your students' work available. Required Settings Be sure to set either the global sharing settings or the individual sharing settings to the desired access level before proceeding. To do this on any document type:  Click on the blue Shar
Read more