55,611 questions
0
votes
1
answer
36
views
How can I skip a specific column when copying from another sheet (setValues)?
Overview:
In Google Sheets, I have created a form, which inputs records and copies the supplied values to a subsequent sheet tab. This (Form) tab, contains a Submit Button, when selected the (9 values)...
- 151
-1
votes
0
answers
19
views
security policy limitation of Apps Script
I'm working on a setup where the REAL PROJECT Google Sheet calls an HTML form that's hosted in a separate ADMIN PROJECT via a Web App URL (e.g. https://script.google.com/macros/s/AKfyc.../exec?func=...
-3
votes
1
answer
30
views
Google sheets script exceeds "maximum execution time" in ONE account
I created a new Google sheet with one script:
https://raw.githubusercontent.com/Eloise1988/COINGECKO/refs/heads/master/CoinGeckoV2.gs
The sheet has just one cell with a simple function from the script:...
-1
votes
0
answers
58
views
How can I copy a folder using Apps Script?
I have a Folder A, and I want to get Copy of Folder A, let's say within Folder A.
var folderA = getFolderA();
var folderA_ID = getFolderA_ID();
var copyFolderA = folderA.makeCopy(folderA_ID); // ...
2
votes
1
answer
69
views
Google Apps Script fails to retrieve sheet by name
I'm having a very strange and persistent issue with Google Apps Script and getSheetByName().
I have a Google Apps Script script connected to a Google Sheets spreadsheet. The script is supposed to read ...
-1
votes
0
answers
60
views
Multiple Random Numbers from a list no repeats [duplicate]
currently I have a formula set up on my sheet to randomly select numbers from a list and enter them in other cells. However, this is problematic because it changes any time you change anyhting on the ...
-3
votes
1
answer
40
views
Range getCell instead of TableCell [closed]
Why if I pass Range to a Routine, and I add getCell it doesn't recognize the Range function but the TableCell function of Document App?
2
votes
2
answers
86
views
Exception: Service Spreadsheet Failed while Accessing spreadsheet error due to accessing negative row
I saw this recent post about this same error and that post was closed because the error couldn't be reproduced. I received the same error last night and it's easily reproducable. Not sure how related ...
- 419
0
votes
0
answers
78
views
setOwner(emailAddress) method returns a Exception: Access denied: DriveApp error? Is there a fix to this? [duplicate]
function transferOwnership() {
const fileId = "some-sheet-id-that-i-own";
const newOwnerEmail = "[email protected]"
const file = DriveApp.getFileById(fileId);
const ...
- 21
0
votes
0
answers
66
views
Exception: Service Spreadsheet Failed while Accessing spreadsheet [closed]
I’m using an api to fetch replies sent via Telnyx sms and populate those replies into my sheet one row at a time.
I ran the script successfully several times today getting as much as 10 replies.
Now ...
1
vote
0
answers
70
views
Menu not showing after install; issues with onOpen() and AuthMode.NONE [closed]
I'm working on a Google Workspace Add-on (a Mail Merge tool), and I keep getting rejected by the GWM review team with this feedback:
*
Menu - Menu options not shown after App is installed. Please ...
-4
votes
0
answers
83
views
How to improve handwriting recognition in an image [closed]
I'm trying to develop a system to read the handwriting in a chart within a written page, using a multimodal LLM. I'm using Google apps script So far I've experimented:
function openRouterApiRequest() {...
- 36.6k
-5
votes
0
answers
50
views
Creating a conditional function in Apps Script (Sheets) that auto-populates a new entry [closed]
I'm in the very early stages of building out this script, so any guidance is appreciated.
I have a Sheets document that inventories devices such as laptops. Each entry has a variety of columns ...
1
vote
0
answers
69
views
Change title of table depends on the title in the sheet using data array [closed]
Is there a formula using the data array that, when I change the value in the sheet, also changes the title in the data array and refelect it in the table?
Here a example when i change the April 1, ...
- 27
0
votes
1
answer
66
views
getStartTime/getEndTime
Im currently working on a simple internal add-on for google calendar. When we click a event we will choose a option from a dropdown and click a button. When that happens, take the selected item with ...
- 21