You can imagine the scenario, you’ve got a Google Form perhaps setup as a booking form and a select option for picking timeslots. As the slots fill up you’d like the option to be removed. I was surprised not to find an example of this so here is a rough sketch of some code that might do the job.
"If you are new to Google Apps script this post will give you the information you need to get started. Writing a Google Apps Script can be an intimidating process for those who have not done programming before so be patient and take your time getting comfortable with this incredible tool for educators."
"Created by educators working in the CloudLab, a project of the non-profit New Visions for Public Schools, autoCrat is an add-on that allows you to merge data from your Google Sheets into a custom Google Doc template built and designed by you. This add-on can be especially powerful when combined with Google Forms. Upon submission of the form, autoCrat can be configured to automatically email the merged information in the form of a PDF or Google Doc to an email address collected within the form or designated in the autoCrat set up process.
Why would educators want to use autoCrat? Here are my top 5 favorite ways that educators are utilizing this Add-on"
Google Apps Script is a surprisingly powerful scripting language often implemented using Google Sheets. It allows people to develop lightweight web applications, and those scripts run in the cloud on Google’s servers.
"Here's a framework for automating parallel processing with Google Apps Script. You can do Map/reduce operations, beat the 6 minute limit, and simulate multiuser activity and watch progress in real time. "
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
Martin Hawksey's insight:
Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)
"The integration to Virtual PBX is a custom gateway designed to harvest PBX call data logs and filter them based on calls associated with reservations extensions. I used Google Apps Script to automate the update of call data in near-real-time despite the fact that a formal API is not available from this PBX provider.
The data is stored into a 13 column spreadsheet capable of handling approximately 25,000 calls per month with a ceiling of about two years worth of data. All processes and integration with Virtual PBX is handled by Google Apps Scripts (GAS) and available as an installable service"
Martin Hawksey's insight:
Bill French, Founder and Editor at iPadCTO outlines how they use Google Apps Script for custom data collection and reporting
" There was a query posted in the GEG Singapore about automatically creating forms from spreadsheet questions. g(Math) kind of does this, so I threw a script together that will create a form from a highlighted range. It will even create multiple choice questions from option in the sheet (I am especially proud of that aspect). Check it out here and make a copy to play around"
"The other day I showed how to run Apps Script tasks at once using HTMLService to orchestrate the results. This not only gets stuff done quicker but avoids having to worry so much about running out of quota, since parallel tasks each have their own quota. In this example I'm running some cryptography tasks in parallel that wouldn't normally be able to finish. This tutorial includes all the code you'll need to do the same thing."
"I've had a heck of a time trying to figure how to allow anonymous uploads to a specific folder in Google Drive. Places where this might be useful would be resume submissions for employment or other applications where users might not have a Google Account. In my district, I'm using it to collect submitted WDE reports from administrators for archival purposes.
After some initial confusion, I was able to hack my way through a Google Apps script that works to allow uploads to a specific folder in Google Drive. Couldn't come at a better time as our Google Drive finally went unlimited." +Cole Nicholas