Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Introduction In web development, we often encounter scenarios where a function needs to be executed repeatedly in response to events like scrolling, resizing, or mouse movements. However, triggering the function too frequently can lead to performance issues, such as slowing down the browser. This is where throttling comes in handy. What is Throttling? Throttling is … Read more
Formatting content in Google Docs can sometimes require manual adjustments that are both time-consuming and prone to errors, especially when working with large documents. One common formatting issue involves headings that start with unnecessary characters, such as colons, which can disrupt the visual flow and readability of your document. In this post, I’ll show you … Read more
Google Apps Script is a powerful tool that enables you to automate tasks and extend the functionality of Google Workspace apps, including Google Docs. In this blog post, we’ll explore a practical script that merges paragraphs into the preceding H3 headings and removes trailing colons from those headings. This can be especially useful for formatting … Read more
In JavaScript, the Array.prototype.map function is a powerful method that allows you to transform the elements of an array by applying a callback function to each element. It returns a new array containing the results of calling the callback function on each element. But what if you wanted to implement your own version of map? … Read more
In JavaScript, Promises are a powerful way to handle asynchronous operations. They provide a mechanism to execute code after an asynchronous task completes, with support for chaining multiple tasks using the .then method. In this blog post, we’ll explore how to implement a basic version of a Promise from scratch, including support for .then, .catch, … Read more
When working with JavaScript objects, you may encounter situations where you need to create an exact copy of an object. However, simply copying an object with assignment (=) or even using methods like Object.assign() creates a shallow copy. This means that nested objects or arrays within the original object will still reference the same memory … Read more
The current code reads a JSON file, parses it into an object, and then logs certain values to the console. We’ll go through the steps to make this code more flexible by allowing it to handle a JSON object. Here’s the code as it stands: const http = require(‘http’);const fs = require(‘fs’);const site = http.createServer(function(req, … Read more
In this blog post, we will delve into a Google Apps Script function that calculates the cost per item, considering any applicable discounts. This script is especially useful for e-commerce platforms or any other scenarios where discounts and coupon codes are used to determine the final cost of products. We will explain the code in … Read more
Google Apps Script is a powerful tool that allows you to automate tasks and enhance your Google Sheets capabilities. In this blog post, we will demonstrate how to use Google Apps Script to calculate the total cost from a sample data table. This script can be especially useful for financial calculations, budgeting, or any scenario … Read more
In this blog post, we will explore how to use Google Apps Script to copy data from one Google Sheet to another. Specifically, we will copy five columns, excluding one column, and ensure that our destination sheet has an auto-incrementing number for the first column. Additionally, we will eliminate any duplicate rows in the process. … Read more