Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
To create a Google Apps Script that bolds the start of a paragraph if it starts with “code”, “explanation”, or “objective”, and only bolds the first word while leaving the remaining content intact, you can follow the steps below. This script will iterate through all the paragraphs in the document, check if they start with … Read more
Creating a Google Apps Script to process Google Docs documents in the manner you’ve described involves using the Google Docs API provided within Apps Script. The script will: Here’s a basic script that accomplishes this: To use this script: Please note, when running scripts that modify documents for the first time, Google will ask for … Read more
To create a Google Apps Script that processes each row in a Google Sheet, checking the last part of a string in a specific column, and if that last part is all numeric, splits it off and copies it to the next column, follow these steps. This script assumes you want to check and process … Read more
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
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
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
You can create a Google Apps Script for Google Docs that converts any text element ending with a question mark to an H3 element. Here’s a basic example of how you can achieve this: Here’s how you can set up and use this script: This script will iterate through all paragraphs in the document and … Read more
How To update all the bullet list items in a Google Doc to use the HOLLOW_BULLET glyph type. This script will iterate over every list item in the document and change its glyph type to HOLLOW_BULLET if it is a bullet list item. This operation directly affects the appearance of list items in the document. … Read more
Mastering Digital Organization: How to List All Files and Their Folders in Google Sheets In the digital era, effective file management is a cornerstone of productivity. As our Google Drive folders become increasingly cluttered with documents, images, and various file types, finding an efficient way to catalog and navigate our digital files becomes paramount. Enter … Read more