Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
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
#GoogleAppsScript #TemperatureConversion #CelsiusToFahrenheit #FahrenheitToCelsius #codingtutorials https://basescripts.com/temperature-conversion-in-google-apps-script-how-to-convert-celsius-to-fahrenheit-and-vice-versa 🌡️ Unlock the Power of Google Apps Script for Temperature Conversion! 🌡️ Title: “Temperature Conversion in Google Apps Script – How to Convert Celsius to Fahrenheit and Vice Versa” Are you tired of manually converting temperatures between Celsius and Fahrenheit? Let Google Apps Script do the heavy lifting! In … Read more
Understanding a Simple Currency Conversion Function in Google Apps Script In this video, we’ll dive into a simple Google Apps Script code snippet that demonstrates how to create a basic currency conversion function. Whether you’re a beginner looking to understand JavaScript functions or you’re interested in building currency conversion tools, this tutorial is for you. … Read more
Custom formula that generates a unique invoice number 📜🔢 Generating Invoice Numbers with Google Apps Script 🔢📜 In this video, we dive into a practical example of using Google Apps Script to automate the generation of invoice numbers. The GENERATE_INVOICE_NUMBER() function is a part of a Google Sheets project and serves a crucial role in … Read more
function GET_DOMAIN(url){ let domain = ”; let matches = url.match(/^https?\:\/\/([^\/?#]+)(?:[\/?#]|$)/i); if(matches && matches[1]){ domain = matches[1]; } return domain; } The given code defines a function called GET_DOMAIN that extracts and returns the domain name from a given URL. The domain name represents the network location of a website. The function follows these steps: To … Read more