Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Welcome to our latest tutorial where we dive into the power of Google Apps Script to make your life easier! 🌟 📽️ In this video, you’ll learn how to automate the creation of a Table of Contents (TOC) in Google Docs. We’ll walk you through a simple yet powerful script that dynamically generates a TOC … Read more
Sheets Column Data New Tutorial Alert! Master Google Sheets: Sorting Da… Are you tired of messy data in your Google Sheets? Struggling with unorganized lists that need sorting into neat columns? We’ve got you covered! In our latest tutorial, we dive deep into the magical world of Google Sheets and its powerful ‘Split Text to … Read more
YouTube Marketing QUIZ 25 Test your Knowledge! Are you ready to test your YouTube Marketing expertise? We’ve crafted an engaging 25-question quiz to challenge your knowledge and sharpen your skills in the dynamic world of YouTube marketing. 🌟 Quiz Highlights: This quiz is a fantastic tool for anyone looking to enhance their YouTube marketing strategies, … Read more
🎉 Excited to Kick Off 2024 with Ambitious YouTube Marketing Resolutions! 🚀 As we embark on a new year, I’m thrilled to share my resolutions as a YouTube marketer. Here are ten strategic commitments to enhance our channel growth, engage our audience, and stay at the forefront of the ever-evolving digital landscape: Here’s to a … Read more
Top 10 YouTube Marketing Tips 10 Top Tips to Dominate YouTube Marketing in 2023 Looking to take your YouTube game to the next level Looking to take your YouTube game to the next level? Whether you’re just starting out or looking to scale your existing channel, these 10 top tips will help you: Here’s a … Read more
In this Google Apps Script tutorial, we’ll explore how to automate email notifications when a specific cell in a Google Sheets document is edited. This can be a handy tool for staying informed about important changes in your spreadsheet data. The script utilizes the onEdit trigger, which is an event-driven function that runs whenever an … Read more
🌟 Simplify Your Data Analysis with Custom Google Apps Script for Average Ratings! 📊 Are you overwhelmed by the task of calculating average ratings from a multitude of responses to various questions? We’ve got you covered! In our latest video, we’re introducing a powerful Google Apps Script that automates the process, making it a breeze … Read more
Google Apps Script Examples of Custom Formulas in action in Sheets CONVERT_TEMPERATURES Temperature Conversion in Google Apps Script – How to Convert Celsius to Fahrenheit and Vice Versa 1 GENERATE_PASSWORD Generate Secure Random Passwords with Google Apps Script 9 Optimize Cost Calculations with Google Apps Script: Learn How! 15 Unlock the Power of Weighted Averages … Read more
In this example, we’ll create a custom formula that helps you analyze survey data by calculating the average rating for a set of responses. Scenario: You want to create a custom formula that calculates the average rating from a set of survey responses, where each response is rated on a scale from 1 to 5. … Read more
Custom formula to calculate the total cost of items with coupon discounts We’re diving into the world of cost calculations, discounts, and coupon codes using Google Apps Script. 📈 Introducing the “COST_PER_ITEM” function, a handy tool that allows you to effortlessly determine the cost of an item based on its quantity, price, and even the … Read more