Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
If you’re just getting started with Google Apps Script, don’t worry—each function is explained clearly, with details on how to use it in your Google Sheets to make your life easier. So, let’s dive into it! How to Add These Custom Formulas If you missed the steps on how to add custom formulas to your … Read more
Editing text in Google Docs can sometimes become repetitive and time-consuming, especially when you need to apply specific formatting to certain elements throughout the entire document. Luckily, Google Apps Script allows you to automate many tasks, saving you valuable time and ensuring consistency. Today, we’ll look at a script that does just that: it automatically … Read more
If you’ve ever had to manually edit paragraphs in a Google Doc, you know it can be a tedious task. For example, imagine working through a document where you must find every paragraph starting with “// Exercise X:” and convert them into proper headings. Not only is this repetitive, but it’s also easy to make … Read more
Formatting documents can be time-consuming, especially when you have a large Google Doc with numerous bolded paragraphs that need to be converted into specific headings. Fortunately, Google Apps Script allows you to automate this task with a few lines of code! This post will guide you through creating a Google Apps Script to find all … Read more
To remove blank paragraphs in a Google Document, you can use Google Apps Script to detect and delete paragraphs that contain no text or only whitespace characters. Here’s a simple script to accomplish this task: Step-by-Step Guide Script Code /** * Adds a custom menu to the Google Docs UI for easy access. */function onOpen() … Read more
When working with structured documents in Google Docs, you may find yourself needing to identify paragraphs that start with a number and a period (like “121.” or “15.”) and turn them into headings while removing the leading numbers. With Google Apps Script, you can automate this task, saving time and ensuring consistency across your document. … Read more
Adding a horizontal line with spacing above headings can make a document visually appealing and easier to navigate. This can be especially helpful in long Google Docs where distinct section dividers improve readability. Instead of adding these lines manually, you can automate the task using Google Apps Script! In this guide, we’ll walk through an … Read more
Blank lines in a document can clutter its appearance, making it look disorganized and harder to read. Manually going through a long document to remove these blank lines can be tedious, especially if you’re working with large or collaboratively edited files. Thankfully, Google Apps Script offers a quick solution to automatically detect and remove empty … Read more
When working on a collaborative document, it’s easy for different font sizes and styles to accumulate, especially if multiple people have been editing. If you’re looking to restore a consistent, clean appearance throughout your Google Doc, resetting all text to the default font size and style can help bring uniformity. Instead of manually changing the … Read more