111 questions
I want to record the folder hierarchy of Google drives, but I can't think of a good way.The purpose is to periodically record the ID of an item in a shared folder and restore it from Google Apps Scrip...
I am currently studying to make various things using Google Apps script.I'm trying to manipulate the sheet with a spreadsheet, but I have a question after seeing the reference.In the SpreadsheetApp cl...
SHIFT-JIS saves the local CSV file, so it gets garbled when you import it into Google spreadsheet.I would like to add a code to the following GAS script that you told me in the related question I aske...
In Spreadsheets Add-on (Google Apps Script), vars=SpreadsheetApp.getActiveSheet();range=ss.getActiveRange();var values = range.getValues();Then, if the selection range is selected in Ctrl or Command o...
I wrote the code below to create the folder Second Bottom 1 and Second Bottom 2 under the folder Second, but it is created in the same hierarchy as Second as shown in the attached image. Why?var folde...
when Google spreadsheet is started (when spreadsheet is opened)I'd like to run the gas I created in the script editor.Either of the following methods will not work at startup:On the script editor, in ...
Thank you for your continuous support.Now, I was writing a form script.Previously, the contents of the form were sent to the email without any problems in the script below, but an error occurred.The e...
Class SpreadsheetApp has three types of open methods, but no close methods.Does this mean it's automatically closed? How do I keep it open until I explicitly close it?
I get an error when I try to sort below. Why?TypeError—Function getRange not found on object 1680. (line 5, file Original 2) Do not displayfunction A(){ var spreadsheet = SpreadsheetApp.getActiveSprea...
If you answer a number from the Google form, it will be stored in the spreadsheet with 0 at the beginning of the sentence disappeared.Is there any way to store it in a spreadsheet with 0 left at the b...
| « | - 9 - | » |
© 2024 OneMinuteCode. All rights reserved.