Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Introduction Google Apps Script is a versatile and powerful scripting language that allows you to extend and automate various Google Workspace applications, including Google Sheets, Docs, Slides, and Gmail. With its intuitive syntax and seamless integration with Google services, mastering Google Apps Script coding can significantly enhance your productivity and streamline your workflow. In this … Read more
Introduction In the dynamic world of web development, JavaScript plays a vital role in creating interactive and engaging websites. Whether you’re a beginner taking your first steps or an experienced developer looking to enhance your skills, mastering JavaScript coding is essential for building powerful web applications. In this article, we will explore the key concepts … Read more
The getBoundingClientRect() method in JavaScript returns a DOMRect object that represents the position and size of an element relative to the viewport. The properties of the DOMRect object include coordinates and dimensions, which are often expressed as floating-point numbers (decimal places). The reason getBoundingClientRect() returns decimal values is because it provides sub-pixel accuracy. In modern … 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
Count the number of occurrences of a given substring in a string function COUNT_SUBSTR(str,sbStr){ let count = 0; let pos = str.indexOf(sbStr); while (pos !== -1){ count++; pos = str.indexOf(sbStr,pos+1); } return count; } The provided code defines a function called COUNT_SUBSTR that takes two parameters: str and sbStr. The purpose of this function is … Read more
To install npm (Node Package Manager) along with Node.js, you can follow these steps: If the above steps were successful, you now have Node.js and npm installed on your system. You can start using npm to manage your Node.js packages and dependencies. Note: If you’re using a Linux or macOS system, you may need to … 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
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
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