56,983 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
4
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 ...
0
votes
0
answers
14
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 ...
0
votes
0
answers
33
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 ...
-2
votes
0
answers
33
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 '...
-3
votes
1
answer
37
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=...
-2
votes
0
answers
75
views
IF conditions are not being repected [closed]
I have a problem with google apps script to update google spreadsheet based on four IF conditions as follow:
After locating the row where submitted booking ID matches with one of all booking IDs:
If ...
-1
votes
1
answer
66
views
Google sheet extension showSidebar problem
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 ...
5
votes
1
answer
194
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 ...
-4
votes
0
answers
65
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 ...
0
votes
2
answers
36
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 ...
-1
votes
0
answers
28
views
Replace headers and footers across multiple Google Docs from a template using Apps Script [closed]
I have a Google Docs template with:
A branded first‐page header (logo, text, etc.) with "Different first page" checked
A footer that will appear on all pages, including the first page.
I need to ...
1
vote
2
answers
85
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 ...
1
vote
1
answer
31
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 = ...
-1
votes
0
answers
24
views
Is it the bug? "Manage Deployments" -> "New Version" erroneously archives active deployment and creates a new "Untitled" instance [closed]
Component: Apps Script > Deployment / Web App
Description: I am experiencing a critical issue with the "Manage deployments" feature in the new Apps Script editor. When attempting to ...
-1
votes
0
answers
25
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 ...