" Someone shared this on G+ the other day, and I thought it was really wonderful. Just make a copy of this spreadsheet and you will be able to designate a Google Drive folder to pull from in order to create a QR code for every document in that folder."
Martin Hawksey's insight:
Given the number of files I have in some folders this may time out for me ;)
" Google Forms is a free and simple way to collect information — from quickly polling your friends about who'll be attending your trip to the haunted hayride, to getting thousands of responses to an awareness survey for work. Over the last few months, Forms has been getting a bunch of updates to help you make good looking surveys, like new theme choicesand the ability to create your own personalized themes. To give you even more flexibility and options, we’re introducing add-ons for Forms—new tools, created by developer partners, that deliver even more features to your surveys (just like add-ons for Docs and Sheets)."
"Here's 2nd in 'do something useful in 5 mins with Google Apps Script'. The first was about how to use a spreadsheet as a database. In case you've got fed up with that by now, here's how to graduate to using a parse.com backend."
"It’s only Wednesday, but already five updates have been announced this week which impact Google Apps domain admins and developers. These aren’t the sorts of things most users will be interested in, but administrators should definitely be aware of them. Take a look and see if your apps or domains will be affected."
Martin Hawksey's insight:
Shared with the Google Apps Script G+ Community by +Jarod King
" The idea is that your Google spreadsheet will connect to your Google Drive account and list down all documents with ownership information. You can easily add more columns to it like size to find documents with a large size. Once the sheet is ready, you can use Filter option (the Funnel icon) to find files owned by you. You can sort the sheet by file name to arrange them alphabetically. "
"Awesome Table lets you easily display data from a Google Sheet in many different ways. You can even put some HTML tags in your spreadsheet cells to create beautiful views of those data and display a nice People Directory, Job Board, Training Offering or whatever list you need to display on a site."
This post from Apps Script GDE Bruce Mcpherson steps through the process of collecting and displaying page analytics. Here's the details of what's covered: Getting analytics for the site Getting the pages in the site Matching Analytics to sites pagesDealing with recursion Storing options and parameters Database abstraction of site results Retrieving page data from GAS web service Using a canvas in Google sites Working with hyperlinks in canvas Gadget preferences and parameters Light JSONP implementation
* Added the LinearOptimizationService, which allows scripts to model and solve linear and mixed-integer linear programs. * Add-ons for Google Sheets and Docs can now use most installable triggers, although they still cannot use time-driven triggers (sometimes called clock triggers). * Added an installable open trigger for Google Docs. Like the installable open triggers for Sheets and Forms, this trigger is similar to the simple onOpen() trigger, but allows the triggered function to call services that require authorization, if the user has authorized the script ahead of time. * Added several new ScriptApp methods, classes, and enums to support installable triggers in add-ons: * The UiService widget DocsListDialog now requires that you call DocsListDialog.setOAuthToken(oAuthToken) before calling DocsListDialog.showDocsPicker().
"It is possible to sell apps built 100% with Google Apps Script. People are ready to buy items on the add-on stores. It's easy enough to implement in-app purchases. I will certainly continue to propose apps mostly free, with some premium features / more quota for paying users."
DocsListDialog is a widget used by only a small fraction of Apps Script projects to provide a Google Drive "file open" dialog in a UI service user interface. In almost all cases, using Google Picker in HTML service is preferable and more secure.
"Over the last couple of weeks I have received a bunch of emails from readers who were looking for Google Spreadsheet scripts that they used last year, but cannot find this year. The reason for this is that when Google pushed out the updated Spreadsheets to all Google Apps for Edu domains the script gallery was removed from the "insert" menu in Google Spreadsheets. A few of those scripts are now available as Add-ons, but most are not."