Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
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
Google Apps Script Coding Examples #GoogleAppsScript #GAS #GoogleSheets #GoogleDocs #GoogleForms #GoogleDrive #automation #scripting #productivity #cloudcomputing #javascript Send Email using Gmail API function sendEmail() { var recipient = “john.doe@example.com”; var subject = “Test email”; var body = “This is a test email sent from Google Apps Script”; GmailApp.sendEmail(recipient, subject, body); } This script uses the GmailApp … Read more
How to add focus to a cell within Google Sheets using Apps Script You can add focus to a specific cell within a Google Sheets spreadsheet using Apps Script by using the setActiveRange method of the Range object. This method sets the specified range as the active range in the spreadsheet, which will give it … Read more
How to open the Apps Script Editor in Google Docs Apps Script is a scripting platform developed by Google that allows users to automate and extend various Google Apps, such as Google Docs, Sheets, and Forms. With Apps Script, you can create custom functions, automate repetitive tasks, and build powerful add-ons. To open the Apps … Read more
Google Workspace Tips Google Docs 25 Productivity Tips 25 Tips better productivity with Google Docs Google Sheets 25 Productivity Tips 25 Tips better productivity with Google Sheets Google Gmail 25 Productivity Tips 25 Tips better productivity with Google Gmail Google Calendar 25 Productivity Tips 25 Tips better productivity with Google Calendar Google Drive 25 Productivity … Read more
Google Slides 25 Productivity Tips 25 Tips better productivity with Google Slides
Google Gmail 25 Productivity Tips 25 Tips better productivity with Google Gmail
