Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
0
votes
0answers
23 views
Create sheets in a Google Spreadshet from an array
I need to create 50+ sheets in a Google Spreasheet from an array of strings, either with a formula or a Google Apps Script.
How would I go about accomplishing this?
0
votes
0answers
32 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
1answer
25 views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = ...
1
vote
0answers
63 views
How to share Company's directory with all users using Google Apps shared Directory?
I am using the code given in the answer to this question:
Is it possible to pull my Company directory into Google sites intranet?
However, as it specifies, it works for admin only. Would it be ...
1
vote
0answers
31 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 ...
3
votes
1answer
38 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
1
vote
1answer
45 views
Iterated variable (i) for argument on range in Google Scripts API
for (i=0; i<numItems; i++) {
var cell = sheet.getRange(12,i);
cell.setFormula(i);
}
This simple formula should go to every place on the column 12 where there is data, and replace it ...
2
votes
1answer
50 views
Google Spreadsheet Sort Two Columns
So I've found the following answer in regards to auto-sorting by one column, which works great
How can I make some data on a Google Spreadsheet auto-sorting?
However, my use case requires the sorting ...
0
votes
1answer
64 views
How do I Sum Thoughout Different Sheets
How do I create a reference to a defined interval in several sheets?
Something like this: =SUM(Sheet1:Sheet2!A1)
1
vote
0answers
64 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.
1
vote
0answers
59 views
Shared Google spreadsheet: enabling app script to run as author
I created a spreadsheet that I'd like to share with anyone with the url.
The sheet contains several app script functions. These functions both change the content of the sheet and copy data to another ...
1
vote
1answer
147 views
How do I automatically update a cell in Google Spreadsheets to the most recently entered in the same row?
I am trying to have one column that will show the most recent thing i entered in the row. Example: I want B2 to be the same as D2 but once I enter something in E2 I want B2 to display that. And then ...
1
vote
1answer
95 views
Why Gmail Meter is not working
I added Gmail Meter to my Gmail account but it never reported anything. Do you know what could be the matter? I worked to authorize and add the script, then I waited and nothing happened. When I go ...
1
vote
0answers
46 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
0
votes
0answers
122 views
How do I get an onEdit script to run on a Google Spreadsheet for all users
I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited.
The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
0
votes
0answers
20 views
autosort script troubles [duplicate]
autosort script from @wolf was working fine but no longer...
any thoughts?
function onEdit(event){
var sheet = event.source.getActiveSheet();
var editedCell = sheet.getActiveCell();
var ...
2
votes
0answers
358 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 ...
0
votes
0answers
106 views
How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet
I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.
Problem: I need to take multiple company names ...
0
votes
2answers
272 views
how do I get named ranges in Google Spreadsheets to be more reliable/current?
I'd like to pull values from a named range into a calculation. I have this function:
function getNamedRange(n){
SpreadsheetApp.getActiveSpreadsheet().getRangeByName(n);
}
Seems pretty simple. I ...
1
vote
1answer
67 views
How can I apply a script to only one specific sheet within a spreadsheet
I have a spreadsheet with two sheets called Robin and Lucy.
I've made/found/mangled a script to sort the data on the sheet each time I add some data to column A
function onEdit(event){
var sheet = ...
2
votes
1answer
1k views
How do I mail merge from Google Spreadsheet to a Google Document?
With Microsoft Excel and Microsoft Word, it is easy to merge rows from a spreadsheet into pages in a Word file. This was traditionally used to make paper mailings. How can I do the same with Google ...
3
votes
1answer
352 views
More Efficient Filtering Script
I'm exactly one day into writing Google scripts. I've managed to write one that will filter data in a spreadsheet with 24 columns and, for now, about 900 rows.
The problem is, it's slow. Any ...
0
votes
1answer
144 views
How to re-use Google Apps Scripts in new Google Spreadsheet
I'm having an issue. Whenever I create a new spreadsheet, I'm not able to add a script I've already created. The list for recent projects or scripts is always blank. Anyone have a resolution or do I ...
2
votes
1answer
146 views
Google Scripts : How to distinguish Empty cells from Zero
I want to count a number of specific responses from a form where the response can be left empty, zero or any other number 'd'.
The following code:
var data = sheet.getRange("B2:L").getValues();
...
3
votes
2answers
180 views
How can I make some data Autosort in a spreadsheet on edit?
I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B).
I have used the following ...
2
votes
0answers
163 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
0
votes
1answer
387 views
How do you add a custom font size in Google Spreadsheets?
How do I add a custom font size for a Google Spreadsheet I have? There are some defaults like 14pt, 18pt, 24pt and 36pt, but I would like to have a font size like 30pt, is it possible?
0
votes
2answers
144 views
Selecting Values from separate sheets and aggregating the results with google spreadsheet
I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am ...
3
votes
1answer
161 views
Google Spreadsheet text cell formatting question
I'm trying to create some sort of automated formatting for certain columns (except headers of course.) to take a string of numbers (and previous formatting; which should be stripped.) and format it as ...
3
votes
1answer
269 views
Creating a function that runs when a Google spreadsheet is opened
I want to create a function which runs automatically when the spreadsheet is opened. This function will make the selected cell the last cell without text in a certain column. Basically, I don't want ...
6
votes
3answers
407 views
Sorting data in Google Spreadsheet by cell entry
I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this:
Each student may sign up for more ...
1
vote
1answer
446 views
Is it possible to pull my Company directory into Google sites intranet?
We use Google apps for enterprise, and I want to build an intranet, based on the Google sites intranet template
In the Directory area, I want that the list will be updated from my contact/company ...
3
votes
1answer
430 views
Auto create and name new sheet in Google Spreadsheet
How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
1
vote
1answer
216 views
How can I dynamically format the diagonal cells in Google Spreadsheet?
I want all of the diagonal cells (A1, B2, C3, D4, E5, etc) of a Sheet to be formatted as Black Background, White Foreground. Is there any way to do this for a Sheet that constantly increases in size?
...
2
votes
2answers
3k views
How can I automatically set “last updated” cell in row Google Docs Spreadsheets?
How can I automatically set "last updated" cell in row Google Docs Spreadsheets ?
I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
3
votes
2answers
610 views
Parsing timestamp in Google spreadsheet with script
I have a spreadsheet with a form that timestamps every time the form is submitted. I'm writing a script to change the background color of the timestamped cell if it is more than 7 minutes after a ...
2
votes
1answer
303 views
How to Refresh a cell in Google Spreadsheet?
I have a column in Google Spreadsheet that calls an outside webservice using URLFetch in a Google Script. The cell uses two parameters in that cell's row. After a change occurs where those two ...
2
votes
1answer
175 views
Daily calculation and record insertion in Google Spreadsheet
I have a Google Spreadsheet that I am using to checkout last prices or levels of certain stock indices's. I have two worksheets in the workbook, one contains the indices's and a calculation I am ...
0
votes
2answers
779 views
Create a dropdown list of options from VLOOKUP
What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup.
Example
Here the data I'm using for reference. Notice "AAA" ...
2
votes
1answer
437 views
Google Apps Script - Want to email specific spreadsheet row data on event
Scenario
Basic support ticket clone:
Users submit a form (e.g. answering fault reporting questions)
Data is obviously stored as rows in the corresponding spreadsheet
I've added an onEvent trigger ...
4
votes
3answers
6k views
Alternating colors for lines in Google docs spreadsheet
I have a shared Google spreadsheet where several users have already filled out parts.
It would be useful to have alternately colored lines to facilitate correct placement of additional data.
Is ...
1
vote
1answer
130 views
Securing and sharing a non-web file (ie. PDF) on Google Sites site
I'm creating a really simple Google Site where I would like to share a free but valuable document with people. But I don't simply want to share it. I would like this to follow this process:
user ...
0
votes
2answers
780 views
Return an Offset Cell Value, Where Last Occurrence in Range is Matched
I have a worksheet like this:
|| A | B | C |
---++--------+-------+-----|
---++--------+-------+-----|
1 || 1 | a | |
2 || 2 | b | |
3 || 3 | X ...
7
votes
2answers
4k views
Text to columns conversion in Google Spreadsheets
How do you do a text-to-columns conversion in Google Spreadsheets?
For example, I have the following data string in one cell:
5,233,6,2,6,7,2,2,6,6
I want to break it apart by the comma separator ...
2
votes
2answers
126 views
Viewing all group contacts information in one page
Say I have 5 contacts in a group. I would like to see all their details in one page (/view), preferably separated by an horizontal line between every contact.
Is something like this possible?
13
votes
1answer
2k views
How to fix smilies in Gmail showing as “J”
Is there a way to fix smilies in received emails that looks like "J" in Gmail?
Other mail clients (such as Outlook) changes ":)" to smile character in Wingdings font that is letter "J". Although, in ...
3
votes
0answers
129 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
200 views
How can I get the body of a Gmail message before the quoted text with GmailApp? [closed]
I'm programming a little Google App Script for which I need to get the real body of an e-mail (using gmail services).
By real I mean the pure body of a particular message, without the text that ...
1
vote
1answer
371 views
Batch copying/renaming in Google Docs
I need to copy and rename a base form (a spreadsheet) to several other forms in Google Docs. Imagine I have the following form:
My Base Form - @name (@course)
After running the script or whatever, ...
1
vote
2answers
2k views
Parse HTML through Google Spreadsheet using scripting
I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting.
I remember Microsoft Excel had the import data function, but I don't own a copy ...
