As always occurs in places I work, we are looking to better log how we spend out time1 I do think it’s good to reflect on how you spend your time as an individual and as an organization. It’s also nice to be able to present aspects of that data with qualitative elements to paint […]
Tag: google script
Make a bunch of documents with Google Script
I’ve got a Google spreadsheet with the last name in column B and the email address in column D. My goal is to make a bunch of blank Google docs,name them in a pattern, share them with individual students, and put them in a particular folder. I decided to go ahead and write the document […]
Read More… from Make a bunch of documents with Google Script
Indelible Google Doc Journal Entries
About a month ago, I did round one of the form-to-Google-Docs scripting post. Since then, we’ve done some testing and things are working well. There was a desire to have the ability to rename documents. That required some rethinking. It’s also quite possible that the add commenter function wasn’t working. In any case, it had […]
Google Forms to Google Doc Journal Entries
A teacher requested the following for weekly journal submissions by students. Whatever is submitted is only viewable to the submitting student and the faculty member Submissions are not able to be edited after they are submitted (by the student) All of the submissions (for each student) can be viewed in one location by scrolling. (Something […]
On the Fly Data Validation Values in Google Script
I’m helping the School in France do some payment logging. We have five different activity types with different payment increment rules . . . so if you’re teaching a class you have a minimum of 90 mins, a minimum step of 30, and a max of 150 mins. For Tutoring it’s 15 minute minimum, 15 […]
Read More… from On the Fly Data Validation Values in Google Script
Google Script to loop folder contents and copy Google Sheets content
I helped one of our athletic directors do some budget sheets for different teams. We then needed to add an additional sheet to all the workbooks and copy over content from a similar page. Given it’s about 20 or so workbooks, I scripted it. […]
Read More… from Google Script to loop folder contents and copy Google Sheets content
Send Email to Different Addresses Based on Form Responses in Google Script
That title’s SEO gold, Jerry! I’ve used this pattern several times recently so I figured I’d write it up and break up the endless stream of “Weekly Web Harvest” posts. Google Forms are great but the options for doing more with emails are limited. Often people want to be alerted to a submission or to […]
Read More… from Send Email to Different Addresses Based on Form Responses in Google Script
Google Form to Script to Make Folder, Document, Share it etc.
My click bait titles are so powerful! This isn’t anything special but it does show a couple of Google Script patterns that we reuse all the time. Folders are made in other folders! Documents are made in those folders. Things are shared. Ownership is assigned! So many things. The following script takes a form submission […]
Read More… from Google Form to Script to Make Folder, Document, Share it etc.
Gravity Forms Notification to Google Spreadsheet
The idea that data can flow to different places for different purposes is one of the key concepts I want people to believe in. Different technologies and different interfaces have different affordances depending on what you’re trying to do. In this case, we’ve built some online training for students. As part of that training they […]
Read More… from Gravity Forms Notification to Google Spreadsheet
Google Sheets Data Flow
This is a pretty specific thing but the concepts ought to be broadly applicable and interesting for the 3 to 5 people who will end up reading this. It’s a fairly amusing blend of less standard Google Functions and a bit of Google Script to do something fairly decent that had been quite a bit […]