Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
To create an Apps Script that removes blank rows in a Google Sheet, you can follow the steps below. This script will scan through the sheet for any rows that are entirely blank and remove them. Here’s a simple script to do that: That’s it! Now you have a script that can remove all blank … Read more
To create a Google Apps Script for Google Sheets that processes a range of cells by taking each cell’s string value, separates it by the first comma found in the string, and then pastes the remaining part of the string into the following column, follow these steps. This script will iterate over a specified range, … Read more
To create a Google Apps Script that takes the value of a cell in Google Sheets, and separates the last two items in the string by a space, moving them to new columns in the same row, follow these steps. This script will loop through a specified range in your sheet, split the content of … Read more
Elevating JavaScript Skills: 10 Advanced Exercises for Modern Developers In an ever-evolving digital world, staying ahead in web development means constantly honing your skills and embracing the latest JavaScript features. This blog post delves into ten advanced exercises designed to elevate your JavaScript knowledge and coding prowess. From dynamic property management to code splitting and … Read more
In the dynamic landscape of web development, JavaScript remains a cornerstone, powering the interactive and seamless experiences users have come to expect. However, the depth of JavaScript’s capabilities means that there is always more to learn and master. This guide presents ten essential JavaScript exercises that will sharpen your skills, deepen your understanding, and prepare … Read more
Google Apps Script Multiple Choice Quiz 🚀 Unlock the Power of Google Apps Script with Our Comprehensive Guide! 🚀 Mastering Google Apps Script: A Comprehensive Guide Are you ready to unlock the full potential of Google Apps Script and revolutionize your workflow within Google Workspace? Look no further! In this comprehensive guide, we’ll dive deep … Read more
Are you looking to supercharge your productivity and automate repetitive tasks within Google Workspace? Look no further than Google Apps Script! In this comprehensive guide, we’ll explore everything you need to know about Google Apps Script, from its basics to advanced features. What is Google Apps Script? Google Apps Script is a powerful cloud-based scripting … Read more
Title: Automatically Convert Questions to H3 Headings in Google Docs Have you ever found yourself writing a lengthy document in Google Docs, only to realize later that you need to format questions differently to make them stand out? If so, you’ll appreciate this handy Google Apps Script function called convertQuestionToH3(). In this post, we’ll dive … Read more
Convert Docs content
To select the first sentence of each paragraph and check if it ends with a question mark, you can modify the script as follows: This script now splits each paragraph into sentences and selects the first sentence only. Then, it checks if the first sentence ends with a question mark and converts the entire paragraph … Read more