All Questions
377 questions
0
votes
2
answers
316
views
Bundling changes made by a script, so that it can be reverted by one undo (ctrl+z)
I've written an Apps Script function that sets values to non-contiguous cells in multiple sheets. This particular function is tied to a custom sheet operation that the user can call from a custom menu ...
- 347
0
votes
2
answers
68
views
Why after adding 30+ codes into App Script all codes in it started to work with bugs
I'm trying to organize my partner management using Google Sheets. I have a main spreadsheet where columns F-I are dynamic, meaning I want data from these columns to be transferred to columns A-D in ...
- 1
0
votes
1
answer
85
views
Resolving TypeError when trying to use findIndex
I'm trying to figure out why I'm getting the following error:
TypeError: Cannot read properties of undefined (reading 'includes')
The error occurs at the line var nameIndex = dataFlatArr.findIndex(s =&...
- 772
0
votes
0
answers
33
views
Google App Script Export PDF isn't syncing [duplicate]
I have the following data in my Spreadsheet
Since the latest doc_no is TRY/2024/05/06/0707857126, I want to generate a PDF according to that number. Here's the PDF Spreadsheet:
I'm able to generate ...
- 1,097
0
votes
1
answer
39
views
Google Sheet script to copy hyperlinked text into a new tab
The script that I’m using on GoogleSheet Appscript when moving one row to a new tab any hyperlinked text will not paste over to the new tab. How can I solve for this?
Google Sheet Link: https://docs....
- 3
0
votes
0
answers
29
views
How can you interact with a modal from apps script after it has already run? [duplicate]
Here's the scenario: I want to create a templated modal in Google Sheets that displays information about a script that's running in the background. As the script runs, I want it to update the modal. ...
1
vote
1
answer
98
views
Optimizing Google Sheets Script for Adding Dropdowns and Formulas to Multiple Rows
I'm working on a Google Sheets script where I need to dynamically update a sheet with dropdown menus and apply specific formulas to rows based on certain conditions. My current approach involves ...
- 242
0
votes
2
answers
60
views
How to get full range of onEdit(e)?
How to get the whole range of the onEdit(e) by Google Sheets script? I have tried the following script:
var sheet = spreadsheet.getActiveSheet();
function onEdit(e){
var row = e.range.getRow();
...
0
votes
1
answer
176
views
Google sheet automatically generate a pdf and send an email to notify
I need to write a script that allows me to automatically save a pdf after the data has been refreshed and send people an email.
The current problem is that there are too many columns in the google ...
- 65
1
vote
2
answers
181
views
Script to hide and unhide non consecutive columns in google sheets
I'm working on a financial forecast vs Actuals. I created a button to separate forecast months vs. actual months and need a script to make them work. I want too be able to click forecast button, and ...
- 13
1
vote
1
answer
60
views
Changing month by +1 also adds a timestamp in the cell. How do I not insert the timestamp
When I click the button "Change Dates" it updates the dates in the date column. It increases the dates by 1 month and inputs a Timestamp after the date. As you can see for the Date for ...
- 31
1
vote
1
answer
725
views
How to retrieve a spreadsheet apps script id using google api
I'm looking for a way programmatically using NodeJS and google api to associate an existing apps script file(id) with a newly created spreadsheet/s or else to retrieve the associated script id from a ...
- 13
1
vote
2
answers
257
views
Parse CSV number as text
I am trying to import the following CSV data into a Google Sheet, preserving the number format "0001,0002,0003" as a string.
CSV file
0001,0002,0003
test,test2,test3
I tried using Tanaike's ...
- 73
1
vote
1
answer
584
views
Error retrieving image from URL in Google Apps Script but only on some spreadsheets
I have Google Sheets spreadsheets that perform a lot of (small file-size) image retrieval using SpreadsheetApp.newCellImage() via code similar to the below:
function myFunction() {
const sheet = ...
- 543
0
votes
1
answer
391
views
How to output an HTML list for each row of google sheet using google scripts and javascript
I currently have the code in google scripts to create a data table based on my google spreadsheet. My goal however is to create multiple unordered lists in HTML with values pulled from each row of the ...
