Profile

Cover photo
Eric Koleda
Works at Google
Attended Colgate University
Lived in Brooklyn, NY
4,036 followers|1,019,781 views
AboutPostsPhotosYouTube

Stream

Eric Koleda

Shared publicly  - 
 
You can use the new Drive advanced service to get and set comments on your files. See my response to this feature request for sample code showing how to add and list comments.
13
Add a comment...

Eric Koleda

Shared publicly  - 
 
One of add-ons that launched yesterday was Date Add and Subtract, a sample add-on we created on the Apps Script Developer Relations team. It provides a couple of custom functions for date manipulation and was built to show how you can move your custom functions scripts to the add-ons framework.

The full source code (there isn't much) is now available on GitHub: http://goo.gl/6N8Pdw. There is a wealth of custom functions in the Script Gallery that we would love to see start moving to the add-on store, so get cracking and fill our the add-on application form (http://goo.gl/qBCs09) when you've got something working.
11
5
Gerard Wijnands's profile photoGAS LibraryApp's profile photo
Add a comment...

Eric Koleda
moderator

News  - 
 
I can't wait to see the add-ons from this community!
 
The evolution of Apps Script is here!

With add-ons you can write code once, distribute it to millions of Docs and Sheets users in an eye-catching store, and push updates out seamlessly. All the tools you need to get started writing your own add-on are available today, but for the time being you'll need to go through a approval process before you can publish it. We can't wait to see what you create!
16
2
Eric Koleda's profile photoAaron Burg's profile photoGraham Bourne's profile photoGAS LibraryApp's profile photo
7 comments
 
+Joe Marino Yes, you can create domain-only add-ons. This will be very easy once add-ons are no longer in developer preview.
Add a comment...
 
A nice tutorial on how to use Apps Script to report on your MailChimp campaigns.
 
Blent Day 2: MailChimp API and Google Spreadsheets do it = automated reporting. +MailChimp +Google Apps Script Snippets  #mailchimpintegration
6
4
Matt Barger's profile photoGerard Wijnands's profile photo
Add a comment...
 
In case you missed it last week, it's now possible to show a sidebar in Google Sheets. We've had sidebars in Google Docs since I/O 2013, and now we've brought the feature to spreadsheets as well.

SpreadsheetApp.getUi().showSidebar(
    HtmlService.createHtmlOutput('Hello World'));

Be aware that sidebars (and the rest of the getUi() methods) are only supported in the New Google Sheets, which still has some known issues (http://goo.gl/C2tERO).
17
6
Katrin Kulesova's profile photoKeisuke Oohashi's profile photoAntonio Guzmán's profile photoGerard Wijnands's profile photo
3 comments
Add a comment...

Eric Koleda
moderator

News  - 
 
 
Heads up: We've just reduced the quota on the number of emails you can send per-day with Apps Script.

Consumer and non-paid Google Apps users are now limited to 100 email recipients per day, which is reflected on the Apps Script dashboard:

https://script.google.com/dashboard

We apologize for the sudden change, but it was required to protect our systems from abuse.

Your script can check how many more emails you can send for the day by calling MailApp.getRemainingDailyQuota(): http://goo.gl/1S2JaE.
6
3
Arun Nagarajan's profile photoAmit Agarwal's profile photoRiël Notermans's profile photoGAS LibraryApp's profile photo
9 comments
 
I just registered my account less than 1 month so I believe that is the issue (it takes some time to upgrade) and therefore I need to wait 6 months until my limits get increased:
"After upgrading to Google Apps for Business, it may take some time for the limits of your Google Apps accounts to be updated:

If your domain has six or more users, the peak limits will be eligible for update after the first complete billing cycle.
If your domain has fewer than six users, the peak limits might be lower for multiple billing cycles. The peak limits will be eligible for update after the domain has been cumulatively billed for the equivalent of six monthly user subscriptions."

This is really harsh. :S Simply because I don't want to register 6 e-mail addresses.
Add a comment...
Have him in circles
4,036 people

Eric Koleda

Shared publicly  - 
 
Apps Script now has advanced services for both Calendar and Drive. While CalendarApp and DriveApp gave you easy access to basic features, these new services give you raw access to the underlying API. This enables you to do things like set the colors of individual calendar events, list the revisions of a file, etc.
42
10
Niklas W's profile photoGDG Udine's profile photoRiël Notermans's profile photoAlexander Ivanov's profile photo
7 comments
 
No, still an open feature request to add support: https://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=2615
Add a comment...
 
The evolution of Apps Script is here!

With add-ons you can write code once, distribute it to millions of Docs and Sheets users in an eye-catching store, and push updates out seamlessly. All the tools you need to get started writing your own add-on are available today, but for the time being you'll need to go through a approval process before you can publish it. We can't wait to see what you create!
34
18
Federico Granata's profile photoDarren Neimke's profile photoDusty Wilson's profile photoGerard Wijnands's profile photo
2 comments
 
Love it!
Add a comment...

Eric Koleda
moderator

Tips & tricks  - 
 
Wanted to share a little code snippet I cooked up today. It provides a function you can use to determine if a given Position with a Google Doc is contained within a given Range. This can be useful when using the new NamedRange functionality we launched yesterday (http://goo.gl/eiCXXP) and want to determine if the user's cursor falls within one of those ranges.
7
Add a comment...

Eric Koleda

Shared publicly  - 
 
Tons of exciting new additions to Apps Script were launched today.
 
We are excited announce some new APIs and capabilities in Apps Script. Lots of great improvements to the Docs APIs, a new Properties Service and many other enhancements. 

One of our longer release notes in recent history - https://developers.google.com/apps-script/releases/
16
4
Eric Koleda's profile photoBill Wakefield's profile photoLen Marinis's profile photoLuke Medland's profile photo
2 comments
 
We have missed a few months, but glad to know they were appreciated!
Add a comment...
People
Have him in circles
4,036 people
Work
Occupation
Developer Programs Engineer
Employment
  • Google
    Developer Programs Engineer, 2009 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Brooklyn, NY
Story
Tagline
Member of the Developer Relations team at Google.
Introduction

I am a Developer Programs Engineer working primarily on Google Apps Script.

Education
  • Colgate University
    Computer Science, 2001 - 2005
Basic Information
Gender
Male