Youtube

Custom formula to calculate the total cost of items with coupon discounts

by

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

Temperature Conversion in Google Apps Script – How to Convert Celsius to Fahrenheit and Vice Versa

by

#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

by

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 Google Apps Script custom formula

by

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

Extracting Domain Name from URLs: A Tutorial

by

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

Convert Values to Roman Numerals in Google Sheets with Custom Formula

by

Convert a number to its Roman numeral equivalent function TO_ROMAN(num){  if(typeof num !== ‘number’) return NaN;  let roman = ”;  const romanValues = {    M: 1000,    CM: 900,    D: 500,    CD: 400,    C: 100,    XC: 90,    L: 50,    XL: 40,    X: 10,    IX: 9,    V: 5,    IV: 4,    I: 1  };  for(let key in romanValues){ … Read more