Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Arrays are a fundamental part of JavaScript, providing a way to store and manipulate collections of data. JavaScript offers a wide range of methods to work with arrays efficiently. In this blog post, we’ll explore some of the most commonly used array methods and operations, complete with examples to illustrate their usage. Common Array Methods … Read more
JavaScript is an essential language for web development, and one of its most powerful features is the ability to manipulate the Document Object Model (DOM). This allows developers to create dynamic and interactive web pages. In this blog post, we will explore how to select and modify DOM elements using JavaScript. Selecting DOM Elements Selecting … Read more
Maintaining a consistent heading structure in your Google Docs is crucial for readability and organization, especially in lengthy documents. If you find yourself needing to change all H3 headings to H2 headings, doing it manually can be tedious and time-consuming. Luckily, Google Apps Script allows you to automate this process. In this blog post, we’ll … Read more
Keeping your Google Docs well-organized and visually appealing can be a challenging task, especially when dealing with large documents. One common formatting requirement is to resize H3 headings and add horizontal lines above them for better separation and clarity. Instead of manually editing each heading, you can automate this process using Google Apps Script. In … Read more
Introduction Do you often find yourself needing to clean up specific headings in your Google Docs? Maybe your document has numerous H3 headings that start with “Question” followed by a number, and you want to streamline these headings by removing the redundant word and number. This manual task can be time-consuming and prone to errors. … Read more
If you’ve ever found yourself needing to merge specific headings in your Google Docs with the following paragraph, you’re not alone. Whether it’s for organizing content, creating structured documents, or simply for aesthetic reasons, this task can be tedious when done manually. Fortunately, Google Apps Script offers a powerful way to automate this process. In … Read more
Question 11 What will the following code output? console.log(1 + “2” + “2”); a) 5b) “32”c) “122”d) NaN Answer: c) “122” Explanation: When adding a number to a string, JavaScript performs string concatenation. 1 + “2” results in “12”, and then “12” + “2” results in “122”. Question 12 What is the output of the … Read more
Question 1 What is the output of the following code? console.log(typeof NaN); a) “number”b) “string”c) “undefined”d) “NaN” Answer: a) “number” Explanation: In JavaScript, NaN (Not-a-Number) is actually of the type number. This is a special value that results from operations that don’t yield a valid number. Question 2 What does the following code snippet do? … Read more
Expanding on our previous exercises, here are three more coding challenges to further enhance your skills with Google Apps Script. These exercises will guide you through creating a custom function, automating calendar events, and generating PDF files from Google Sheets data. Exercise 7: Create a Custom Function to Calculate the BMI Objective:Create a custom function … Read more
Continuing from our previous blog post, here are three more coding exercises for Google Apps Script. These exercises will help you deepen your understanding of Apps Script by creating custom functions, manipulating Google Sheets data, and integrating with external APIs. Exercise 4: Create a Custom Function to Convert Celsius to Fahrenheit Objective:Create a custom function … Read more