All Questions
11 questions
0
votes
1
answer
52
views
Google Scripts, script disabled
I am new to writing some scripts. I have this function right here, that i created. It always comes with an interval of 2 hours. Everytime, that the trigger was used, it gets disabled. I have to delete ...
- 1
0
votes
1
answer
112
views
if (e.changeType == "INSERT_GRID")... Undefined local variables [duplicate]
In the following code it tells me inside the function that the local variables are not defined, when it worked before.
I'm looking to be able to debug the code so that it works again, when a trigger ...
- 1
0
votes
1
answer
151
views
onEdit trigger 'failed' or 'timed out'
I have created an attendance system using the basic script to copy data from the attendance form(Mark attendance and paste it to the response sheet(Form Responses 1). There are two ways to submit the ...
-1
votes
1
answer
36
views
Sorting multi column range script
Here is a well working script which :
1- Drop a date tag in the cell H (8) for each modification in a row (I know there is something wrong in this command but it does what I am expecting...)
AND
2- ...
-1
votes
1
answer
95
views
Identify duplicated values in the same columns across undefined sheets using Apps Script
I have a spreadsheet that is growing undefined in number of sheets.
I want to highlight duplicated values in the same columns across all undefined sheets.
I can do it with conditional formating, but ...
- 3
1
vote
0
answers
67
views
calling function from within function not working
I am very new to app scripts. What I would like to do is to create a pop up message in google sheet, when proposal probability is goin above 75% - directing the user to go to a google form to fill.
...
- 11
-1
votes
1
answer
231
views
How to Update a workbook sheet data in google sheets from other different workbook sheet(s)?
In google drive, I have two different workbooks/files,
let's call them this:
Workbook (A)
Workbook (B)
Workbook (B) has 3 different sheets included (Sheet 1, Sheet 2, Sheet 3)
with cells "A1", "B1", "...
- 73
0
votes
1
answer
37
views
Is there a limit to the number of triggers you should set up in GAS?
I have a spreadsheet document that is acting as a contract template for my company and we are using a lot of GAS to make it interactive and to automatically populate other databases. The document will ...
- 1,585
1
vote
0
answers
764
views
Error 'Action not allowed' when running script to create trigger (Google Script)
I need to add a trigger via a function as I have a spreadsheet which will be copied many times, and I understand that the triggers entered via the menu do not copy.
I have the following function I ...
- 1,585
19
votes
2
answers
58k
views
use onedit() trigger on a specific sheet within google scripts for google sheets
I need to run a script triggered by an onedit() to only one sheet of many.
I have tried the following, but currently I can't get the script to work on just the desired sheet ("Inventory") Im sure ...
- 347
1
vote
2
answers
11k
views
TypeError: Cannot read property "values" from undefined. (line 9, file "Code")
function onInstall(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('Form');
var Timestamp = e.values[0];
var Load = e.values[1];
var Email = e....
