Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.

learn more… | top users | synonyms (1)

3
votes
1answer
168 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
3
votes
1answer
567 views

Looping through the range of cells to test the dates

I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match. It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
2
votes
1answer
529 views

Automatically create a new row each day, on top of older rows

I am looking for a way to automatically create a new row on top of older rows each day. Inside of this row should be the current date.
2
votes
1answer
748 views

If cell equals a value then move row to different Google Spreadsheet

I've got a script that sorts a Google Spreadsheet when a value in a column is changed. I'd like to add to the script the following functionality: If the value for column E = "Complete" then the ...
1
vote
1answer
988 views

Send an email with attachment using Google Apps Script

I have a Google Spreadsheet with a list of emails. I want to build a routine that send email automatically to those email addresses. I also want to attach a PDF to this email. The PDF file is located ...
1
vote
1answer
160 views

How to send cell as argument for function?

I am trying to write a custom function for Google spreadsheets that checks the formatting of a given cell and acts accordingly. I know that I can give a string as argument and get it to work but then ...
4
votes
0answers
174 views

GmailApp service for consumer Gmail accounts?

I successfully set up Gmail Snooze in my google apps accounts (for work) and I like it so much that I want to set it up for my personal email, too (@gmail.com). I followed all the same instructions, ...
3
votes
0answers
886 views

Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger

At the end of each row filled in, using a custom Google Form, I'm adding three more columns: Date of creation Unique ID QR code (it is a list of computers) Unique ID and QR code are unique. QR ...
2
votes
0answers
37 views

Save daily to my Gmail in Google Sheets

Right now what I have is this in a Google sheet for my company daily lunch program: function sendLunchPerkSummery() { var d = Date(); var file = ...
2
votes
0answers
81 views

Batch Hiding Function in Google Script

I wrote a function that iterates through every non-blank row in the sheet, checks the value of a certain cell, and then if that cell matches my criteria its row number is added to an array. I then ...
2
votes
0answers
71 views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
2
votes
0answers
99 views

How to make script slow down in GoogleSheets Script Editor?

I have a script thats attached below, and the problem I'm facing is that after it has keyed in "ticker" to Raw Data in b1, my entire sheet is never done loading and thus when its time to check if it's ...
2
votes
0answers
607 views

Apps Script Webapp accessing Google Spreadsheet gets #VALUE! on every cell

I have a Google Spreadsheet with a couple of sheets that get data from other spreadsheets via ImportRange function and then calculate numeric values based on that data. Then, I assembled a code ...
1
vote
0answers
63 views

Google Apps Gmail Dual Delivery with Outlook Sync

We are in the process of migrating three email accounts from a cPanel web-hosted server to Google Apps Gmail. With this, these users exclusively use POP3 to check their email using Microsoft Outlook ...
1
vote
0answers
37 views

onEdit Script to auto run Filter on a tab

I'm trying to find a script that will run in a particular way, see below: it runs on a specific tab in a spreadsheet needs to either re-run a filter that i have in place on the tab OR can filter out ...
1
vote
0answers
121 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
1
vote
0answers
80 views

Trello API: How to remove a member from an organization using Google Apps Script (GAS)

In a Google Spreadsheet, I have a list of Trello usernames that I want to remove from my Trello organization. How can I use the Trello API to remove all these members from my organization? I found ...
1
vote
0answers
37 views

Send email from Google Spreadsheet to adress in column

From an existing Google Spreadsheet; every time a value is added in column M(x), I would like to send an email with a specified text to the address listed in column F(x) from the same row x. Which ...
1
vote
0answers
56 views

Google Apps Script with forms to check if a doc url is 'shared'

Does anyone know "IF" it is possible to use Google Apps Script with a Google form to auto check "IF" a document URL pasted into the form is a "shared" document? I'm a teacher and I use Google forms ...
1
vote
0answers
106 views

Can I make a Google spreadsheet deploy as a web application?

Well, this is what I'm planning to do: my spreadsheet looks almost done to me (a few changes here and there of course, but that'll continue forever). I want to deploy it as a web-app and then who ...
1
vote
0answers
89 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
1
vote
0answers
107 views

Automatically create a calendar document using Google Drive and Google Apps Script

I have a question regarding Google Docs and Google Apps Script. Is it possible to use Google Apps Script to 'automatically' create a calendar document in Google Drive with the following document ...
1
vote
0answers
121 views

Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
1
vote
0answers
252 views

How to build a decision suport app with Google forms or other Google Apps Script resource?

I want to create an app which helps newbie employers to take some decisions. So, using their answers to a form, the app asks new questions based on previous responses, something similar to a decision ...
1
vote
0answers
152 views

setDataValidation in google script not working

Have a problem with setting data validation rules in a google spreadsheet using apps script. Below are two functions, one is an onChange function which will be triggered whenever a user changes the ...
1
vote
0answers
483 views

Google Docs Forms: Create Checklist Item with adjacent Textfield

Using Google Docs Forms, I'd like to create a checklist with a "quantity" and "comments" textfield adjacent to each checklist item. Is it possible to do this without writing a custom script?
1
vote
0answers
463 views

Google Apps Script: copy document comments?

I'm working on the following script, which is supposed to look at the current document, grab its comments, make a copy, and copy the comments to the new document. However, I seem stuck. I'm not ...
1
vote
0answers
79 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
0answers
732 views

Google Apps Script UrlFetchApp and password protected pages

I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
1
vote
0answers
458 views

Set a Category Filter in a Google Spreadsheet Line Graph

I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
1
vote
0answers
229 views

Google Docs: Script Project is not editable for anyone

I created a new Script Project in Google Docs with the following sharing settings: "Anyone who has the link can access. No sign-in required." - "Edit access: Allow anyone to edit (no sign-in ...
0
votes
0answers
11 views

Adding add an option to context menu in Google Drive

I'd like to be able to add an option to the context menu that appears when I right-click on a file or folder in Google Drive. I would connect this to a Google Apps script that would recursively ...
0
votes
0answers
8 views

capture & Log Range into new sheet on a weekly basis

I'm using =IMPORTHTML to import a set of values into a spreadsheet and I would like to have those values captured and stored in a different sheet once a week. I'm not all that familiar with scripts ...
0
votes
0answers
20 views

Manage time series in Google Sheets

I'm working a data sheet that models some goods cost and benefit across a number of years. I have some values in a grid where row is a data point name and column is the year, relative to buy time. | ...
0
votes
0answers
22 views

Trying to convert “=importhtml” to UrlFetchApp.js

I'm trying to replace my cell which is =importhtml into a .js for Google App Script. The current function in Google Sheets now is =importhtml("http://www.gurufocus.com/financials/"&'Raw ...
0
votes
0answers
35 views

How can I get the response ID of the person opening the form in the onOpen function in Google Forms?

I am using the following code in hopes of getting the responseID for the user who is editing their previous response to a Google Form. The problem is that the ID appears to be related to the ...
0
votes
0answers
85 views

Google Sheet Script: “=ImportFeed” does not run if spreadsheet opened by a background script (time-driven trigger)

I have a "History" sheet which will forever store anything that has ever been in the feed and a "Feed" sheet for the current imported feed (i.e. it just contains =ImportFeed) This Google Script runs ...
0
votes
0answers
73 views

Getting error while using a Google Forms/Spreadsheets Auto-Increment Script

Similar to Kelly's problem here: Can I add an autoincrement field to a Google Spreadsheet based on a Google Form? I need to create a unique ID upon submission of a form which will be used as a case ...
0
votes
0answers
77 views

Pull data from one sheet (has a locked cell) to another sheet (has a locked cell) every day automatically?

I have a dynamic Google spreadsheet to which I add one more sheet every day. I want to take the data from sheet1 cell D96 (a protect cell) to sheet2 cell D3 (a protect cell) every day. I found a ...
0
votes
0answers
67 views

Sort all sheets by column 1 in first sheet

I’m trying to sort or autosort an extensive Google spreadsheet with various codepending sheets. I have tried to use the sort function but that is to blunt to use in this case. I’m hoping to get some ...
0
votes
0answers
193 views

Google apps script for text documents: regexp replace to footnote / link

Using Google apps script, in a google text document (i.e. just a regular documenet), I would like to convert the following string { some text | footnote | link } to some text with a ...
0
votes
0answers
73 views

How to create a simple dialog form in Google Spreadsheets with GAS

The functionality that I am going for is this: Click on a menu option Interactive box comes up with 6 textboxes that correspond with a label each In two of those boxes, at most three, a number is ...
0
votes
0answers
152 views

Google apps script authentication

I am an admin on two Google Apps accounts. I was looking for a way to auto force users to change their password every x number of days when I found this post: ...
0
votes
0answers
331 views

Running a Google Web App Script in a Google Site on iPad 'X-Frame-Options' error

I have written a Google Web App Script that is embedded in a Google Site. It runs fine on desktops (bar Firefox on Mac, actually. Anyhow...), but not on an iPad in Safari / iOS 7.0.4 (it's fine on iOS ...
0
votes
0answers
115 views

Pass range in Google Apps script custom color sum function without using A1 notation

I want to sum up lines with Google Spreadsheets where the cells have a certain color. Since it needs to be copied down I want to have a function that doesn't use the A1 notation. There is already a ...
0
votes
0answers
64 views

How do I sort forms individually based on individual events in Google Forms?

My purpose is to conduct 5 events, namely 1,2,3,4,5 say ... I'm using a Google form to accept responses from people. Emails are sent to people automatically and they can register for more than 1 ...
0
votes
0answers
364 views

Prefilled Google Forms with Google Spreadsheet Data

I'm looking for a way to 'pre-fill' a Google Form with specific data from a Google Spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question ...
0
votes
0answers
498 views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
0answers
152 views

Download list of contact information and check if Google Account

I'm looking for a way I could: retrieve a list of all my contacts and their email's and In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
0answers
158 views

Create new document within spreadsheet and link

I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.