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.
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.