All Questions
12 questions
0
votes
3
answers
427
views
How to speed up Script to return all files from drive
i use a script to take all my files from drive to a google spreadsheet with name, url...
My problem is there are a lot of files and the script run during ~30 min and exceed during time permission for ...
- 37
1
vote
1
answer
410
views
Is it possible to use Google Apps Script to add different editors to copies of a master Google Spreadsheet?
I am working with Google Apps Script.
I have a master spreadsheet, of which I want to: make a number of copies, rename the copies, save them to a specified folder, and finally add a different editor ...
1
vote
1
answer
195
views
How do I make copy of spreadsheet and save it to particular folder then open the copy for edit
I have a code that creates a copy of the master sheet and saves it in a particular folder.
The reason for this is so that the person accessing the sheet does not mess up the main sheet but rather ...
- 437
0
votes
1
answer
132
views
Why won't the makeCopy portion of my script execute properly in Google Apps Script?
I am a very novice coder and am trying to accomplish the following using a Google Form:
Rename file uploaded by user based on name defined by combination of form fields
Create a copy of the uploaded ...
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
220
views
App Script debug success but execution failed.Why?
I need to import csv files into specified google sheets from App scripts. I developed a code which works perfectly, but it does not show any output. What I did was I created an array to insert a list ...
- 41
0
votes
1
answer
232
views
Drive API V3: wrong filesize on multiple-chunks resumable upload, using Google Apps script (2 bytes missing)
I have a Google apps script web-app that downloads the data associated with any Youtube channel's videos and save the result in a .CSV on the user's Google drive. Here are the main steps of the code:
...
- 512
0
votes
1
answer
587
views
Google Script Drive File Sizes to Spreadsheet - File Iterator Not Working
I am attempting to get a list of all the files I have in Google Drive into a Google Spreadsheet. I'm using the following code:
function driveFileSizes() {
var userProperties = PropertiesService....
- 55
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
1
vote
1
answer
121
views
Email All Rows in Single Email If Dates Match
Today I tried to write a script which email the information about all upcoming arrivals for todays and tomorrows dates in a single email. However, my script send each booking details (i.e., if it does ...
- 319
1
vote
1
answer
2k
views
Search Files inside Sub-folders in Google Drive
Unlike the DriveApp.getFilesByType() method that will only search for files in the immediate folder, i'm trying to also search for files inside the sub-folders.
Found this bloggpost about it, and ...
- 397
1
vote
1
answer
121
views
How do I directly assign values to an array but use push method on OOB exception?
It is my understanding that -- from a performance perspective -- direct assignment is more desirable than .push() when populating an array.
My code is currently as follows:
for each (var e in ...
- 2,029