google-apps-script Questions
7
Solved
I'm trying to make a script that automatically deletes e-mails from a certain sender immediately and permanently, as Gmail only allows for a filter which sends an e-mail to trash for 30 days. Pleas...
Hamm asked 14/4, 2013 at 2:15
5
Solved
I'm trying to POST to a web service that is expecting to get JSON as payload using Google Apps Script. I'm using the following code:
var options =
{
"method" : "post",
"c...
Serviette asked 4/6, 2012 at 20:57
2
Solved
When run:
MyPopWindow.postMessage("Test", 'mydomaine');
I have a error on MyPopWindow whith script.google.com:
(program):1 Failed to execute 'postMessage' on 'DOMWindow': The target
origin prov...
Leila asked 13/10, 2016 at 6:49
2
Solved
I write a custom function in Google Sheet:
function array_test() {
return [1,2];
}
And test it in Google Sheet =array_test():
You can see Google Sheet expands array data in a vertical way. Bu...
Faceplate asked 20/1, 2020 at 4:43
1
Solved
I have a simple Google Workspace add-on that I'm building for myself to use with Google Sheets.
It works on desktop. But if open the Sheets app on my Android phone I can't access it.
My question: h...
Harmonicon asked 26/5, 2023 at 21:47
9
Solved
Given a "normal document" in Google Docs/Drive (e.g. paragraphs, lists, tables) which contains external links scattered throughout the content, how do you compile a list of links present using Goog...
Sather asked 10/9, 2013 at 19:32
4
function createAndSendDocument() {
// Create a new document with the title 'Hello World'
var ui = DocumentApp.getUi();
var response1 = ui.prompt('What should be Name of your Document', ui.ButtonSet...
Intramuscular asked 17/9, 2013 at 3:32
1
Is it possible to use Angular2 in Google Apps Script Web App? I searched enough, but there is no documentation/ article on the web which touches this topic.
If it is possible, can anyone give me a...
Ligurian asked 13/2, 2017 at 16:25
5
I have failed to find documentation for running a script by clicking on a value with hyperlink in a cell in google spreadsheets. Is it possible?
Thanks
Finegan asked 22/10, 2012 at 4:7
2
Solved
I'm using JDBC on GoogleScript to communicate with GoogleCloud MySQL.
My table has 24 columns and it takes about 30 seconds for a 1000 row ResultSet to be loaded into the array. The loop in the c...
Newark asked 30/5, 2020 at 19:19
3
Solved
I am trying to split a cell that has multiple values delimited by a new line, it works perfectly for cells that have more than 1 value, but if I get a cell with just 1 value (ie, no newline charact...
Adventure asked 28/5, 2013 at 19:15
3
Solved
Google Docs now supports dropdown inputs (Insert > Dropdown). I am using Apps Script to access a Google Docs, and would like to get the value of a drop down.
I have read Get Google "pills&q...
Efta asked 8/7, 2022 at 16:2
3
As part of our "off-boarding" process for employees leaving the company, as super admins we use the Google Apps Admin SDK Directory API to change the user's password so that they can no longer acce...
Trustbuster asked 4/8, 2015 at 11:55
3
Solved
I am trying to make a Web App with Google Apps Script that actually returns an image file instead of just text. I tried it as simple as that:
function doGet() {
var file = DriveApp.getFileById('[r...
Convulsant asked 18/4, 2016 at 16:50
3
Solved
I tried indexOf(), findText() and other few methods for finding a string pattern in a text in google app script. None of the above method works.
var str="task is completed";
I'm getting this str...
Fanatic asked 19/5, 2015 at 11:36
2
Solved
I'd like to document (in the Google Sheet autocomplete) a custom function with optional arguments, similar to the WEEKDAY function (autocomplete below).
The JSDoc spec on optional arguments does n...
Macarthur asked 26/1, 2019 at 23:0
5
I'm facing this issue while I'm running the script. one day before if was working fine for me.
I did clear all the cache of chrome browser and I tried another laptop also but the issue is as it is....
Monkey asked 7/1, 2021 at 11:56
4
Solved
We set up a Google Apps Script-based Intranet in our organization, which benefits from Google Apps for Education. We've been using for months:
doGet()
HtmlService.createTemplate(...)
Publish > De...
Panacea asked 7/7, 2017 at 12:35
4
Solved
Is there a way to lock a particular Google Apps worksheet using a script?
I have this code that renames the current spreadsheet to whatever you enter in the input box.
// The code below will rena...
Erenow asked 16/5, 2012 at 16:38
3
Solved
I could use some help with writing a script in my Google spreadsheet. First off, I am no programmer and a novice at best on writing code or any script.
I want to use this for a lunch list. The ba...
Gruchot asked 21/1, 2014 at 22:1
7
Solved
I want to get a string value to compare it later on with an if condition from only one column in a spreadsheet using Google apps script.
I searched the internet and I found this link - sorry if thi...
Disassemble asked 20/2, 2013 at 22:18
7
How do I write a Google Apps Script that deletes files?
This finds files:
var ExistingFiles = DocsList.find(fileName);
But DocsList.deleteFile does not exist to delete a file.
Is there a way t...
Rattle asked 9/1, 2013 at 16:1
2
Solved
Google Docs has recently introduced a feature where we can refer to
Date
Person
Google Drive Document
in the form of a Chip Block (as shown in the picture above). The Document-A already exists i...
Venus asked 31/10, 2021 at 5:57
3
Solved
I'm getting this error when I try to run my code to had a custom menu. My code:
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Menu')
.addItem('Candles','callCandles')
.add...
Matthaus asked 12/12, 2020 at 23:17
2
I'm building a data studio connector (apps scripts) that needs access mysql.
I have all my credentials storing in GCP Secret Manager and would like my apps scripts to get the credentials from Secre...
Victimize asked 4/4, 2021 at 13:3
© 2022 - 2024 — McMap. All rights reserved.