All Questions
11 questions
0
votes
1
answer
223
views
Add a single cell's value to the first row of array being written via google script
Goal:
Use Google Script to write data from one sheet to another "database" sheet.
Current Status:
When the "Form" tab is filled out and the green button on the clicked, a script is triggered that ...
-1
votes
1
answer
415
views
Use Sheet Name as a Loop Parameter
DESCRIPTION:
I have a spreadsheet I call 'Applications' which is a schedule of services provided to clients and the dates these services were provided. I also have another spreadsheet called 'Daily ...
- 79
0
votes
1
answer
339
views
Google Apps Scripts Form service
I want to know if there is any function in google app script form service for adding another choice to another different question when the answer of the first question is a certain choice
source....
2
votes
1
answer
3k
views
Count if condition is met Google Apps Script
I have the following spreadsheet.
Spreadsheet
I need a script to count each agent email address (overall and based on client). I am struggling with arrays. I am new on scripting so still learning. ...
- 79
-2
votes
1
answer
324
views
Get second, third and so on values
I have this problem here
The problem has been solved, but my question is how can I get the second value from that, or the third one. The sheet will have many tables and at some point I will need a ...
- 79
1
vote
1
answer
242
views
Return row number is match error
I have some tables in one sheet and I need to make a script to send an email everyday. The script it search today date, match it into my table and return column number, then I looks for Total on the ...
- 79
2
votes
2
answers
2k
views
Search for value and return row number
I'm struggle with this script. I need to search for today date, once match it return column number (done!). I need a script to do the same with row number. The script I have is works fine if I keep ...
- 79
1
vote
2
answers
7k
views
Get last value from an array using Google Apps Script
I need to get last value from an array and I keep getting this error when I use slice
TypeError: Cannot find function slice in object Sun Jul 23 2017 00:00:00 GMT+0100 (BST). (line 15, file
If I ...
- 79
1
vote
2
answers
861
views
When i run my script nothing happens
So i recently found this google drive script and tried to use it.
The script should normally get file names and url on my google drive folder and copy them in a spreadsheet.
When i click Run, I get ...
- 77
0
votes
2
answers
274
views
Is there a way to run code up to a "certain point", quit, and then start running again without an interruption
My script gets data from a CSV file and then exports it to a Google Sheet. the CSV file consists of a 2D array and has 9000 + rows. My current script runs fine but give an error of
Incorrect Range ...
- 57
1
vote
1
answer
861
views
Automatic CSV output to google sheets using google script
can someone please tell me how to append imported CSV data in an existing googlespreadsheet. Once imported there is an empty row at the bottom and every time i run the code i would like it to insert ...
- 57