Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Sheets Custom Formulas: Comprehensive Guide Custom formulas in Google Sheets are created using Google Apps Script, which allows you to build powerful, reusable functions for advanced spreadsheet operations. This guide explains how to create, use, and troubleshoot custom formulas in Google Sheets, with detailed examples, exercises, and quiz questions. What are Custom Formulas? Custom … Read more
Google Apps Script Web Apps: Comprehensive Guide Google Apps Script allows you to create web apps to interact with users via a browser interface. This guide covers creating, deploying, and managing web apps using Google Apps Script, with examples, exercises, and multiple-choice questions. What is a Google Apps Script Web App? A web app built … Read more
Google Apps Script for Google Forms: Comprehensive Guide Google Apps Script for Forms enables you to automate and customize Google Forms by creating forms programmatically, managing responses, and integrating them with other Google Workspace apps. This guide includes examples, detailed explanations, exercises, and multiple-choice questions to help you master Google Forms automation. What is Google … Read more
Removes both multi-paragraph and single-paragraph language-specific text patterns from a specified Google Document In the ever-evolving landscape of content creation, efficiency is paramount. Whether you’re a developer documenting your code, a blogger crafting tutorials, or a student compiling research, managing and formatting content within Google Docs can sometimes become a tedious task. One common challenge … Read more
1. Understanding the Current Behavior If the current project relies on the absence of a date to determine whether a certificate should be sent, this logic works but may not be explicitly clear to the user. Adding a more deliberate mechanism like a “Processing Flag” column provides better control and transparency. 2. Adding a Flag … Read more
Script that displays a pop-up message if the user selects more than one cell at a time and tries to insert the date. This will help ensure users follow the intended workflow. Step-by-Step Guide 1. Set Up the Script function onEdit(e) { // Get the active spreadsheet and range const range = e.range; const sheet … Read more
Google Apps Script allows you to interact with external web services and APIs, enabling you to integrate your scripts with a wide range of online platforms and services. This chapter introduces RESTful APIs and demonstrates how to consume and interact with them using Google Apps Script. What Are RESTful APIs? Key Concepts Making HTTP Requests … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace applications. However, like any platform, it has quotas and limitations to ensure fair use and maintain performance for all users. Understanding these quotas and how to handle them is crucial for developing efficient and reliable scripts. Understanding Quotas and … Read more
Quick Recap: Adding Custom Formulas To add custom formulas to your Google Sheets, follow these steps: 1. Calculate Percentage Formula: =PERCENTAGE(value, total) This formula helps you calculate the percentage of a given value compared to a total. Usage example: Enter =PERCENTAGE(50, 200) to get 25. Explanation: The function simply divides the value by the total … Read more
How to Add These Custom Formulas to Google Sheets To recap, here’s how you add custom formulas to your Google Sheets: 1. Find Maximum Value Formula: =FIND_MAX(value1, value2, …) This function allows you to find the maximum value from a list of numbers. It can be handy when you need to quickly identify the highest … Read more