Andrew Roberts has shared a tutorial and boilerplate for using the Materialize CSS framework in the Google Sheets sidebar. Materialize is based on Material Design and the framework is lightweight and easy to use. This framework will also work for other G Suite editor sidebars (Docs, Sheets, Forms, Slides). If you plan to use Materialize in your Editor Add-on Google ask that the design adheres to the UI style guide.
Source: GSheet Sidebar with Materialize CSS & jQuery – Andrew Roberts
Ever needed to merge two similar datasets and automatically get rid of any duplicates?
This article describes how to do that using the SsObjects Google Apps Script library.
Source: Merging two 2D arrays/datasets/tables with Google Apps Script – Andrew Roberts
This is an overview of the various techniques and best practices I have evolved in developing Google Apps Scripts over the years. Of course Google have got a few suggestions of their own, and there are plenty of more general …
This includes some good design pattern considerations for Apps Script projects as well as links to testing libraries, boilerplate frameworks, and extensions that help manage Apps Script work.
Source: Google Apps Script Development – Best Practices – Andrew Roberts
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.