Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
When designing web applications within the Google Apps Script environment, it’s crucial to ensure that UI elements like modals are responsive and look good on all devices, from desktops to mobile phones. This post will guide you through creating a responsive modal dialog in Google Apps Script using the HTML service, ensuring it adapts to … Read more
Creating visual diagrams like web layouts directly in Google Docs can be a unique challenge, especially when you need to integrate dynamically fetched images into a structured format such as a table. Google Docs provides basic functionalities for handling images and tables but integrating them seamlessly requires a bit of scripting finesse using Google Apps … Read more
In the modern digital workspace, protecting and branding your documents is crucial. One effective way to achieve this is by adding watermarks to your documents. Although Google Apps Script doesn’t directly support advanced PDF manipulations, you can still use it to create watermarked PDFs by leveraging Google Docs as an intermediary. In this blog post, … Read more
In today’s digital environment, managing files efficiently can save a lot of time and hassle. Google Apps Script provides a powerful way to automate tasks within Google’s suite of services, including Google Drive. In this blog post, I’ll guide you through creating a simple script that checks if a specific file exists within a Google … Read more
To create a web application using Google Apps Script that outputs the contents of a Google Spreadsheet into a client-side JavaScript object, you’ll need to write code for both the server-side (Google Apps Script) and the client-side (HTML with embedded JavaScript). Here’s how you can set it up: 1. Google Apps Script: Server-Side First, you’ll … Read more
You can achieve this task using Google Apps Script, which allows you to automate actions within Google Docs. The script below selects all H4 elements in a Google Doc and converts them to regular text that is bolded. This is done by finding all the text elements formatted as Heading 4, changing their attributes to … Read more
Creating a Table of Contents (ToC) in a Google Docs document using Google Apps Script, focusing only on Heading 1 styles, is a straightforward task. Below is a script that does exactly that. It scans through your document, identifies all the text that has been styled as Heading 1, and then generates a ToC at … Read more
Unlock the Power of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Are you looking to dive into the world of Google Apps Script and transform the way you interact with Google Workspace? Look no further! For a limited time, the best-selling book “Coding … Read more
Unlock the Full Potential of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Read the first 2 chapters Free at Amazon – Get your free Kindle version of the book today US https://www.amazon.com/dp/B0CXXLMMHQ Can https://www.amazon.ca/dp/B0CXXLMMHQ Over 200 Apps Script Coding Exercises here https://github.com/lsvekis/Coding-with-Google-Apps-Script/ In … Read more
This guide will walk you through creating a basic web app that dynamically loads HTML content without refreshing the page, enhancing your site’s interactivity and speed. To update your Google Apps Script web app to dynamically load HTML content without reloading the page, and to incorporate JavaScript addEventListener for better handling of user interactions, follow … Read more