Google Apps Script is a JavaScript cloud scripting language for automating tasks across Google products and third party services.
2
votes
0answers
4 views
Exporting unread mail details for further processing
As the result of some expert procrastination I have over 4000 unread mail in my gmail box. While that does not hold a candle to what some people likely have I wanted to try and do something about it. ...
-1
votes
0answers
15 views
Error Help for Google App Scripts- TypeError: Cannot read property “1” from undefined. (line 12, file “Code” [on hold]
I am a novice user and was having problems with my code compiling. I am getting the error "TypeError: Cannot read property "1" from undefined. (line 12, file "Code")." The problem is occurring on the ...
0
votes
0answers
3 views
Most performant filtering method for nested XML using Google Apps Script
Assuming a theoretical XML hierarchical file exported from an analysis tool thus:
...
2
votes
0answers
48 views
Protection for cells in Google Sheets
Is there some way to speed this up, since it keeps timing out while running?
The spreadsheet is shared with a Google Group with editing permissions. I've loaded what I can into memory but each ...
0
votes
0answers
24 views
Iterative Calculation
This Google Sheets script performs an iterative (circular) calculation to find values based on a gross percentage of project cost. Range names are used so that users can add/delete rows/columns and ...
1
vote
0answers
56 views
Join several columns with a single formula returning an array in Google Sheets
The title was taken from Join several columns with a single formula returning an array a Q&A hosted at http://webapps.stackexchange.com. The content is based on the original version of the answer ...
7
votes
2answers
385 views
Creates a menu and sidebar in Google Spreadsheets
In an effort to make my code more testable, I'm trying to make use of constructors and prototypes.
Here is a working Google Apps Script (GAS) for creating a new submenu under the Addon main menu in a ...
1
vote
1answer
104 views
Google App Script to calculate score card for a certain person, create PDF file, store to drive and email to person
I'd appreciate if someone could cast an eye over my dodgey coding and give me some feedback.
The use / purpose of the sheet/script is to quality grade calls, emails and chats with customers. A form ...
8
votes
1answer
64 views
Google Sheet with a column of names merged with Google Doc
I wrote my first script for google apps, but I am just learning how this all works. The script works fine, but I am sure there are things that are not done properly. Any advice is appreciated.
The ...
2
votes
1answer
55 views
Google Drive folders properties caching to file
I have the recursive function below to cache all the folders of my company Drive into a file. It works like a charm but takes too long, specifically >30 secs to read and save the 300 folders.
What I ...
3
votes
1answer
153 views
A1Notation conversion to row & column index
This set of Google Apps Script helper functions are published in this gist, along with a bunch of other utilities. Background info is in this SO question. Since no Google services are used, this is ...
1
vote
1answer
62 views
Combining 3 forms into 1, then writting data to 3 different sheets, with different layouts
Where I work, we have 3 forms for leavers: HR, IT and rota. Lots of questions are duplicated across all 3 forms.
So I thought, why not fill ONE form out, remove all duplicate questions, and simply ...
4
votes
2answers
195 views
Parse and format data on Google Sheets
This is a script that I use on a Google sheet for parsing data that has been pasted from various other software and getting it into the correct format and columns on another sheet. Data is pasted into ...
0
votes
1answer
53 views
Automating project budgets [closed]
I use this code in a GAS (Google Apps Script) to automate my project budgets.
Since every project has its own spreadsheet but all functions are in the same script file, being called as a library, I ...
4
votes
1answer
315 views
Transferring file from Google to Parse.com
I have created a system where user selects files from their Google Drive to be uploaded into Parse.
I have done so separately though, where I have one code that allows user to select an item from ...
5
votes
2answers
90 views
Script for keeping track of teams in a class
I wrote this script to help me keep track of who has worked together and for what project or discussion in my classes.
I make a Google Sheet with the names of the students going across the first row ...
5
votes
1answer
537 views
Exporting a table from Google Sheets and sending it via email
Basically is a script to export a table from Google Sheets and send it via email. But it's not a clean script, although it works.
If there is any way of making it more simple, or instead of get all ...
10
votes
1answer
2k views
Managing Google Calendar from Spreadsheet
Overview:
I have a need to manage a Google Calendar from a spreadsheet, so I developed a Calendar Manager program with Google Apps Script. I found some inspiration over on Stack Overflow, but my ...
7
votes
1answer
518 views
Google Apps Script for finding empty days on multiple calendars
I need help with a simple Google Apps Script I've written. The script finds days on which no all-day events have been scheduled, across multiple calendars.
I'm fairly certain the main issue is the ...
3
votes
2answers
326 views
Looping through selected cells to indent text
I have written the following Google Spreadsheet script that attempts to loop through all selected cells and then update the value so that it adds an indent, by adding
...
5
votes
1answer
194 views
Google Spreadsheet form script for employee work hours
The form updates a spreadsheet with agents (employees) hours worked for a specific date. The form has 4 pages, a first page where the date and office is picked. After which the form continues to one ...
3
votes
1answer
256 views
Entering address details into Google Maps geocoder
I have a Google Maps Geocoder and I am looking to refactor it. The user enters address details into a form where at the bottom there is the option to show on map.
First the map is hidden
The user ...
0
votes
1answer
129 views
Country data archiving script using Google Spreadsheet
I've just created a script in Google Spreadsheet in order to archive some things. I have data from four countries. If something is marked done, then that line could be archived into that country's ...
5
votes
2answers
519 views
Spreadsheet function that gives the number of Google indexed pages
I've developed this spreadsheet in order to scrape a website's number of indexed pages through Google and Google Spreadsheets.
I'm not a developer, so how can I improve this code in order to have ...
2
votes
1answer
63 views
Script for recording a country in which a company belongs
I have an Apps Script that is supposed to run through the spreadsheet, and if a company belongs to a certain country (there's a country column), set the value of the region row to something (e.g. ...
5
votes
2answers
155 views
Checking site uptime with Google Docs
I modified Amit Agarwal's script which checks the uptime of one website so that it now checks several sites. The script runs every 5 minutes, however, I kept receiving mails that a site was down and ...
2
votes
1answer
137 views
Google Apps Email, Contacts, Tasks, ScriptDB services integration
Please help me improve this Google Apps Script for reminding the user to contact people they haven't contacted in a while:
Purpose:
Creates tasks for you to contact people you haven't talked to for ...
1
vote
2answers
2k views
Markers on Google Maps
I am using PHP to get data from a MySQL database, and use the data to drop multiple markers into Google Maps. Please give me some suggestions for my code.
...
2
votes
1answer
348 views
6
votes
2answers
7k views
Placing a Google map in Colorbox
I need to place a Google map in Colorbox overlay and am wondering if there's a better way to do this. I've just started out with Google's tutorial so there's nothing fancy going on.
Right now I'm ...
