google-apps-script Questions
2
I have a custom Google Form i made and an own site. What i need is, after submitting the Google Form, to allow the user access to download a file.
This means that you should only be able to access ...
Sable asked 4/7, 2018 at 20:27
4
In Google Sheets (as with Excel, etc) if a user enters bad input into a formula, an error code will be printed in the offending cell and a small pop-up provides more detail about the error. So if I...
Encrimson asked 2/10, 2014 at 0:9
6
Solved
Are there methods to measure the execution time when built-in functions completed for Spreadsheet? When I use several built-in functions (For example, IMPORTHTML and IMPORTXML), if I know the avera...
Judiciary asked 25/10, 2017 at 4:0
6
Solved
I'm trying to utilize the momentjs library in Google Apps Script but I'm not clear on how to do so. I'm not sure how to add the library, so obviously running something like the following results in...
Gallant asked 14/3, 2014 at 16:6
5
Solved
Is it possible to call setTimeout or an equivalent function in Google Apps Scripts?
When I try to run the following code:
function onSubmit() {
// we've been called, remove trigger, set timeout,...
Receiptor asked 15/4, 2015 at 19:43
4
Solved
I've been trying for a few days to figure out how I can make the web app from my Google App Script work on mobile.
The most common solution I've seen is to simply embed the web app into the old ver...
Gebler asked 30/7, 2017 at 0:55
1
Solved
I want to send a Google calendar invite using the google apps script but I am encountering an error in the last line of the following code snippet:
function testnotification(){
var calendarId = &q...
Oscar asked 4/3, 2023 at 6:40
5
Solved
I have several scripts in Google Docs spreadsheets that use MailApp.sendEmail to send e-mails incorporating data from the spreadsheets. They've all worked marvelously for years. About 2 weeks ago, ...
Drenthe asked 28/6, 2013 at 1:21
6
Solved
I am trying to use string similarity inside Google App Script, however it is not entirely clear to me how to get it working inside App Script, I get multiple errors, such as "require" is not define...
Phenazine asked 10/3, 2018 at 1:49
5
Solved
I basically have small images in a table that I'd like to enlarge on mouse click. I'd like the enlarged image to appear on the center of the page. On mouse click again to remove the enlarged image....
Hypabyssal asked 22/9, 2015 at 8:1
2
Solved
I'm using a Google AdWords/App Script and I got this response from DoubleClick Search. I'm trying to parse it to put in a Sheet/ into an array to work with and I'm not having much luck. Thank you f...
Bellringer asked 11/11, 2016 at 16:59
6
My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having to cut and paste all of the formulae again whenever I want to view the new info...
Streaky asked 22/9, 2014 at 9:0
8
Solved
I'm using multiple Google accounts. In one of them (not default) I created Google Spreadsheet file and I want to create Script connected to it. Nothing complicated. But the problem is that after cl...
Grainger asked 8/12, 2017 at 11:40
3
Solved
I'm trying to create a class with some fields on Google Apps Scripts. I can't even save the file. From what I understand of this SO answer, I'm using the correct syntax for class fields.
V8 runtime...
Roundup asked 8/2, 2022 at 22:50
6
I have received 341 error notification emails for the below error
We're sorry, a server error occurred. Please wait a bit and try again.
The notification email only tells about the name of functi...
Ehlers asked 14/9, 2013 at 17:48
5
Solved
I'd like to add buttons to specific cells in Google docs spreadsheet. The apps script UI documentation talks about how to add a new panel, but it's not clear how UI in that panel could be attached ...
Hilburn asked 29/7, 2011 at 17:31
4
Solved
I'm using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I'd like it to jus...
Tiki asked 24/10, 2010 at 16:19
30
Solved
I have a sheet with data in cols A through H.
I need to determine the last row in column A that contains data (it's all contiguous - no gaps in the data/rows).
There is also data in the other col...
Sanjak asked 13/7, 2013 at 16:42
4
Solved
I'm new to Google Apps Script. I want to get the value of a specific cell by it's column name, not the column index. Here is what I have:
var rows = sheet.getDataRange();
var values = rows.getValu...
Parlance asked 1/4, 2016 at 2:14
2
Solved
In the google apps script editor for google sheets, I can add a library created by others if I know the project key e.g. MKvHYYdYA4G5JJHj7hxIcoh8V4oX7X1M_ (a library for accessing the Twitter API)
...
Straub asked 13/8, 2015 at 16:42
4
Does anyone know how to convert a Persian date to a Gregorian date using an Excel / Google Sheet function?
for example:
1401/06/06
to:
2022/08/28
P.S: Earlier I found a function to convert Gregor...
Moiety asked 28/8, 2022 at 10:38
4
Solved
I am able to get the range values using getValues() and put it into a string by declaring the following variables in Google App Script
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ...
Alper asked 16/6, 2017 at 1:13
4
Solved
In my spreadsheet, I have a running script, which is using the getLastRow() function as an essential part of its logic.
Ever since I applied the array formula in one of my columns, the getLastRow...
Nepali asked 23/10, 2017 at 7:22
2
Solved
I am new to Google scripting. I would like to check if the value in a cell is a date, and if so, to change the default format of the date, and then return the new formatted date value.
Here is an ...
Crowell asked 11/3, 2013 at 19:46
1
I've been trying to create a Google Spreadsheet plugin from some existing Google App Scripts that I have, and one important part of this app script is Custom Functions.
I have seen an addon that ca...
Irma asked 18/1, 2023 at 13:8
© 2022 - 2024 — McMap. All rights reserved.