TU13: Google Sheets Developer Metadata
Broadcast Date: 20 October 2017
Presenters: Bruce Mcpherson, Martin Hawksey and Steve Webster
There haven been a number of Google Apps Script and related developments which reviewed in this episode of Totally Unscripted. As part of this Bruce Mcpherson provides a detailed overview of Google Sheets Developer Metadata. This can be used to abstract locations in a sheet (for example a "TOTALS" column), so that even if the target changes position, you can still find it.
Resources (see highlights below for links):
Google Sheets Developer Metadata
Bruce Mcpherson provides a detailed overview of Google Sheets Developer Metadata. This can be used to reference locations of sheets, rows, columns and cells even if the sheet name and structure changes, so that even if the target changes position, you can still find it.
News and Community Spotlight - September 2017
The News and Community Spotlight from Totally Unscripted episode 13. As part of this we cover:
New Google Slides Service
Release Notes, including changes to OAuth Client Verification for Add-ons
Script Editor Updates
Firebase's new Cloud Firestore
Upcoming DevFest session