Skip to content Skip to sidebar Skip to footer
Showing posts with the label Google Apps Script

Convert Date Format Without Timezone - Google App Script (javascript), Google Spreadsheet

I'm working on integration between Google spreadsheet and LINE Message API (BOT) where Google a… Read more Convert Date Format Without Timezone - Google App Script (javascript), Google Spreadsheet

Datetime Error 21-undefined-2014

The code below results in: 21-undefined-2014 Not sure what is missing. Please check and advise. Eve… Read more Datetime Error 21-undefined-2014

Google Script - Get Data From Gmail Into Sheet

I have been looking around here on SO and on Google, but I cannot find anything that is working. … Read more Google Script - Get Data From Gmail Into Sheet

Parsing Xml Data Using Google Script

I have been trying to convert a xml feed into human readable form but have not succeeded . I have t… Read more Parsing Xml Data Using Google Script

Typeerror: Cannot Call Method "getrange" Of Null. (line 9, File "code")

I am using the below filter function to copy data from one sheet to another, filtering out so that … Read more Typeerror: Cannot Call Method "getrange" Of Null. (line 9, File "code")

Passing Information To Server-side Function In A Google Docs Add On

I'm working on a Google Docs Add-On based on Google's Quickstart tutorial. I'm trying t… Read more Passing Information To Server-side Function In A Google Docs Add On

Replacetext() Regex "not Followed By"

Any ideas why this simple RegEx doesn't seem to be supported in a Google Docs script? foo(?!b… Read more Replacetext() Regex "not Followed By"

Problem In Sending Email By Google Apps Script

I have been sending Email by Google Apps Script successfully for sometimes. However, when I open a … Read more Problem In Sending Email By Google Apps Script

Google Apps Script :: Is It Possible To Get The Cursor Position Or Get The Selected Text From Google Document

Is there any Google Apps Script API to get the cursor position or get the selected text from Google… Read more Google Apps Script :: Is It Possible To Get The Cursor Position Or Get The Selected Text From Google Document

Run App Script Function From Website/localhost

I'm really need help to running my function in google app script from my website/localhost. Alr… Read more Run App Script Function From Website/localhost

Notify Via Email When A Cell Is Updated In Google Spreadsheet

I am new to script and added this script which worked: function sendEmailAlert() { var ss = Sp… Read more Notify Via Email When A Cell Is Updated In Google Spreadsheet

Google Script - Copy Dynamic Range To New Spreadsheet

I'd appreciate some help on my first google script if possible. I'm trying to archive our … Read more Google Script - Copy Dynamic Range To New Spreadsheet

Converting A Google Doc To A Pdf Results In Blank Pdf, Google Scripts

Here is my code to create a google doc paste some information in (eventually from a spreadsheet), c… Read more Converting A Google Doc To A Pdf Results In Blank Pdf, Google Scripts

I Need To List All The Files In Subfolders Using Google Script

I am trying to make a summary sheet for all files in a folder. This is what I have so far, but I ca… Read more I Need To List All The Files In Subfolders Using Google Script

Supporting Arrays In Custom Functions With Multiple Inputs

I have a custom function in my google apps script that takes two variables. I want this function to… Read more Supporting Arrays In Custom Functions With Multiple Inputs

Capitalizing Cells In Title Case In A Google Sheets

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

Utilities.formatstring With Positive/negative Numbers

I want to display my numeric string data with a rich format, applying a different color when the nu… Read more Utilities.formatstring With Positive/negative Numbers

Pass An Array Of Json Objects From Google Sheets To Html Service

I have a spreadsheet with a number of hotel names along with addresses, phone numbers and contact n… Read more Pass An Array Of Json Objects From Google Sheets To Html Service

How To Run A Menu Item Script Across Selected Sheet Tabs

I have been trying to accomplish running this border script across only certain sheet tabs, and I h… Read more How To Run A Menu Item Script Across Selected Sheet Tabs

Correct Syntax For Onedit Trigger

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