Flubaroo add-on for Google Sheets A favorite among teachers, Flubaroo is now even easier to use. With add-ons in Sheets, quickly grade and analyze student performance on multiple choice and fill-in assignments. Designed by a teacher, for teachers, Flubaroo is easy to use. Try it today for your assignments, quizzes, assessments, or even an exam. http://goo.gl/DralHr
"Eric Koleda originally shared: 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. "
Martin Hawksey's insight:
already some very cool looking add-ons like Amit Agarwal
"Choosing between Google Apps Script and Google App Engine is not always a clear choice. These two tools are not mutually exclusive in their functionality and could, in many cases, be used conjointly. Fundamentally, they are very similar. Both are platforms on which to build applications, both run within Google's infrastructure and both allow for integration into other Google services. Similarities abound."
"Quick update - going forward sidebars in Google Docs and Sheets will be forced to be 300px. If you have code that sets width of a sidebar, that call will be ignored. Please update your UI accordingly. This change has already been rolled out to new Sheets and will be in Docs next week. If you were never setting width, then you'll notice no difference as the default was 300px. "
"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."
"Invokes a function, performing up to 5 retries with exponential backoff. Retries with delays of approximately 1, 2, 4, 8 then 16 seconds for a total of about 32 seconds before it gives up and rethrows the last error."
"This solution came about from a requirement to recreate SharePoint lists in Google Apps, taking across large numbers of list items, with each item needing to have its own edit form populated with the appropriate data. Additionally, users should be able to edit the Google Sheet, and have those changes reflected in the edit forms. This attempts to give the same functionality as SharePoint where items can be edited in edit form, or in bulk via datasheet view"
"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."
This post describes how you can use the IMAGE formula as a Google Analytics Beacon for tracking Google Sheets views
Martin Hawksey's insight:
I've got quite a few Google Sheet templates in the wild and was looking for a way to track usage (even just a basic view count). Recently I came across +Ilya Grigorik 's Google Analytics Beacon project which lets you use an image as a GA webbug. The result basic Google Analytics tracking of sheets without jumping through potential Google Apps Script authorisation and quota issues
"Finance Service - we are deprecating the Finance Service in Google Apps Script. It will remain available for the next six months but will be turned off on September 26, 2014. Please start considering alternatives for the financial data right away.
Properties Service - we are launching a new properties service with a notion of Document level properties and more. Due to this, we will be deprecating the current properties service. Again, stay tuned for more details tomorrow! We think you'll like the new Properties service look. This is more of a heads up. No action needed till after tomorrow's blog post. "