Posts

Showing posts with the label Google Cloud

Front-end Google Cloud Products With a Google Apps Script Application - Part 4

Image
_________________________ This article improves the Google Apps Script engineering featured in earlier Bit Vectors articles  here ,  here,  and  here  to add file save and print features to a Google Apps Script application. This article will also discuss the potential of Google Apps Script application sharing. Part one  showed the sample application user experience. Part two   described the application configuration . Part three here explained the application engineering. Part four here  will explore how Google Apps Script application sharing presently works and will explain why this is not yet ready for production, based on the present state of the Google Apps Script product . It will also discuss suggested feature enhancements to the Google Apps Script product that would make application sharing possible. Download the three application  component files from the  GitHub repository . ____________________ I n parts o...

Front-end Google Cloud Products With a Google Apps Script Application - Part 3

Image
_________________________ This article improves the Google Apps Script engineering featured in earlier Bit Vectors articles  here ,  here,  and  here  to add file save and print features to a Google Apps Script application. This article will also discuss the potential of Google Apps Script application sharing. Part one  showed the sample application user experience. Part two   described the application configuration . Part three here will explain the application engineering. Part four   will explore how Google Apps Script application sharing presently works and will explain why this is not yet ready for production, based on the present state of the Google Apps Script product . It will also discuss suggested feature enhancements to the Google Apps Script product that would make application sharing possible. Download the three application  component files from the  GitHub repository . ____________________ T hree files comprise...

Front-end Google Cloud Products With a Google Apps Script Application - Part 2

Image
_________________________ This article improves the Google Apps Script engineering featured in earlier Bit Vectors articles  here ,  here,  and  here  to add file save and print features to a Google Apps Script application. This article will also discuss the potential of Google Apps Script application sharing. Part one  showed the sample application user experience. Part two  here  will describe the application configuration. Part three  will explain the application engineering. Part four  will explore how Google Apps Script application sharing presently works and will explain why this is not yet ready for production, based on the present state of the Google Apps Script product . It will also discuss suggested feature enhancements to the Google Apps Script product that would make application sharing possible. Download the three application  component files from the  GitHub repository . ____________________ B efore ...

Front-end Google Cloud Products With a Google Apps Script Application - Part 1

Image
_________________________ In an earlier article , I showed how to front-end Google BigQuery with a Google Docs Spreadsheet / Google Apps Script application. Later articles generalized the engineering: this article  described a Google Cloud SQL front-end application and  this article  explained how to integrate BigQuery and Cloud SQL to build BigQuery stored procedure functionality. This engineering works well enough, but it has some drawbacks: First, it offers no way to save a result set as a finished file. Second, it offers no way to print a result set. Third, the sample applications rely on a container‑based architecture - in other words, the application script files are bound to a Google Sheets file as components of that file. This article describes a sample Google Apps Script application that front-ends a BigQuery project. However, the application also offers file save and print features. Additionally, while its engineering relies on Google Sheets, it br...