All Questions
6,108 questions
0
votes
0
answers
50
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
66
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
-2
votes
1
answer
110
views
How to sort a 2d array in Apps script (google sheet) base on a 1d array
I have a script that I have been using for some time, but I recently had a bug on the data sorter and since then I have been unable to fix the problem.
I transpose arrays because they are normally ...
1
vote
1
answer
78
views
Processing multiple .csv files
I've been working on a process of batch importing the data from multiple .csv files on my computer into Google Sheets without uploading all of them to Google Drive first.
I currently have the ...
- 59
0
votes
1
answer
150
views
Redash to Google Sheets - Date parameters not being registered
I'm trying to write a script to send redash data to google sheets.
I've updated the script to use payload parameter instead of body and now it's showing me the following error:
{"message": &...
- 1
0
votes
0
answers
36
views
Google Sheets: Refresh =importhtml() faster [duplicate]
I am trying to import the leaderboard for the Masters into a google sheets document. I successfully did so using the following formula:
=IMPORTHTML("https://www.espn.com/golf/leaderboard",&...
- 1
0
votes
2
answers
66
views
Is there a way to pull a redirect link using apps script from google sheets?
I'm trying to create a google form that populates a google sheet. I have the form, "Gym Form A" and "Gym Form B" working but A won't automatically redirect to B.I have a macro that ...
- 1
-3
votes
2
answers
72
views
Event triggering
I can not run OnEdit(e) command in my Apps scripts.
Even with the code given below:
function onEdit(e) {
if (e) {
Logger.log("Event object (e) is not defined.");
if (e.range) {
...
-3
votes
1
answer
119
views
How to "Nest" (or combine) onEdit() functions
When I combined onEdit() functions
I'm now being told that,
SyntaxError: Identifier 'sheet' has already been declared line: 27 file: Code.gs
Please let me know how I create unique identifiers in ...
0
votes
1
answer
57
views
The csv import script in google sheet does not work with certain csv, why?
This script allows you to import a CSV from an email attachment into a Google Sheet. My resumes, I needed to use it to import CSVs from another collaborator. Unfortunately, the data in the first row ...
0
votes
1
answer
62
views
Is there a function to preserve the formatting when using apps script to input data from Google Sheets to Google Slides?
I am using Google Apps script to input data from Google Sheets to Google Slides. I am want the value and the formatting shown in Google Sheets to transfer over to Google Slides. For example: ...
- 13
1
vote
1
answer
80
views
I'm Having Trouble with a Google Apps Script Array to Update Sheet Cells
I need to update the values of cells. Whatever I try, it either coughs up an error, or only updates the value in the script temporarily, but doesn't update the cell.
Here is my array:
// A looping ...
- 15
0
votes
1
answer
58
views
I'm Having Trouble with a Google Apps Script Array to Iterate Thru Rows
So, I've been teaching myself JavaScript to use with Google Sheets to make little programs to improve my life for several months now (side projects). I'm working on a randomizing Dinner Picker right ...
- 15
1
vote
2
answers
86
views
Clear datestamp when checkbox is unticked
I am trying to change this code to say that when the checkbox is ticked provide a datestamp but when the checkbox is unticked - clear the datestamp
I have managed to get the datestamp to work on all 3 ...
- 11
0
votes
1
answer
60
views
How to solve Exception: Service error: Drive
I have this code that can copy and edit spreadsheet in the same parent folder. A few months ago it still work but now i get this error message
Exception: Service error: Drive.
Here's the code
var ...
