Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
1
vote
1answer
198 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 ...
1
vote
2answers
3k 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 ...
12
votes
2answers
54k 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 ...
40
votes
7answers
42k 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.
32
votes
9answers
47k 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
1answer
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?
24
votes
6answers
37k 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, ...
4
votes
1answer
205 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, ...
1
vote
2answers
1k 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 ...
20
votes
7answers
67k 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?
5
votes
1answer
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 ...
2
votes
1answer
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 ...
-1
votes
1answer
1k views

How to create a filter in Gmail to delete old messages? [duplicate]

Possible Duplicate: How can I setup a filter in Gmail to delete message older than 1 month? Is there a way to get Gmail to delete messages from a particular user after a certain amount of time ...
22
votes
5answers
47k 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 ...
0
votes
3answers
9k 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 ...
4
votes
1answer
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....
4
votes
2answers
9k 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 ...
55
votes
12answers
66k 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: ...
-1
votes
1answer
808 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 ...
8
votes
3answers
4k 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 ...
35
votes
11answers
134k 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?
15
votes
4answers
5k 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 ...
72
votes
9answers
135k 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 ...

1
24 25 26 27
28