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 elements in a Google Docs document that begin with any word from a given array of words, follow these steps: This script searches your document for each word in the searchWords array. When it finds an occurrence of any word, it applies bold formatting to that word. … Read more
To create a Google Apps Script that removes a number located directly after the word “Question” and before a colon (“:”) in a Google Docs document, follow these steps: function removeQuestionNumber() {var body = DocumentApp.getActiveDocument().getBody();var text = body.getText();var paragraphs = body.getParagraphs(); for (var i = 0; i < paragraphs.length; i++) {var paragraphText = paragraphs[i].getText();// Check … Read more
Creating a Google Apps Script to remove blank lines from a Google Docs document is a great way to clean up and streamline your document. Here’s how you can write a script for this purpose: Here’s an example script: This script iterates through all paragraphs in the document in reverse order (to avoid indexing issues … Read more
Creating a Google Apps Script to modify a Google Docs document so that any paragraph starting with a certain word is changed to a Heading 1 is a useful way to automatically format your document. Here’s a basic script to get you started: Here’s an example script for this purpose: In this script, replace “YourWord” … Read more
Here’s an example script that you can use as a starting point. This script will look for lines that contain only a specific value (e.g., “REMOVE_ME”) and remove them: Remember to replace “REMOVE_ME” in the script with the actual value you want to remove. This script checks each paragraph in the document; if the paragraph’s … Read more
🌟 Begin Your Journey with Google Apps Script! 🌟 50 Coding Exercises Dive Deeper into Google Apps Script with New Challenges! 💡 Embark on your scripting journey today and discover the endless possibilities! 🔥 Hot off the press: 50 coding exercises for Google Apps Script enthusiasts! These exercises delve into advanced scripting techniques, from automating … Read more
Apps Script Code Exercises 🌍 Expand Your Web Capabilities with Google Apps Script’s Content Service! 🌍 Google Apps Script’s Content Service 🌍 Expand Your Web Capabilities with Google Apps Script’s Content Service! 🌍 🚀 Just released: 10 must-try coding exercises to master the Content Service in Google Apps Script! Dive into creating web apps, serving … Read more
Apps Script Code Exercises 🌐 Transform Your Google Apps Script Projects with HTML Service! 🌐 Apps Script HTML Service Coding Exercises 🌐 Transform Your Google Apps Script Projects with HTML Service! 🌐 🚀 Dive into 10 engaging coding exercises to master the HTML Service in Google Apps Script! These exercises will guide you through creating … Read more
Apps Script Code Exercises 🌟 Elevate Your Google Sheets with Custom UIs! 🌟 Apps Script User Interface Coding Exercises 👩💻 10 hands-on coding exercises for mastering Google Apps Script’s User Interface capabilities! These exercises range from simple alerts to complex interactive UIs, empowering you to enhance your Google Sheets with custom dialogs, sidebars, and menus. … Read more
Apps Script Code Exercises 📧 Automate Your Gmail with Google Apps Script! 📧 Google Apps Script Mail Service Coding Exercises 🚀 10 innovative coding exercises to master Google Apps Script’s Mail Service (GmailApp)! From sending emails with attachments to organizing your inbox with labels and filters, these exercises are designed to enhance your email automation … Read more