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
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
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
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.
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
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 […]
Here’s a neat little pattern that might interest others. We got a version of the question below yesterday. Is there a way to automatically get the links from the search linked below into a spreadsheet? https://www.google.com/search?q=site%3Aedu+filetype%3Apdf+syllabus+education&oq=site%3Aedu+filetype%3Apdf+syllabus+education Then, from there, is there a way to automagically get the pdf files into a Drive folder? Step 1: […]
Read More… from Get the PDFs – Google Search to Google Folder
Jeff and I are doing a THAT Camp workshop that’s trying to talk about the scale/scope/potential of Google Sheets in the big box of Digital Humanities related options. Depending on how the workshop goes, I’ll revise this post to be more useful. Getting Data In There are quite a few ways to pull data into […]
We had a list of rampages sites in a Google Spreadsheet and wanted to know when they were created. I started to look that up but only managed to do it twice before I gave up and went in search of another way. In this case it took two little bits of code. This first […]
Google Sheets often thinks it’s smarter than you. That’s helpful at times and irritating at other times.1 The Google Form to Sheets path is one place where that can come up repeatedly and in ways that are hard to see. For instance, if you use the Time entry on forms, Google Sheets tries to coerce […]