Gists Kanshi Tanaike Overview This is a report about the possibility of asynchronous process using event triggers. This is for Google Apps Script (GAS). Description onEdit() which is a simple trigger is often used as a trigger when the values are modified on Spreadsheet. When users want to use the script including some methods which are required to be authorized as the onEdit event, a installable trigger of onEdit is used.
RangeListApp was updated to v1.0.1. v1.0.1 (September 13, 2018) New method of “expandA1Notations” was added. This method can expand the a1Notations. For example, A1:C2 is expanded to "A1","B1","C1","A2","B2","C2". You can check this at https://github.
Gists This is a sample script for expanding a1Notations using Google Apps Script (GAS). In this script, for example, “A1:E3” is expanded to “A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3, C3, D3, E3”. When each cell in “A1:E3” is checked, this script might be able to be used. If this was useful for your situation, I’m glad. Script: function expandA1Notation(a1Notations) { var columnToLetter = function(column) { var temp, letter = ''; while (column > 0) { temp = (column - 1) % 26; letter = String.
goodls was updated to v.1.0.3 v1.0.3 (September 4, 2018) When the files are downloaded, the progress of downloading got to be able to be displayed. This scene can be seen at this demonstration video. If the new option of --np is used, the progress is not displayed. The detail information and how to get this are https://github.
FilesApp was updated to v1.0.1. Removed a bug. When there are files and folders without the parents, an error occurred. In this version, this issue was removed. GitHub of FilesApp