JavaScript Test

edited from original I'm trying to figure out how to retrieve and report out details of calenda… Read more Retrieve Guest List From Calendar Issue, Google Apps Script (gas)

I have a Google Spreadsheet that I want to automatically set the value of a 'Date' cell whe… Read more How Do I Automatically Set A Google Sheets Cell To The Current Date On Editing Its Row?

I have a script which copys/clones an Google Spreadsheet and all tabs, which works fine but it I wo… Read more Copy A Spreadsheet File To Google Drive And Replace All The Formulas With Values

I am new to google scripts and I am not sure why I am experiencing such poor performances compared … Read more Google Script Loop Performance

I'm building a Google Spreadsheet-based app in Google Script. One of the things it does is outp… Read more Google Script: Attach A Script To A Dynamically Added Image In A Spreadsheet

I have the working code below that compares two sets of data from two different sheets. One is a li… Read more Java Script Optimization For A Google Apps Script

I'm trying to re-build COUNTIFS as a Google Scripts Custom Function and having trouble with one… Read more Accept Arbitrary Number Of Arguments In Google Scripts Custom Function?

I'm using a code to duplicate a template sheet with multiple range protections within it, Curre… Read more Duplicating Template Sheet Many Times At Once While Keeping The Range Protections

I'm writing a script that creates fixed-width-text output of the contents of a Google Apps Spre… Read more Formatting Numbers Read From Spreadsheet

So, I'm trying to read data from a cell in Google Spreadsheet's script and something's … Read more Google Spreadsheet Script Changes Comma To Full-stop Upon Reading From A Cell?

Part of my daily work is to send a range of cells of google sheet to the suppliers to request mater… Read more Is There A Way To Get Some Desired Range Of A Table To Send Email Based On The Value Of A Column?

I have the following code, the purpose of which is to try and get some useful insight into the last… Read more Google Apps Script Not Outputting Returned Results To Sheet

I have an extremely large column of data that I want to split into multiple columns of 1000 rows ea… Read more Splitting Single Column Into Multiple Columns 1000 Rows Per Column

I'm trying to figure out how to add a value to the last row in a specific column in Google Shee… Read more How To Find The Last Cell With A Value At The End Of A Column That Is Shorter Than Other Columns In Google Sheets?

The following function deletes rows in a Google sheet based on a specific value/item, I was hoping … Read more Challenge Looping Through An Array To Delete Rows In Google Apps Script

So I'm working on a script to search my Google Sheet for a value and then delete the row, so fa… Read more Google Sheet Script - Find Value In Col And Delete Row

I'm fairly new to JavaScript and could need some help with a problem I'm facing while worki… Read more Filtering An Array Based On Another Array In Google Apps Script

function timestamp() { return new Date() } The function recalculates every-time i open the sheet. … Read more Function Recalculates Every Time I Open The Sheet, I Only Want It To Recalculate On Edit

I'm trying to get an app that somebody else wrote to call the function each time the spreadshee… Read more Correct Syntax For Onedit Trigger

I am trying to execute a simple Apps script to retrieve data from my google sheet. However, I get t… Read more Bad Value When Trying To Execute Google Apps Script