The Gift of Script
I'm Phil Bainbridge and I aim to share my experiences of IT projects I've worked on as I continue to learn and develop, through this blog. My main coding language is Google Apps Script (with JavaScript), but there is also some: PowerShell, HTML, SQL and jQuery.
Tuesday 2 July 2024
The Gift of Script YouTube channel
Tuesday 4 June 2024
Correct date formats in a Google Sheet
Screenshot showing difference between American/British date formats |
Tuesday 21 May 2024
Google Add-on: Send Recurring Emails
What it does
- Newsletter submissions.
- Monthly reports.
- Team meetings.
- Attendance checks.
Demo video
Find out more
Tuesday 7 May 2024
Google Add-on: Bulk Calendar Events
What it does
- Meetings
- Workshops
- Events
- 1:1s
Demo video
Find out more
Tuesday 9 April 2024
onFormSubmit Trigger simultaneous executions
When should an onFormSubmit trigger run?
Tuesday 19 March 2024
Probation Tracker Tool
Manage probation review dates in a spreadsheet and be sent reminder emails |
Tuesday 12 March 2024
Totally Unscripted: Level Up Your Productivity: Unboxing the Gift of Apps Script
Are you looking for ways to supercharge your productivity with Google Apps Script? Then this episode of Totally Unscripted is for you!
Join us as we explore how Google Apps Script is being used to make a real impact in productivity. Our guest speaker, Phil Bainbridge, is an experienced IT specialist at the University of York and author of 'The Gift of Script.' He will share his insights on how Google Apps Script can be used to automate tasks, create custom solutions, and enhance your workflow. As part of this episode we will discover how Phil and other members of York’s Digital Inclusion, Skills & Creativity team support digital literacy development in Google Workspace and Apps Script as well as the solutions they have created to improve productivity.
20 March 2024 at 7pm.
Tuesday 13 February 2024
Replace text in a Google Doc with an image
The following Google Apps Script is designed to search the body of a Google Doc for a specific string/pattern (i.e. a keyword) and insert an image in place of it, optionally making it a clickable hyperlink too.
Instructions
In this example the code is designed to sit behind the Google Doc so it is bound to it. There are 4 pieces of information to complete in order to setup the script:
- searchText - this is the unique string/pattern in the Doc that you want to replace with an image e.g. "<<keyword>>"
- imageURL - this is the direct link to the image in Google Drive that you wish to use in the Doc.
- size - a numerical value representing the number of pixels for the image's width/height.
- hyperlinkURL - if you want the image to be clickable then provide a link for it.