111 questions
After loading the local CSV file into the spreadsheet, I would like to put in a blank code.I've created a button on the spreadsheet from which I call function.I'd like to do everything in one click, b...
I would like to get a list of Dropbox files from Google Apps Script and insert them into Spreadsheet.I used the following HTTP request for Dropbox API:An error will be returned.It seems that the conte...
I am creating a survey within the domain using the Google form.Currently, the email address of the respondent is manually entered, but We have received a request to make this automatic.More specifical...
I previously set the trigger to start every 15 minutes, but now it doesn't start.It can be started without any problems when you manually run it (press the arrow button), but it does not work at all o...
From the Google form spreadsheet, I set up the Tools > Script Editor edit to receive an automated reply email when I submit the form.(See script, trigger settings at the bottom) It worked fine for a w...
Hello,I created an add-on to a Google spreadsheet and applied to Google Workspace Marketplace, but no matter how many times I communicate with them, the reviewer will reject me if I don't see the menu...
I would like to obtain an email address using Google form.However, if Settings → General → Collect email addresses, I have to enter an address one by one, so I want to avoid it.Therefore, you must log...
function attachmentsToCsvFile(){ varsheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); // You could use now Date(); on its own but it will not look nice. vardate=Utilities.formatDat...
I'm a beginnerIs it possible to read the contents of Google spreadsheet into external HTML?(Example: Place A1 in the spreadsheet in the HTML P tag) I was able to find the document that you said you wo...
Nice to meet you.Using the following article as reference, I have written a script using the doGet function.[Workflow created with GAS] How to create a script that says approval by clicking the URLTo ...
| « | - 7 - | » |
© 2024 OneMinuteCode. All rights reserved.