Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Laurence Svekis 
In Google Apps Script, managing styles in Google Docs can become cumbersome, especially when dealing with multiple styles across a large document. Object literals can streamline this process, providing a structured and reusable approach to handling styles. In this blog post, I’ll explain how using object literals can simplify the styling process in Google Docs … Read more
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
Coding Exercises on JavaScript Error Handling and Debugging Basic try…catch Implementation Task: Write a JavaScript function that attempts to parse a JSON string and uses try…catch to handle any errors that arise. Purpose: Understand how to catch and handle errors gracefully in a controlled manner. Sample Code: function parseJSON(jsonString) { try { let jsonObj = … Read more
Coding Exercises on JavaScript Functions Basic Function Definition and Invocation Task: Write a JavaScript function named greet that prints “Hello, World!” to the console. Purpose: Learn how to define and call a simple function. Sample Code: function greet() { console.log(“Hello, World!”); } greet(); // Function invocation Explanation: This exercise demonstrates the basic structure of a … Read more
Google Next 2024 was a landmark event, showcasing the vast strides Google Cloud has taken in integrating generative AI across a diverse array of sectors. Here’s a comprehensive breakdown of the key announcements and innovations that are shaping the future of how businesses interact with cloud technology. Introducing Gemini: A New Era of AI At … Read more
Instead of making an additional fetch request from the client-side to get the data, you will pass the data directly when the HTML page is initially served. Here’s how you can achieve this: Google Apps Script: Server-Side You’ll modify the doGet function to use an HTML template that includes the data. This allows the server … 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