All Questions
8 questions
1
vote
1
answer
3k
views
forEach loop in google scripts
I had a function that did what I wanted for one row at a time. Now I want to apply that to multiple rows so I'm trying to use a forEach loop. I'm not throwing errors, but I'm also not getting what I ...
- 13
0
votes
1
answer
154
views
Move, Remove, and Replace information from Google Sheets with new entries using Google Script
I have created a Google Form that logs Timestamps, a numerical value, and an image file from its respondents to a Google Sheet. The image files are saved to an "imageFolder", but when I get too many ...
0
votes
1
answer
137
views
Return the row number of the last non blank cell, comparing from the first row of a column until the current row, using an array formula
I've extensively searched about this and I've achieved a good level at all, but I haven't achieved my desired goal: Return the row number of the last non blank cell, having the evaluation range for ...
- 411
0
votes
1
answer
374
views
Difference between array in row and columns
I'm trying to move the content of column B3:B11 (range) to a column determined by the number of day in month at cell C3 (day). For each day in month (reeksorg) cell D2 contains: 1, E2: 2, F2: 3; up-to ...
0
votes
1
answer
522
views
How to display a 2-D array as an html table for a Google Web App Page (using GAS)
Using a code.gs file, I have retrieved data from a Google Spreadsheet and put it into a 2-D array, and then manipulated the array a little bit (with things like transpose, condensing it, etc.).
I am ...
- 3
1
vote
1
answer
5k
views
Google Scripts fill array of values and their locations from cells
I'm using Google Scripts to manipulate the values in a spreadsheet. Here's what I've got:
var Habits = sheet.getRange("C5:D100");
var HABITS = [Habits.getCell(1, 2).getValue(),
Habits....
- 2,295
1
vote
1
answer
813
views
Google Spreadsheet to PHP script modification
I've found this useful script to convert Google Spreadsheets into array.
https://github.com/VernierSoftwareTechnology/google-spreadsheet-to-php-array/blob/master/google-spreadsheet-to-array.php
The ...
- 682
1
vote
1
answer
938
views
Importing CSV to Google SpreadSheet but I need an additional column in the middle of the csv array
I have code listed below of reading in a csv file and putting it into an array to be pushed onto the spreadhsheet. However, the csv file that I will be reading in needs an additional column in the ...
- 13