google-apps-script Questions
10
Using Google Apps Script, is there a way to write the values in a Google Spreadsheet array to a range without looping?
I am thinking something like the following to put one name each into cells A1:...
Denigrate asked 15/7, 2012 at 21:1
3
Solved
I need to find a way to have the multiple choice options in a Google form change based on a set of cells in a Google Spreadsheet that is constantly changing. Any ideas?
Histoplasmosis asked 10/11, 2011 at 19:8
7
I am having some issues with my code. I am trying to loop through a Drive folder that contains many PDFs and then merge these into one file. When I use my code it just creates a PDF for the last PD...
Affiant asked 14/3, 2013 at 15:55
1
I would like a google script to run every time a file is added to a specific folder. Can this be done? Currently, I have a trigger that causes the script to run every minute, however this is not al...
Search asked 7/4, 2018 at 22:10
3
Can a websocket connection be made in Google app scripts? I wasn't able to find anything about these in Google's documentation, so I am unsure.
Rento asked 28/12, 2016 at 23:8
2
Solved
I'm looking to embed a Google Sheet into a Google Extension. Simple enough — just use the autogenerated embed code and stick it into an html file. This is what I did:
<html>
<link rel=&qu...
Troth asked 30/8, 2020 at 1:4
2
I see a bunch of confusing solutions around, and I'm convinced there's a more simple, elegant way.
Right now, "date" would print 11/07. I simply want it to print 11/06.
I've tried s...
Mindamindanao asked 8/11, 2022 at 1:29
5
Solved
I have a list of numbers entered manually:
1
100
100
10
1
1000
10
1000
1
1000
100
10
I'd like to get the running max - the max value for each sub-array of the initial numbers array. By sub-array I...
Drachm asked 4/1, 2022 at 12:20
7
I am sending http request from script editor in google spreadsheets, but I keep getting the following error message:
Google Apps Script: You do not have permission to call UrlFetchApp.fetch. Requi...
Cheesy asked 12/10, 2019 at 23:25
1
Solved
Post is related to this SO thread
According to the Utilities.getUuid Google Scripts docs:
Get a UUID as a string (equivalent to using the
java.util.UUID.randomUUID()
Looking at the java.util.UUID...
Shrubby asked 2/11, 2022 at 16:8
6
I'm trying to create a function that takes in any array and transpose it so that rows turns to columns and columns to rows.
Not sure what I've done wrong or missing but keep getting this message on...
Trilbie asked 18/5, 2013 at 6:37
7
Solved
I am writing a script for a Google Docs Spreadsheet to read a list of directors and add them to an array if they do not already appear within it.
However, I cannot seem to get indexOf to return a...
Footlambert asked 11/6, 2013 at 13:3
1
Trying to scrape some classes from a website, to compile a spreadsheet report. I've only used Importxml briefly for common sites, which i have made work. However, how can we address cases where we ...
Earl asked 27/10, 2022 at 2:22
5
I have a Google Spreadsheet that a form is linked to and all form responses are stored in. What I am trying to find is the ID of the FORM itself. I tried this but this does not work..
(I'm running...
Undefined asked 17/6, 2014 at 21:38
2
Solved
is there a way to create an image (e.g. a png) from a google document?
I really mean an image, not just a pdf. GetAS only creates pdf, but returns an error if contentType is set to image/png or oth...
Chaussure asked 11/3, 2019 at 22:44
2
Solved
Making a web app that makes changes to certain (Sheets) files on my Google Drive (i.e. user will use the app as me), but I would like to restrict the Web app access
only to certain users. When de...
Scenery asked 12/8, 2017 at 17:57
2
This is my scenario:
1 cell: A1 where you can input some text
1 image / drawing: when it is clicked a script function is called
The problem is that the script attempts to read A1 content, but ...
Lobbyism asked 4/4, 2018 at 18:19
1
Solved
Derived from Canonical question for TypeError Cannot [call method / read property / set property] of null in Google Apps Script
Proposed reference for questions like :
Why the Execution order of ...
Contractor asked 18/10, 2022 at 9:53
1
Function has a trigger for on form submit
having issues with this very first line. Its supposed to grab data from excel sheet to auto-populate into a copy of template
function autofillGoogleDo...
Mycosis asked 18/10, 2022 at 0:45
7
With Google Apps Script, how to make a line break in a variable to send mail?
Fumble asked 23/5, 2012 at 13:21
7
Solved
I want to convert the time HH:MM into H.xx
Like I am getting it in this format: Sat Dec 30 00:00:00 GMT+05:21 1899
But this value is 04:29 in cell. I want it to be 4.5 hours to multiply it to hou...
Candicandia asked 5/4, 2018 at 14:1
4
Anyone have any patterns for writing and subclassing objects in Google Apps Script?
I've tried defining subclasses with ParentClass.call(this, args), and putting parent class methods both in the or...
Necrotomy asked 9/3, 2012 at 0:23
3
I have a script attached to a Google Form which sends a notification to a Discord channel on submission. I want to include a direct link to the individual response (link looks like https://docs.goo...
Francinafrancine asked 21/1, 2018 at 16:11
13
In a Google Docs spreadsheet, I'm looking for something like =EVAL(A1) where A1 is set to "=1+2".
I found out that in MS Excel there is an EVALUATE() function (which seems a bit tricky to use prop...
Monandry asked 30/4, 2013 at 15:34
2
Solved
I am trying to create PDF from an HTML page through google-apps-script and set page size to "Letter" not "A4" (8.26 X 11.69). I have checked many related posts and have actually figured out backgro...
Conchology asked 9/4, 2019 at 20:35
© 2022 - 2024 — McMap. All rights reserved.