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
via IFTTT
via IFTTT
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 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
Return the last number of characters of a string function LAST_VALS(str,num){ if(num >= str.length){ return str; } return str.slice(str.length – num); } The provided code defines a function called LAST_VALS that takes two parameters: str and num. The function returns the last num characters from the str string. Here is a detailed explanation of how … Read more
Remember, growing a YouTube channel takes time and effort. Be patient, adapt your strategies based on the feedback and data you receive, and continue to provide value to your audience.
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
