Apps Script has the ability to access Google API’s, but you need to explicitly enable them before they can be used. The Drive API, can be used to delete a file. Drive API – Delete The Drive API method is Remove method instead of Delete. To enable the Drive API, open the Resources menu, then … Read more
Ui Dialogs can not be called by time triggered functions, they have to be triggered by a user action, that’s to say a click on a menu item or some sort of button that calls the function showing the UI.
As tehhowch mentioned, the key is you must use the Advanced Google API for this. However, the text on this page that says: This sends an invitation email to the attendees and places the event on their calendar. … is very misleading. The only way it’ll send email is if you set sendUpdates to all … Read more
This method uses the Gmail API, the OAuth2 for Apps Script library, and “Domain-wide Delegation of Authority”, which is a way for G Suite admins to make API calls on behalf of users within their domain. Step 1: Make sure the OAuth2 For Apps Script library is added to your project. Step 2: Set up … Read more
Here is a possible workflow suggestion that includes a form, a spreadsheet with responses and a doc with included images. the form is testable here the spreadsheet is viewable here the doc is viewable here See EDIT 2 NOTES : for now it works only with small images, I have to find a solution for … Read more
Libraries were designed specifically for this situation… please have a look at the documentation here.
If this is an exact copy of your script then you have a space in-between A1. and replace but I assume it is not. @SergeInsas is right the content needs to be a string for the replace() function to work, so if your trying to replace the . in a decimal number then you can … Read more
This code allows you to copy data from your spreadsheet, redact it, align each column independently and then post it in to SO with the appropriate markdown to make a nice looking table. The Code: redact.gs: function onOpen() { menu(); } function menu() { SpreadsheetApp.getUi().createMenu(‘My Tools’) .addItem(‘Authenticate’,’authenticate’) .addItem(‘Redactable Table’,’showRedactTableDialog’) .addToUi(); } function authenticate() { //no … Read more
Perhaps it’s not really its parent and that’s the reason for it not working. Right – there isn’t actually a DOM parent / child relationship in play here. Both the sidebar and the modal dialog were launched from server-side scripts, and are independent. They can both communicate with the server, though, so you can use … Read more
The onEdit() trigger is a so called “simple trigger” that has a limited field of action. Since it runs automatically and silently under the authority of the active user it can’t do anything that requires authorization, for example it can’t send emails ! The solution is simple : change your function name to something else … Read more