GasTips

Retrieving Cell Coordinates of Cells with Quote Prefix using Google Apps Script (Single Quote)

Gists This sample script retrieves the cell coordinates of cells with the quote prefix. In Google Spreadsheet, when a single quote is added to the top letter of the cell value, the cell is used as the text value. When we want to search the cells with the quote prefix in Spreadsheet, unfortunately, in the current stage, this cannot be achieved using Spreadsheet service (SpreadsheetApp) and Sheets API. In this method, such cells can be retrieved.

Report: Efficiently Creating Web Apps using a Google Apps Script library

Gists This is a sample script for efficiently creating Web Apps using a Google Apps Script library. When a Google Apps Script library is used for creating Web Apps, the following advantage can be obtained. The script of the client-side can be simpler. Because most scripts for constructing Web Apps are included in the Google Apps Script library. When the script of Web Apps (In this case, the script of Google Apps Script library is modified.

Retrieving Data from Content-Type of 'text/event-stream' using Javascript and Google Apps Script

Gists This is a sample script for retrieving the data from Content-Type of ’text/event-stream’ using Javascript and Google Apps Script. In the current stage, UrlFetchApp of Google Apps Script cannot be retrieved the data from Content-Type of ’text/event-stream’. This sample script can be used for achieving this as a workaround. This sample script uses EventSource. So this script uses a dialog on Google Docs files (This sample uses Google Spreadsheet.).