All Questions
28 questions
0
votes
0
answers
54
views
Syncing two folders
I created custom script to sync data from 2 folders in Google Drive.
To be blunt this is due to me emulating gameboy/gameboy advance on both android device and PC.
The emulator on PC works fine for ...
0
votes
1
answer
82
views
Based on a Google Form Submitter's name, create a folder, rename the files and relocate those files to that created folder
I am trying to create a Google Apps Script that allows me to do the following.
My Google Form looks like this:
What is your company name.
Submitt your company logo.
Submitt your company photo.
...
- 11
0
votes
1
answer
106
views
Google Forms Script to save txt files on Google Drive
I need help with a script to save each response from a Google Form in a separate TXT file in my Google Drive. I'm stuck at line 3: I'm getting an error in var responses = e.values
Debug:
TypeError: ...
0
votes
0
answers
29
views
CSV Produced by Google Script is Not Updated When Triggered?
I have a google script that calls an API every day. When I run the script manually it overwrites the current files in my google drive with the most recent daily data from the API. I have set up a ...
0
votes
0
answers
37
views
Trigger to input sub-subfolder names from Google Drive into Google Sheets
My goal is to:
Create a trigger to automatically input/update the names of sub-subfolders as a cell in google sheets in a google drive folder every time a change happens in the gdrive folder i.e. a ...
- 1
0
votes
1
answer
116
views
Why are created files not owned by the final owner after transferring Google Sheets ownership using Google Apps Script?
I've developed a google spreadsheet with associated apps script, which creates files in google drive. Manifest (appsscript.json has of course been updated accordingly).
When running script, created ...
1
vote
0
answers
60
views
Time-driven Trigger not running on Apps Script but Manual running of the function script works correctly
I used a script to backup all my Google Docs, when running the function it works correctly and makes a copy. But when setting up a time-driven trigger it doesn't run but says that it does.
Project ...
2
votes
1
answer
73
views
How to print Google Drive folder name in the cell automatically by pasting the folder ID on adjacent cell
How to print Google Drive folder name in the cell automatically by pasting the folder ID on adjacent cell in google app script on Google Sheets.
Suppose I have two cells A1 and B1, is it possible to ...
0
votes
1
answer
360
views
Function doesn't trigger after Yes/No alert prompt selection
Working in a sheet with Google Apps Scripts.
When the page loads (onOpen), I have a YES_NO alert box display. When the user clicks YES, the conditional IF statement works up to, but not including any ...
0
votes
1
answer
52
views
Google form uploaded files need to be grouped in one folder automatically
I have a Google Form that allows users to fill business details and then add JPG files at the end of the form. I need a Apps Script that:
Creates a folder in Drive. The name of the folder should be ...
- 1
0
votes
1
answer
742
views
Rename the value of a file according to value of a cell inside a spreadsheet
Basically is I have a sheet which control de name of other files :
Inside "source sheet" I have the cells in column A, which I put new names and cells in columns B, which contains the ID of ...
- 209
-1
votes
1
answer
142
views
Delete more than a month old back files from google drive using apps script?
I am taking backup for sheets every week to back folder by doing below code. Now I want delete older filer more than 1 month to delete. how to add script which delete old files to from the backup ...
- 11.7k
2
votes
1
answer
2k
views
folder.getFiles is not a function error in Trigger
When I run my function in Apps Script its working fine but when I add it in a trigger this error always occurs in first run.
TypeError: folder.getFiles is not a function
This is the code. I use this ...
- 23
1
vote
0
answers
85
views
Add-on triggers duplicate and stack a card that navigates back (🡠) to itself
Building a Workspace Add-on for Google Drive, that lists files.
To my knowledge, this required two triggers.
homepageTrigger - when no files are selected
onItemsSelectedTrigger - handling selected ...
- 510
1
vote
1
answer
2k
views
How to trigger Google Apps Script on file creation in Google drive?
I'm just new to everything about this. I created an Apps Script Project just by inside a Google Drive folder, so I did not use a Spreadsheet to create the project.
I created a function that is, when ...
- 21