Google Apps Script is a scripting language based on JavaScript. It allows for the creation, editing, and deletion of Google Docs, Spreadsheets, Calendars, etc.
2
votes
1answer
97 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 ...
3
votes
2answers
98 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 ...
10
votes
1answer
115 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 ...
5
votes
1answer
31 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 ...
5
votes
2answers
95 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 ...
1
vote
2answers
971 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
280 views
6
votes
2answers
5k views
Easier way to place Google map in Colorbox?
I need to place a Google map in Colorbox overlay and wonder 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 hiding ...
3
votes
1answer
121 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 ...
5
votes
2answers
195 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 ...
0
votes
1answer
82 views
Cleaning up Google Spreadsheet archiving script
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
1answer
75 views
Can I reduce the bloat in my Google Spreadsheet form script?
Long story short I feel my code should be able to be reduced a whole lot, I just don't know how.
The form updates a spreadsheet with agents(employees) hours worked for a specific date. The form has 4 ...
2
votes
1answer
56 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. ...
6
votes
1answer
131 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 ...
