Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
Why Use Custom Formulas in Google Sheets? Google Sheets already comes packed with tons of functions, but there are times when you need something more specialized. Custom formulas allow you to simplify calculations, automate repetitive tasks, and introduce unique functionality into your spreadsheets. The best part is that creating these custom functions is easier than … Read more
Sorting a column of dates and times in a specific format, like “Sun, Jun 2, 2024, 11:42 PM,” can be a useful feature when managing schedules, logs, or any time-sensitive data. Google Apps Script provides a powerful way to automate this process. In this blog post, we’ll walk through the steps to write an Apps … Read more
Enhance the usability of your Google Sheets by adding custom menus and user interface components. This chapter guides you through the process of designing and implementing custom menus, dialog boxes, and other UI elements that make your scripts user-friendly and accessible to a broader audience. Enhancing the usability of your Google Sheets by adding custom … Read more
Book Source Code on GitHub https://github.com/lsvekis/Sheets-Custom-Formulas-Book Get the Best Selling Book Free for the next 4 days US https://www.amazon.com/dp/B0D59Q4J1T CAN https://www.amazon.ca/dp/B0D59Q4J1T 1 : Mastering Basic Custom Functions In this opening chapter, we introduce the foundational concepts of Google Apps Script for custom functions in Google Sheets. Begin by learning how to create simple functions that … Read more
Unlock the Full Potential of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Read the first 2 chapters Free at Amazon – Get your free Kindle version of the book today US https://www.amazon.com/dp/B0CXXLMMHQ Can https://www.amazon.ca/dp/B0CXXLMMHQ Over 200 Apps Script Coding Exercises here https://github.com/lsvekis/Coding-with-Google-Apps-Script/ In … 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
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