Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
“Mastering HTML5 Canvas with JavaScript: Draw Your First Line! #LearnToCode #JavaScript #HTML5 #WebDevelopment” Dive into the world of web development with our latest tutorial on HTML5 Canvas and JavaScript! In this video, we break down the basics of using the <canvas> element to draw graphics on the web. Follow along as we demonstrate how to … 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
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
🚀 Unlock the Power of Compound Interest: Calculate Your Future Investment Value with Custom Formulas! Ever wondered how your investments will grow over time with compound interest? In this tutorial, we’ll show you how to create a custom formula using Google Sheets to calculate the future value of an investment based on key factors like … Read more
Google Sheets Formulas Capitalize the first letter of each word in a given string function CAPITALIZE_WORDS(str) { const words = str.split(‘ ‘); for(let i=0;i<words.length;i++){ words[i] = words[i].charAt(0).toUpperCase() + words[i].slice(1).toLowerCase(); } return words.join(‘ ‘); } The given code defines a function called CAPITALIZE_WORDS that takes a string str as an argument. The purpose of the function … Read more
The given code consists of two functions: FACTORIALVAL and test1. Let’s break down each function and its purpose: FACTORIALVAL(val): This function calculates the factorial value of a given number val. It first checks if the val is equal to 0. If it is, the function immediately returns 1. This is the base case of the … Read more
Google Sheet Formulas Formula to calculate the average of the values in a given rangeConcatenate two strings and capitalize the first letterCalculate the factorial of a given numberCount the number of occurrences of a given value in a rangeCalculate the distance between two sets of latitude and longitude coordinatesCheck if a given string is a … Read more