google-apps-script Questions
4
Solved
How do I make the variable "Partnum" not be case sensitive. When I run the script, it wont detect "aBcd" if I'm searching for "abcd" . I'm not sure what to do.
function doStuff() {
var ss = Spre...
Yser asked 6/12, 2010 at 23:47
5
Solved
I've had a Google Apps Script web app running for a bit over a year which gave users an option to download a csv file. It worked perfectly fine, although in the console it gave a warning about down...
Glandule asked 22/5, 2020 at 18:36
3
Solved
GAS is quite powerful and you could write a full fledged web-app using a Google Sheet as the DB back-end. There are many reasons not to do this but I figure in some cases it is okay.
I think the bi...
Noah asked 24/6, 2019 at 13:31
3
I'm trying to get a script that I've made for a google sheet to trigger when the sheet is opened (since I've found you can't trigger them manually through the mobile app). Somehow, I've managed to ...
Vasya asked 17/6, 2018 at 6:21
2
Solved
It is possible to set the range border style and color. Now the question is: how can we get the border style programmatically?
I'm looking for something like:
var ss = SpreadsheetApp.getActiveSprea...
Urethroscope asked 12/2, 2018 at 19:41
1
Example: If I set a right border in cell D2, then look at .getBorder().getLeft().getBorderStyle() in D3, there is no border, yet when I clear borders from cell D3, it clears the border that was set...
Heilbronn asked 28/7, 2020 at 0:7
1
Solved
I was trying to get the information about the borders of a range, doing so I tried the getBorders() function, but received the following error:
Exception: Unexpected error while getting the method...
Yon asked 8/8 at 12:20
2
Solved
I want to make a quiz for students regarding basic programming using Google Forms. The challenge is that I can not find any Add On how add code snippets to the questions, like it is here in S...
Jeanmariejeanna asked 10/10, 2019 at 19:33
4
Solved
Inside a button click handler, I'm creating a new web page like so:
var page = SitesApp.getPageByUrl(url).createPageFromTemplate(title, name, template);
and I want to redirect the user automatic...
Catchascatchcan asked 3/7, 2012 at 16:50
8
Solved
I'm trying to pass an object (contents of a sheet row) to an apps script template. You can see the row in the screenshot.
my function in apps script contains:
var sendableRows = rows.filter(fun...
Equipoise asked 18/2, 2019 at 14:28
5
Solved
It is possible to add a "link" to a cell in a google spreadsheet through the user interface. I want to do the same using a Google Apps Script. I was expecting there to be a method on the Range clas...
Finkle asked 27/5, 2016 at 14:25
8
Solved
I am trying to migrate a load of documentation which was written in markdown into a Google Doc so it can be used by our marketing department.
Is there a mechanism using appscript/ Google Docs Api...
Overwhelming asked 29/6, 2019 at 19:12
4
My app is finally published in the G Suite Marketplace. However, I need to update the banner image as it's blurry and the [Publish] button is always greyed out. What is missing from this screenshot...
Jolda asked 17/9, 2018 at 8:42
1
I'm building a form using Google Forms, and then taking the form out into my web page so I can directly edit the form (so I do have complete control over the form code).
Right now I'm able to submi...
Declinatory asked 15/2, 2013 at 21:13
6
Solved
I'd like to use Typescript for my Google Apps Script (GAS) projects, but I can't find a way to compile my code into something that GAS accepts.
GAS doesn't support export, and Typescript seems to...
Scriptorium asked 14/2, 2018 at 16:26
8
I see most examples from Google is they use only functions in a single giant script.
e.g. https://developers.google.com/apps-script/quickstart/macros
But in our style, we usually write all funct...
Marge asked 13/7, 2014 at 9:23
7
Because google spreadsheets does not support iterations, I wrote my own simple app script to adjust an input based upon the calculation of the spreadsheet output. However, after I change the input ...
Alfeus asked 3/10, 2012 at 14:51
3
Solved
There isn't a way to share only one sheet of one spreadsheet in Google Sheets. So, you have to share an entire spreadsheet. So, I was thinking in writing a script to synchronize two sheets (each on...
Swatter asked 7/12, 2013 at 17:9
9
Solved
How to generate an uuid in google sheet (for exemple ccb8a660-91c9-a556-58e0-4fa7-229516872004).
Either with a macro? or a formula?
Episcopal asked 9/7, 2018 at 12:7
4
Solved
Is there any way to find out the current response of the Google Form (programmatically)?
In the onSubmit function.
Looked over their documentation but I have to provide the respondId.
How do I f...
Ypsilanti asked 8/2, 2014 at 15:21
2
Solved
I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the hyperlink associated with that cell, only the text. Is there any way to get t...
Stoll asked 12/12, 2012 at 19:18
8
I would like to display easily an image on Gsheet cell based from URL of image stored in Gdrive.
I have tried with the Gsheet function =IMAGE("URL") and it does not work.
The objective is to disp...
Novelize asked 18/2, 2020 at 18:42
14
Solved
Here is what I'm trying to do: given a Google document URL, I want to get the document ID to create a copy on Google Drive. I know I can achieve that by some regex or replacing on the URL, but as t...
Klepht asked 30/5, 2013 at 15:23
14
Solved
I want to post my contact form to my google script that will send an e-mail to me. I use the following code:
var TO_ADDRESS = "[email protected]"; // where to send form data
function doPost(...
Bullen asked 22/11, 2018 at 15:17
4
Solved
I'm using Google App Script for the first time.
I'm using it on a Google Doc spreadsheet.
I'm trying very simple functions, just to learn the basics. For example this works:
function test_hello()...
Aesir asked 26/7, 2012 at 0:14
1 Next >
© 2022 - 2024 — McMap. All rights reserved.