Copy Data with function to a New Sheet

by

Copy Data with function to a New Sheet The purpose of this code is to add a custom menu to a Google Sheet that allows the user to copy the values of the currently selected range and paste them into a new sheet with a unique name. When the user clicks on the custom menu … Read more

Google Sheets Custom Formula Examples 35 coding example with source code and summary

by

Custom sheet functions using Google Apps Script Function to Calculate Average of a Range function AVERAGE_RANGE(range) {   var sum = 0;   var count = 0;   range.forEach(function(value) {     sum += value[0];     count++;   });   return sum / count; } Summary: This custom function takes a range of cells as input and returns the average of the values … Read more

Power Up with Google Apps Script

by

Introduction to Google Apps Script – why use it: Google Apps Script is a scripting language based on JavaScript that allows users to automate various tasks and workflows within Google Workspace applications. It is a powerful tool for automating repetitive tasks, customizing and extending the functionality of Google Workspace applications, and building lightweight web applications. … Read more

Users of Google Apps Script 

by

Users of Google Apps Script  The users of Google Apps Script are typically individuals or organizations who use Google Workspace applications like Gmail, Google Sheets, Google Docs, and Google Forms for their work or personal needs. Google Apps Script is designed to make it easier for users to automate tasks and workflows within these applications, … Read more

Common Uses for Google Apps Script

by

Google Apps Script is a scripting language based on JavaScript that allows users to automate various tasks and workflows within Google Workspace applications. Some of the common uses for Google Apps Script include:

Laurence Svekis Bio

by

Laurence Svekis is an experienced web developer, online educator, and entrepreneur with a passion for technology and innovation. He has been developing web applications and teaching programming courses for over 20 years, and has authored numerous online courses on various topics related to web development, including Google Apps Script and Google Workspace. Reaching over One … Read more

Google Apps Script Quick Start Guide

by

Introduction to Google Apps Script Getting Started with Google Apps Script Fundamentals of Google Apps Script Building Custom Functions Apps Script Integrating with Google Services Advanced Topics Google Apps Script Best Practices for Google Apps Script Conclusion Google Apps Script Sample code Google Apps Script and AI #GoogleAppsScript #GAS #GSuite #automation #scripting #webdevelopment #GoogleSheets #GoogleDocs … Read more

Randomize the order of an array in JavaScript

by

Randomize the order of an array in JavaScript To randomize the order of an array in JavaScript, you can use the following code: function shuffleArray(array) { for (let i = array.length – 1; i > 0; i–) { const j = Math.floor(Math.random() * (i + 1)); [array[i], array[j]] = [array[j], array[i]]; } return array; } … Read more

Google Apps Script Custom Sheet Formulas

by

Table of Sample DataFormula to calculate the average of the values in a given rangeSample table for the code with the given input values:Concatenate two strings and capitalize the first letterTable of sample data for the CONCAT_CAPITALIZE_FIRST function:Calculate the factorial of a given numberTable of sample data for the code:Count the number of occurrences of … Read more