Tagged Questions
Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
0
votes
0answers
13 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
9 views
get the id of the response google form script
var form = FormApp.openById('myGoogleFormID');
var response = form.getResponse(responseId);
function onSubmit() {
// Here I'd like to get the id of the current response
}
How do I get responseId ...
2
votes
1answer
17 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
15 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.
...
-1
votes
1answer
33 views
Google spreadsheet [on hold]
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.
...
1
vote
1answer
40 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
23 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
47 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
36 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
9 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
56 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
72 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
30 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
28 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
26 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 = ...