## Generate Secure Random Passwords with Google Apps Script

Title: “Generate Secure Random Passwords with Google Apps Script” Description: In this video, we dive into a Google Apps Script function that’s perfect for generating secure and random passwords. Whether you’re looking for strong passwords for your online accounts or want to enhance security in your applications, this function has got you covered. We’ll show … Read more

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

Title: “Temperature Conversion in Google Apps Script – How to Convert Celsius to Fahrenheit and Vice Versa” Description: In this video, we’re exploring a Google Apps Script function that simplifies the conversion of temperatures from Celsius to Fahrenheit and vice versa. Learn how to easily convert temperatures using this script. Hashtags: #GoogleAppsScript #TemperatureConversion #CelsiusToFahrenheit #FahrenheitToCelsius … Read more

## Building a Google Apps Script for Age Calculation

Title: Building a Google Apps Script for Age Calculation Description: In this tutorial, we’ll dive into Google Apps Script and build a custom function that calculates a person’s age based on their date of birth. Whether you’re a beginner looking to explore Apps Script or you’re interested in creating practical scripts for everyday tasks, this … Read more

## Custom formula to convert currency using real-time exchange rates

Amount From To Currency Exchange Total 100.00 USD EUR 50.00 USD GBP 2,000.00 USD CAD 300.00 USD CNY 136.00 CAD USD 50.00 CAD GBP 2,000.00 CAD IDR 300.00 CAD INR =GoogleFinance(concat(B2,C2:C)) Let’s break down the components of this formula: concat(B2, C2:C): concat is a Google Sheets function used for concatenating (joining) text strings together. B2 … Read more

## Unlocking the Power of Automation: A Beginner’s Guide to Google Apps Script

In today’s digital age, where efficiency and productivity are paramount, the ability to automate repetitive tasks can be a game-changer. Enter Google Apps Script, an incredibly versatile tool that empowers you to automate and extend the functionality of Google Workspace applications like Google Sheets, Google Docs, and Gmail. In this beginner’s guide, we’ll take a … Read more

## Future value of an investment using compound interest Google Apps Script Custom Formula

ðŸš€ 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

## Custom formula that generates a unique invoice number Google Apps Script custom formula

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

## Google Apps Script Speaking Events by Laurence Svekis

Google Apps Script is a JavaScript-based scripting language that automates tasks within Google Workspace apps. It enhances productivity, customizes app functionality, and builds simple web applications. The speaker’s experience began with a University project capturing tweets using Apps Script, which led to automating tasks like report generation. Benefits include streamlining workflows and collaboration. Common uses … Read more

## Create Apps Script custom functions How to get the total amount of items including the tax rate

How to get the total amount of items including the tax rate  CALC_TOTAL_AMOUNT Product Price Quantity Tax Rate Subtotal Total Amount Product A 10 5 0.08 4 54 Product B 20 3 0.05 3 63 Product C 15 2 0.1 3 33 Total 150 In this example, we’ll create a custom formula that calculates the … Read more

## Google Sheets get Data from two sheets to use within a custom function

How to use data from two sheets to create a custom Apps Script function  CALC_TOTAL_COST_WITH_TAX function getTaxRate(category) { const sheets = SpreadsheetApp.getActive().getSheetByName(‘TaxTable’); const taxTable = sheets.getDataRange().getValues(); let tax = 0 taxTable.forEach(val =>{ if (val[0] == category) { tax = val[1]; } }) return tax; } function test(){ Logger.log(getTaxRate(‘Category 1’)) } Category Tax Rate Category 1 … Read more