56,991 questions
0
votes
0
answers
29
views
Pull Multiple Choice Grid answers from a Form, and insert that data to a Doc template and create a PDF [closed]
I am new to app scripts and trying to auto generate a PDF after a Forms submission. The Form has Short Answer, Date, Multiple Choice Grid, and Uploaded photo questions. I currently can only pull the ...
0
votes
1
answer
37
views
Why does Google Apps Script return unspecified error when authenticating tester of Docs formatter?
I have a simple script for iterating over files in a directory in my Google Drive and applying regexes to Google Docs. Recently I have been prompted to revise permissions on execute, and when I select ...
- 1
-3
votes
0
answers
104
views
Send a confirmation Email onFormSubmit in Google Forms [closed]
I am a beginner with Google App Script and JavaScript.
I am trying to send a confirmation email using the onFormSubmit trigger in Google Forms. The code is connected to the trigger and has been ...
- 1
0
votes
1
answer
54
views
Using Apps Script to forward emails - can I make them show in Inbox?
When I get a certain type of email, I need it auto-forwarded to a certain address with a specific cover message. So I wrote a script that scans that inbox and uses the "forward" method to ...
- 1
-1
votes
0
answers
57
views
Apps Script Bug - Can't copy script into folder, or write a script to create a script [duplicate]
I am creating a Drive backup system in Apps Script, and all goes well.
Except, when I try to copy files of type "application/vnd.google-apps.script" into a specific folder using something ...
1
vote
0
answers
37
views
Adding a confirmation mesage broke my script [duplicate]
It is true - this is the same problem as referenced above - a Google Sheets issue with SpreadsheetApp.getUi();
I have a script on a Google Sheet which clears out old data
function ...
- 23
-2
votes
0
answers
54
views
suddenly If( statements are triggering persistent 'Working' image [closed]
My script has been working with no issues for months however suddenly
All If statements in my App scripts are triggering persistent spinning 'Working' image.
My scripts complete successfully but the '...
-4
votes
1
answer
60
views
Change custom view based on value [closed]
Need some help with google sheets. The ability to changes files automatically based on value in cell A1
https://docs.google.com/spreadsheets/d/166yZQOgOZhLKoRxekNeIGUGWL91Sz3TOxHvHk-NM6n0/edit?usp=...
- 6,000
-1
votes
1
answer
98
views
Google sheet extension showSidebar problem [closed]
My Google App Script has a design with two layers of HTML switching, as follows:
The user clicks on the UI to open the sidebar (index.html). The user can then select the desired feature, which ...
- 3
5
votes
1
answer
484
views
Google Sheets Apps Script "Working" does not disappear
For the last couple of days, whenever I call an Apps Script function there appears a small black window in the bottom centre of the sheet displaying a couple of spinning semi-circular arrows followed ...
- 43
-4
votes
0
answers
97
views
Delete selected rows in Google sheet [closed]
Using an app script, I am already automatically deleting all rows from a Google sheet that are older than a specific number days. Now I want to also automatically delete selected rows in the sheet.
I ...
- 1
0
votes
2
answers
52
views
passing a date object to a google app script function
This seems weird.
I have a cell a1: containing [Jan 1, 1984].
I have a function xxx
function xxx(d) {
return d;
}
if I try this in a cell like
=xxx(a1)
that returns 1
no matter what the year is.
if ...
- 2,907
1
vote
2
answers
100
views
Export data columns to text files named via cell reference?
I would like to export columns from a Google sheet such that the exported .txt files are named after the column heading. Is it possible to change the value of "column" + index below to be ...
- 13
1
vote
1
answer
42
views
I am trying to use the value in a cell as an address to paste to another cell in google sheets via apps scripts. Use cell F8 which = C6 to paste to C6
I would like to paste from one tab to the address of a cell in another tab, where the value changes.
The problem I'm trying to solve is: how do I write the Apps Script code so that:
var spreadsheet = ...
- 13
-1
votes
0
answers
29
views
Apps Script custom function result in Google Sheets being cached for cells where it has already been evaluated [duplicate]
Google Apps Script/Google Sheets issue...
The custom function in code.gs:
function SHEETNAME() {
return SpreadsheetApp.getActiveSheet().getName();
}
Then in Sheet1 cell A1 put:
=SHEETNAME()
A1 ...
- 1,131
