Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Are you looking for a way to dynamically list files from a Google Drive folder, complete with file names, sizes, and links, that you can easily share on a website or embed in an HTML page? With Google Apps Script, you can achieve this efficiently. This blog post introduces a script function, listFilesInFolder(folderId), that generates … Read more
Why Update the Document Title? When translating a document, it’s easy to overlook the title. Updating the title ensures that the entire document, including its metadata, is fully translated, giving your audience a clear understanding of its purpose. It also improves organization and retrieval when searching through Google Drive. The Code to Update the Document … 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
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
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