Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script Are you looking to boost your productivity and streamline your work in Google Workspace? Google Apps Script is your secret weapon! 🛡️ I’ve put together 25 multiple-choice questions to test your knowledge and expand your understanding of this powerful tool. Whether you’re a seasoned pro or just getting started, these questions cover … Read more
Google Apps Script Notify User on Edit of Sheet Here’s how you can set up this project: Remember to adapt the code to your specific use case and requirements. Google Apps Script can be used for a wide range of tasks, from automating Google Sheets to creating custom add-ons for various Google Workspace apps. function … 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
In this example, we’ll create a custom formula that calculates the total cost of items in a shopping cart, considering discounts based on a coupon code. Scenario: You want to create a custom formula that calculates the total cost of items in a shopping cart, taking into account discounts based on a coupon code. We’re … Read more
Title: “Generate Secure Random Passwords with Google Apps Script” Description: In this video, we dive into a Google Apps Script function that’s perfect for generating secure and random passwords. Whether you’re looking for strong passwords for your online accounts or want to enhance security in your applications, this function has got you covered. We’ll show … Read more
Title: “Temperature Conversion in Google Apps Script – How to Convert Celsius to Fahrenheit and Vice Versa” Description: In this video, we’re exploring a Google Apps Script function that simplifies the conversion of temperatures from Celsius to Fahrenheit and vice versa. Learn how to easily convert temperatures using this script. Hashtags: #GoogleAppsScript #TemperatureConversion #CelsiusToFahrenheit #FahrenheitToCelsius … Read more
Title: Building a Google Apps Script for Age Calculation Description: In this tutorial, we’ll dive into Google Apps Script and build a custom function that calculates a person’s age based on their date of birth. Whether you’re a beginner looking to explore Apps Script or you’re interested in creating practical scripts for everyday tasks, this … Read more
Amount From To Currency Exchange Total 100.00 USD EUR 50.00 USD GBP 2,000.00 USD CAD 300.00 USD CNY 136.00 CAD USD 50.00 CAD GBP 2,000.00 CAD IDR 300.00 CAD INR =GoogleFinance(concat(B2,C2:C)) Let’s break down the components of this formula: concat(B2, C2:C): concat is a Google Sheets function used for concatenating (joining) text strings together. B2 … Read more
In today’s digital age, where efficiency and productivity are paramount, the ability to automate repetitive tasks can be a game-changer. Enter Google Apps Script, an incredibly versatile tool that empowers you to automate and extend the functionality of Google Workspace applications like Google Sheets, Google Docs, and Gmail. In this beginner’s guide, we’ll take a … Read more