Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
0
votes
1answer
6 views
Google Sheets capture cell entered and cell selected
I am trying to capture, programmatically, the on cell entered and on cell selected but I don't seem to be able to find any documentation on it. I can get the time stamp for exiting the cell through ...
1
vote
1answer
40 views
How to export / import a Google Apps Script as a file into a new spreadsheet?
I fear this may have an obvious answer, but I've been knocking my head over this and can't find it!
When creating a new spreadsheet, we can easily create a script within it. I like to call it a ...
2
votes
2answers
25 views
How can I apply a script to every sheet but the first one on a spreadsheet?
I've been working on a shared Google spreadsheet on Google Drive. The document has different sheets with a "Last Modified Date" Cell. I found an script for this to be auto-filled searching here:
...
1
vote
1answer
59 views
Referencing cells above and to the left in script
I'm trying to make a script for a custom function in google spreadsheet to work out the hours worked in a day function hwtd(). I've got it perfect in the cell (((F8-E8)+(F9-E9))+(IF((F10<E10), ...
2
votes
1answer
79 views
Date and time stamp automatically added in column
We have a barcode scanner that we use to track student assignments. I am trying to create a Google Spreadsheet that tracks the assignments for each subject.
I have been using the following script:
...
0
votes
0answers
24 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
51 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 ...
1
vote
2answers
90 views
Google Spreadsheet; Function to Search a Sheet for String and Return Value of Next Column
Here is what I have so far. it will:
Search for keyword in my other sheet (JSON)
When it finds the keyword (modname) it returns the row #
The keyword is on the A column. What I want is for a ...
1
vote
1answer
55 views
Calculate score and ranking in Google Spreadsheet
I want to create a Google Spreadsheet which will work as a ranking system for a game.
One sheet, "Ranking", should display the current ranking of the players, based on their points.
Another sheet, ...
2
votes
1answer
27 views
Can I convert a MS Word document to a Google Document format using GAS?
I know how to convert a Microsoft Word document to Google Documents format manually (right click, open with Google Drive). But is there any way to do this using Google Apps Script? I have looked ...
0
votes
0answers
46 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 ...
1
vote
1answer
57 views
Get the Id of the response from Google Forms via a Google Apps Script
How do I get responseId ?
var form = FormApp.openById('myGoogleFormID');
var response = form.getResponse(responseId);
function onSubmit() {
// Here I'd like to get the id of the current response
}
...
2
votes
1answer
43 views
Place cell data from a Google Spreadsheet into a Google Document
I'm trying to populate an invoice.
I have a Google Spreadsheet that calculates hours per project, and I want to bring that into a Google Document, but despite much searching, have found no way to do ...
1
vote
1answer
24 views
500 error with Google admin sdk
I'm using the Admin SDK with Google Apps Script to create a directory of user's names and emails on a Google Site. The code seems to work fine because when I view the logs I see the results.
...
-2
votes
1answer
111 views
How do I conditionally format based on the value of cells in a column?
Unable to create a script. I would like to know if there is one that would allow me to color an entire row based on the value (a different color value) that I will find in the cells of column B.
For ...
1
vote
1answer
72 views
Using the Google Admin SDK
I'm trying to use the Google Admin SDK to get all of the users for a directory on our site but I'm trying to figure out what exactly page on line 4 of the code means.
function listAllUsers() {
...
0
votes
1answer
27 views
Google spreadsheet, sort adds a bunch of rows
I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like.
var kotlijst = SpreadsheetApp.getActiveSpreadsheet()
...
2
votes
1answer
66 views
Putting my company directory into Google Sites with pictures
I'm using this code to pull the name and emails of my users into an intranet page on Google Sites. I was just wondering, is there some code that I can add to this so I can retrieve pictures? I would ...
1
vote
2answers
55 views
Make a counter, that counts cell change
I have a cell, let us call it A1, that contains an IF function.
Cell A1 changes between two types of text:
Healthy
Injured
What I want is a counter in for example B1 that counts how many times A1 ...
0
votes
0answers
24 views
How to change Google Apps Script locale?
I created a Google Apps Script on the Google account, which had the Polish language set in the settings. Executing the script was causing some Google error message about exceeding quote Gmail rateMax, ...
1
vote
0answers
63 views
How to enable Drive Service in Google Apps Script? [closed]
I am getting this error The feature you are attempting to use has been disabled by your domain administrator.
When I try to use DriveApp in Google Apps Script.
The domain administrator tried to ...
2
votes
1answer
273 views
send HTML email from a spreadsheet using a different alias
I've been frolicking around sending emails from Google Spreadsheet.
The sent email has two requirements to fill:
It needs to be send from my work-alias
It needs to be as HTML
I can do the former ...
1
vote
0answers
33 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, ...
0
votes
0answers
54 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
votes
1answer
31 views
Help with a previous question you answered
I noticed this code from a thread I was reviewing as I neede the same functionality to provide a timestamp when a particular row is edited in a google spreadsheet;
function onEdit() {
var s = ...
1
vote
1answer
47 views
onEdit only updates top row after pasting (editing) multiple rows
I'm using a Google Spreadsheet and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
2
votes
1answer
134 views
Google Apps Script - exceeded maximum execution time
I'm currently developing a new spreadsheet for my company to make one of the tasks we do on a weekly basis more easier - the way it works is data is imported into this spreadsheet and then the scripts ...
1
vote
1answer
150 views
In Google Script, get the spreadsheet cell calling a custom function
In VBA for Excel, I can get the column of the cell making the call to a custom function like this:
ThisCol = Application.Caller.Column
What is the equivalent in Google Scripts?
I've been trying to ...
2
votes
1answer
134 views
Arrayformula with dates before and after
Here is what my spreadsheet looks like
I enter recurring weekly payments details in G,H,I,J & K (Name,Amount,Day of week, Start Date, End Date respectively). This arrayformula:
...
0
votes
1answer
54 views
Time Triggered Script to Change Cell Contents
What I want to do is for example:
A time will be manually entered into a cell say D3, when it is 20 minutes before this I want cell D1 to change to "20 MIN", WHEN IT IS 5 minutes before I want to ...
0
votes
1answer
64 views
Creating a document (e.g,, MS Word) attachment in Gmail from a spreadsheet script
I've created a document file in the spreadsheet script. What I want to do is, from the script, create an email message with the document file (NOT a PDF) as a Gmail attachment. I spent about 2 days ...
1
vote
1answer
97 views
Limiting Range in OnEdit Timestamp Script in Google Spreadsheets
I would like to be able to limit the range of cells being assessed by this script to the first column. Apply the timestamp to the last column and only have the script run on a specific sheet "Short ...
0
votes
1answer
184 views
How to apply formulas, validation to newly added row (using add more rows at the bottom not using insert)?
I have formulas and validation in columns D, E, L, M and N. I want these formulas and validation to be automatic whenever I add rows using the option "Add more rows at the bottom". Not using insert ...
2
votes
2answers
539 views
How do I create a multiple choice question in Google Forms based on spreadsheet data?
I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have ...
0
votes
1answer
107 views
How can I record the date/time when a new row is added?
I want to add a date value when a new row is added in Google spreadsheet.
I have seen the script on Add a 'creation date' value when a new line is edited, but I was not able to modify the code to my ...
1
vote
2answers
56 views
Google Spreadsheet - periodically stamp sheet contents
As the title, is there a way to have a "print" of the content of a sheet periodically?
i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a ...
3
votes
0answers
93 views
Color entire row based on the status in Column L [duplicate]
How can I make my spreadsheet look like in the picture below? Starting row 5, I want to color the entire row based on the status in Column L.
1
vote
0answers
83 views
Index Match Script for Google Spreadsheet
I'm making a scheduling database in Google Drive. On a second sheet in the same Spreadsheet I have all accounts listed in columns:
I would like on the 1st sheet to type in an account number in ...
6
votes
2answers
141 views
Custom data transpose?
I have an export for a group that composed of student/mentors. Everyone in the group is both a student and a mentor. I need to transform the data to have mentors with assigned students rather than ...
0
votes
0answers
171 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 ...
1
vote
1answer
283 views
How to use triggers with functions that require parameters from the spreadsheet?
I found a simple and great solution to retrieve JSON into a Google spreadsheet.
I want the function ImportJSON to update regularly via a trigger (event or time-based, I still haven't decided what I ...
3
votes
1answer
313 views
How can you add a conditional statement to a =QUERY function
How can I add a conditional statement (similar to an if elseif in .php) to the query listed below so that is will return columns D and E from Sheet2 if column C in the responses sheet == 1st or ...
1
vote
1answer
166 views
Google Apps Script: trying to get the id of a file, outputs an error
I have a folder and inside two spreadsheets. I can open the folder but when I try to get the id of the files inside I get this:
Im getting this error
TypeError: Cannot find function getId in ...
3
votes
2answers
214 views
How do I automatically expand a =QUERY when receiving submissions from a Google Form?
The Query below 'works' on a line by line basis (when manually filled down), but it does not 'autofill' down when new data is added to the 'responses sheet'. The data being added to the 'responses ...
0
votes
1answer
500 views
Script error trying to populate form drop down menu from spreadsheet
We are trying to link a list on a Google Spreadsheet to a drop down menu on a Google Form.
The twist is that this Google Spreadsheet list will be continuously updated and needs to automatically ...
1
vote
0answers
101 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 ...
0
votes
0answers
39 views
GAS: How to change all values of a neighbor column? (code not working)
I have a Google Apps Script which I want to use to do this: get the text of all cells of column G of my sheet, extract some data from this text (dates embebed in text) and put the result in the column ...
2
votes
0answers
364 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
84 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 ...
4
votes
2answers
891 views
How do I implement a script that creates a unique ID for a Google form submission?
I need to create a unique ID upon submission of a form which will be used as a project number for tracking. The number needs to be unique but not based on rows or other changeable data because ...
