Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
0
votes
1answer
37 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
22 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
40 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 ...
0
votes
1answer
42 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
1answer
19 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
87 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
37 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
113 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
94 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
116 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
108 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
48 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
131 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
140 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
46 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
22 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
156 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
43 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
314 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 ...
0
votes
1answer
78 views
“Authorization needed” in dummy web app
I'm trying to write a Google Apps Script web app, which will, eventually, populate a spreadsheet. However, I'm having a hard time getting started.
I have an HTML file:
<div>
<select ...
0
votes
0answers
71 views
Google Apps Script: how to get data from another sheet from the active spreadsheet? [duplicate]
I have a spreadsheet with several sheets, like this:
If I want to use the active sheet in the active spreadsheet, I use this method:
var s = SpreadsheetApp.getActiveSheet();
How do I use another ...
2
votes
1answer
110 views
Making all cells in a column links from the values within the cell?
I have a column of cells in a Google Spreadsheet with values such as:
512
2123
2342
3532
What I would like to do is convert all these into a hyperlink and keep the value as the link text:
...
1
vote
2answers
142 views
GDocs: Send Email Notification Based on Timeframe and a Given Email Address From a Cell?
How specifically does the code found in this article need to be modified to allow for a specified email address column to inform who the reminder should go to?
I have an example spreadsheet here with ...
4
votes
2answers
525 views
Pass range in Google Apps script custom function without using A1 notation
I'm new to Google Apps script and I would like to create a function for a spreadsheet that sums cell values when the cells meet certain criteria, such as the background color. Moreover, I'd like to ...
0
votes
0answers
47 views
Sending emails to specified end users
I'm trying to write a script to send emails from a google spreadsheet. My specifications are:
Send email upon form submit
Only send to email address listed on form
I have written a sendEmail ...
1
vote
2answers
203 views
Google forms script to delete responses counter
I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated.
My copy sheet function, and delete ...
5
votes
3answers
172 views
Cell reference with colour formatting
Is it possible to reference a cell in Google Spreadsheets so that cell where it gets displayed also displays it using the same text and cell colour formatting?
=A1
Will only reference dell's value. ...
1
vote
1answer
94 views
Run a custom script more than 20 times in Google Spreadsheet
I need a way of running a custom script more than 20 times in my spreadsheet. I'm creating a class assessment spreadsheet that will be used as a master across my school, and it needs to retrieve the ...
3
votes
1answer
213 views
Sum a column except current cell
Is it possible to sum all values in a column EXCEPT the value in the current cell? That is, the cell that is to hold the result.
With a normal SUM(E:E) command the result is #REF! with a Circular ...
1
vote
1answer
144 views
Dependent validation in Google Spreadsheets
Here's what I'd like to do. The first selection is Subject (as in a school course). There are 5 subjects. Then there are three sub-selections in drop down lists for each subject:
Subject
Test Type
...
1
vote
2answers
270 views
Show data from one sheet on another if date is today
I have a list of people responsible for data verification that are changing every day.
The schedule is on one sheet. And data verification is on another.
What I need is to show only responsible ...
1
vote
1answer
316 views
Can I copy row from one Google Spreadsheet to another based on certain criteria
I have a spreadsheet to track student loan outs:
Column A is the student name
Column B is how many loan outs they have received
Column C is the class period Column D is the teacher name
...
2
votes
1answer
178 views
Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet?
Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet? Some of the responses on one will be public and viewable by anyone, but others will be private.
0
votes
2answers
139 views
How do I link two Google Doc spreadsheets so that entering a numerical value in one cell of Sheet 1 produces an 'x' in the same cell of Sheet 2?
I know about the importRange function to link two sheets, but I wonder if there's a way so that when a cell's contents are imported to the second sheet, the second sheet will autopopulate the ...
2
votes
1answer
113 views
Grading a Google Spreadsheet by answers given in a Google Form
I'm currently working in a school and students answered a 50 question form on ICT Ability. The results of this form have been put into a spreadsheet and I have to order the names in terms of ability.
...
1
vote
1answer
499 views
Auto populate data in Google Spreadsheet from data in separate spreadsheet?
So, I'm in the situation where I have a Google Spreadsheet with people's names, phone numbers, addresses, etc.
Is it possible to, from another spreadsheet (not sheet, different workbook), search the ...
1
vote
1answer
344 views
Copy and Paste Cell Contents Once a Week
As per the title, I want to "move" the contents of a cell one column to the right once a week, specifically Sunday at 11pm
Must I use a script for that?
2
votes
2answers
103 views
Split, reorder, concat inline in Google Spreadsheets
I want to split a cell, reorder the pieces and recombine. How do I do that inline.
For example:
| name | reordered name |
| Page,Larry | Larry Page |
| Brin,Sergey | Sergey Brin |
...
1
vote
1answer
345 views
Panel with Vertical Scroll Bar that allows navigating to different worksheets
I am attempting to build a Script that would open a window with each worksheet I have in my spreadsheet, allowing me to click on the worksheet name to navigate to that sheet. I found the following ...
1
vote
1answer
74 views
Looking for ways to speed up a Google Spreadsheet Script
I am somewhat new to Javascript and very new to using it in Google spreadsheets. I have read that fewer calls to Google spreadsheet API speeds things up, but I feel like I have as few as possible at ...
-3
votes
1answer
212 views
Create a menu with the corresponding sub menu [closed]
I need a help with handler code for this google apps script: Handler for Menu
See screenshot:
3
votes
1answer
332 views
Colorize a cell in google spreadsheets based on cell data
I'd like to colorize a cell based on it's contents. 0 = red, 100 = green, and linearly interpolated between.
function LinInt(x){
var ss = SpreadsheetApp.getActiveSheet();
var cell = ...
1
vote
1answer
201 views
Data Ranges in Custom Google Spreadsheets Function
I'm trying to create a custom Function in Google Spreadsheets that takes a range as input parameter.
function Example(cells){
var values = ...
0
votes
1answer
144 views
Auto date added to adjacent cells when data is entered
I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this:
Column 1 would be "name"
Column 2 ...
1
vote
1answer
143 views
Duplicate check while creating Google Contact with Google Apps Script
I have the following code which creates Google Contacts from a Spreadsheet. The problem is whenever I run the code it creates contacts but has no functionality to check if the same Google Contact ...
1
vote
1answer
122 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.
1
vote
0answers
356 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
161 views
Pull Twitter Posts into Google Spreadsheets
I would like to set-up a Google Spreadsheet that automatically pulls Twitter search results into the cells. For instance, I'd like to search for "pizza" near "baltimore" and then have any pizza ...
1
vote
1answer
236 views
Changing an onEdit function to run onOpen
I have the function below (found online and adapted and it works) that is an on-edit function, but I want it to run/trigger when an import is done OR on open, as the data will not really be edited it ...
2
votes
1answer
159 views
In Google Spreadsheet, finding what formulas reference a given value
I would like to find out which cells have formula dependencies in a large spreadsheet. I am looking for a way to do something like OpenOffice
Tools>Detective>Trace dependents
and
Edit>Find ...
