Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,792
questions
7
votes
2
answers
9k
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?
...
- 173
42
votes
6
answers
203k
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 ...
- 784
6
votes
5
answers
26k
views
Force users to update password every 3 months for Google apps?
I manage a domain and I want to force all users to change their password every 3 months.
Is there a way to do this?
ajbdev
6
votes
1
answer
48k
views
Google Spreadsheet Timestamp? [duplicate]
I'm looking for some help with my Daily Work Log spreadsheet.
I've search and read many different version of making a "TimeStamp" in Google spreadsheet.
And it seems I don't have enough experience for ...
- 81
5
votes
0
answers
559
views
Preserve formatting when referencing cells across sheets [duplicate]
Is there a way to show the formatting of the referenced cells from another sheet in Google Sheets?
For example I have a sheet named balance with A1 having a comment and a blue background. When I ...
- 157
1
vote
0
answers
273
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 required)"...
- 11
3
votes
3
answers
9k
views
Parsing timestamp in Google Sheets 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 seven minutes after a ...
- 133
3
votes
1
answer
9k
views
How to Send Html Emails in Google Spreadsheet
Here's an example of a Google Docs Spreadsheet script that sends emails using Google spreadsheets. I want the email Sent in HTML not plain text. Can someone help me out?
function sendEmails() {
var ...
- 31
13
votes
2
answers
70k
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 ...
- 233
2
votes
1
answer
2k
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 ...
- 123
3
votes
3
answers
4k
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" ...
- 153
2
votes
1
answer
7k
views
How can I comment several dozen cells using data from cells?
I want to turn some long-winded strings into comments on nine sets of 96 cells so they're just visible on mouse-over.
How can I do this without manually going to Insert Comment and copy-pasting 864 ...
- 959
2
votes
1
answer
2k
views
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 to ...
- 153
8
votes
10
answers
37k
views
Importing data into a Google Forms response sheet
I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
- 357
43
votes
7
answers
70k
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 ...
- 541
10
votes
8
answers
12k
views
Automated solution to delete certain Gmail messages older than n days
I need to delete certain Gmail messages older than n days (I can get the whole set though a search string). I know this is not possible directly within Gmail (see for instance this question) so I am ...
- 423
2
votes
1
answer
4k
views
How can I make some data on a Google Spreadsheet auto-sorting using onOpen?
I was working with @W0lf here
but I am unable to comment/continue the conversation anymore.
I am trying to use autosort function onOpen but is not working:
function onOpen(event) {
var ss = ...
- 61
68
votes
3
answers
248k
views
Link to specific sheet in Google spreadsheet
I have a complicated Google spreadsheet with many sheets and a table of contents. Is there some way to create a link to the sheet names so that with a click one can go directly to the sheet? That is: ...
- 903
1
vote
1
answer
208
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 ...
- 2,205
13
votes
2
answers
62k
views
Calculating shaded cells
I am using Google Spreadsheets to create a matrix (time/activity) as a daily schedule for staff to sign into.
Is there a formula to calculate the number of cells in a column that are shaded (or not ...
- 131
57
votes
7
answers
74k
views
Can I get header numbering in Google Docs?
Is there a way to automatically number headings in Google Docs?
It used to be possible with CSS but this feature isn't supported anymore in the new Google Docs version.
- 727
32
votes
9
answers
49k
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 ...
- 1,461
2
votes
1
answer
1k
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?
- 1,116
31
votes
6
answers
47k
views
How to delete all events on many dates all at once but not the whole Calendar in Google Calendar?
How to delete all events on many dates all at once but not the whole Calendar in Google Calendar? I tried to click on a date that got an event to delete and dragged my mouse to 2 days after that date, ...
- 1,157
4
votes
1
answer
220
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, ...
- 451
1
vote
2
answers
2k
views
Is there a way to add a row to a Google Spreadsheet via a script?
I'd like to be able to call a script, which will add a row to a Google Spreadsheet, and manage stuff like user login. For example,
gdocs_addrow --id <doc-id> name="John Doe" age="31"
I know ...
- 119
21
votes
7
answers
78k
views
Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?
Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
- 669
6
votes
1
answer
2k
views
How do I reference existing formulas from custom formulas in Google Spreadsheet Scripts?
I want something essentially like this:
function contains(arg1, arg2) {
return NOT(ISERROR(search(arg1, arg2)));
}
But NOT and ISERROR are undefined even though using =ISERROR(...) works in the ...
- 283
2
votes
1
answer
3k
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, I ...
13
votes
3
answers
62k
views
In Google Spreadshets, how can you loop through all available sheets not knowing the total count?
I'm keeping stats for my daughter's baseball team. I have a sheet for each game, each one identical in structure. I want to create a summary sheet that totals numbers from the other sheets. How ...
user9904
22
votes
5
answers
50k
views
Is it possible to setup a filter in Gmail to delete message older than one month? [duplicate]
Possible Duplicate:
Webapp to delete certain Gmail messages older than n days?
The reason I need that is because I need to subscribe to some open source project mail list and I don't need to ...
- 345
1
vote
3
answers
13k
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 ...
user8797
4
votes
1
answer
2k
views
How to toggle every other column between visible/hidden in my Google Sheets?
I have a Google spreadsheet with my monthly balance sheet for my company. I keep track of estimated and actual like this:
Expense | Jan11 Actual | Jan11 Estimate | Dec10 Actual | Dec10 Estimate | etc....
- 193
6
votes
2
answers
11k
views
How can I use Google's functions in a spreadsheet's script?
When I use a function such as =importXml("http://www.google.com", "//a/@href") in a Google Spreadsheet cell, it works just fine. However, when I try to use the same function in a script, it gives an ...
- 30.7k
67
votes
13
answers
100k
views
How to pass a range into a custom function in Google Spreadsheets?
I want to create a function which takes in a range... something like:
function myFunction(range) {
var firstColumn = range.getColumn();
// loop over the range
}
A cell would reference it using:
...
- 30.7k
12
votes
3
answers
94k
views
Is it possible to use a loop in Google Spreadsheets?
I have the following document:
+---+-----------+
| | A |
+---+-----------+
| 1 | Foo (100) |
| 2 | Bar (30) |
| 3 | Baz (50) |
+---+-----------+
I'd like to use a REGEXEXTRACT to extract ...
- 30.7k
-1
votes
1
answer
824
views
Writing a spreadsheet script
The above link is a picture of the Google Docs spreadsheet that I am working on.
Basically it is a sale ticket for a small appliance parts store.
I need to be able to select a range of rows and have ...
- 7
10
votes
3
answers
5k
views
Can I print the Print Date or Save Date in Google Documents?
I've created a word processing document that will be used by many people (a style sheet for writers), and will also be updated periodically. I suspect that well have some who print the document out ...
- 1,405
41
votes
11
answers
159k
views
Is there any way to create a timestamp in a Google Spreadsheet?
I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.:
2010-07-17 23:45:44
Is there a way to do this in a Google Spreadsheet?
- 3,207
16
votes
4
answers
6k
views
Is there any way to script a Google Docs spreadsheet?
I have a really complex spreadsheet in Google Docs, and while it works, having the ability to script it a bit (à la VBA in Microsoft Office) would make it a lot cleaner. I heard that this is doable in ...
- 1,976
74
votes
8
answers
141k
views
How can I set conditional formatting on a particular cell that depends on another cell's value?
In my example I would like to conditionally format column B cells. Those marked with x should be formatted according to value in column A (in the example the value is 1):
A | B
1 | x
2 |
3 |
1 | x
...
- 2,205
10
votes
7
answers
29k
views
Function to find distance between cities
I'm working with Google Docs and want to create a spreadsheet of the following form:
Point A Point B Mileage
Los Angeles Miami 292100
Palo Alto San Francisco ...
- 209