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
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 […]
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 […]
I supported the creation of a PressBooks OER textbook at VCU. It’s now getting published as part of a VIVA grant. As part of that, the book is imported into the central VIVA PressBooks site. They reached out to me indicating that the image links for WP media links were failing on the VIVA site. […]
As part of the AI Detox, people are cutting and pasting AI/Human conversations from a little font-end chatbot I made with the ChatGPT 4 API. The responses are just in rich text for downloading/saving. The conversations look something like this. The “speaker” is automatically prepended.1 AI: Some weird sentence. Human: Some response. AI: I don’t […]
We are messing about with some ChatGPT API chatbots as part of the AI Detox this year. I modified a little API-based chatbot to make it goofier. Turns out the download content option worked fine in Chrome but downloaded as a .dms file in FireFox. This works in both browsers and gets the file as […]
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
In this imperfect world, I often get involved in project after decisions have been made and content has been created. This is one of those scenarios. What we have is an online textbook. It has a sidebar menu for each section and at the bottom of each page are buttons for the previous/next page. Pretty […]
We’re doing some strategic planning in Google’s Jamboard. I find it good for the live/interactive aspects of the conversation but when I was looking back over it, it was hard for me to read and organize in my head. I decided I wanted the text from the various sticky notes in a spreadsheet so that […]
In the time of APIs, python scrapers and other cool things, bookmarklets have fallen from favor but they still have uses and I still like them. For small jobs that you want to make accessible to people they are still really handy. In this scenario Middlebury has lots of ways to get roster information about […]