javascript dox

Google form checkbox question combines the selected responses into one column separated by commas. … Read more Apps Script - Splitting Google Form Checkbox Answers By Commas

The class setBackgroundRGB() works if I pass it a literal setBackgroundRGB(255,255,255); but if … Read more Setbackgroundrgb Not Accepting String

I am currently writing a function for this myself, could not find an existing function in the googl… Read more Is There An Existing Way In Google Script To Check If An A1 Notation Is In Range Of A Second A1 Notation

So, I have a Google Form that outputs the data to a Spreadsheet. I have written some code for the o… Read more Google Form + Apps Script Onedit

I have created a public Web App with access to my private spreadsheet data. I can catch and log exc… Read more Unhandled Exceptions In Google Apps Script

Very new to the Google Sheets script editing, but I'm trying to move rows between sheets. I'… Read more Google Sheets - Moving Row To Another Sheet Based On Specific Column

Spreadsheet-1: Data present in Spreadsheet-1, Name apple android windows linux Germany … Read more Delete Blank Rows In Spreadsheet Using Google Script

i wrote simple code to get some information from the facebook graph api function event_host(url) { … Read more Google Script Error - Urlfetchapp With Facebook Graph Api Brings To Many Urlfetch

When in column O cell is mentioned 'Shipped' I want to send emails in column C (with corres… Read more Onedit Need To Send Emails From A Column

I have the following code in my Google Apps Script which gets data from my Google Spreadsheet, and … Read more .setnumberformat Is Not Working In Google Apps Script

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 previous asked on Stack Overflow how I could import data from another Google Sheet using Google S… Read more How To Import Data From Another Google Sheet Using Google Script Without Using Spreadsheet Id (july 2020 Update Stopped My Code Working)

The following code works successfully to compare column A of sheet 2 with Column B of sheet 1, any … Read more Compare Sheet 1 To Sheet 2 And Output To Sheet 3. Google Sheets. Javascript

I've been struggling with a piece of script I wrote in a Google Sheet. The purpose of the scrip… Read more .setvalue() Not Consistently Working For Google Sheets Script

I use Google Spreadsheets' built-in form functionality to build contact forms on my website. No… Read more How To Bold Specific Text Using Google Apps Script?

I have 4 sheets in the same spreadsheet: 3 per employee (Elisa, Miriam, Victor) and 1 for archive (… Read more Archive Rows From Different Sheets And Remove Them To Initial Position (to Initial Sheet) When I Want To Unarchive (google Sheets)

I need to loop through all rows/columns in a sheet and remove rows contain certain words. Ideally, … Read more Google Spreadsheets Script To Delete Any Rows Where A String Is Found

I don't know if this method is correct but I' trying to learn how to parse data content. I … Read more Parse With Firebaseapp For Loop

I want to capitalize the first letter of each word that gets entered into cells. I don't know a… Read more Capitalizing Cells In Title Case In A Google Sheets

I keep getting a message that the parameter is not defined. What am I doing wrong? I am new to Goog… Read more Parameter In E.parameter Is Undefined