Stack Overflow
Stack Overflow

Questions tagged [google-apps-script-editor]

[Do not use alone] Use for questions about Apps Script Editor (web IDE from Google) only, not for questions about other IDEs. Use with tag [google-apps-script] and Google product and API tags (i.e. [google-sheets]) where applicable.

About

Apps Script Editor is a web IDE used exclusively for creating and managing Google Apps Script projects and their dependencies. It has built-in code formatting, log viewer, and debugger.

Use

For questions:

  1. about Google Apps Script Editor as a tool for managing script projects, including:

    • adding or removing dependencies (Libraries)
    • enabling and configuring Advanced Google Services
    • managing appsscript.json manifest file
    • migrating projects to and from and runtimes
    • running scripts directly from the editor
    • versioning, deploying and publishing of Web Apps and Add-ons

  2. about basic logging as opposed to Stackdriver logging

  3. about troubleshooting using the built-in debugger and breakpoints

Use with appropriate product tag if the question is about a container-bound script project:

Do not use

For questions:

  1. asking for help in debugging source code unless the execution context is specific to running the script in the Editor.

  2. about Apps Script Dashboard, use instead.

  3. about Stackdriver logging, use instead.

  4. about managing script projects with CLASP, use instead. Use both tags is about the interaction between them.

Useful resources

  1. Overview of Google Apps Script
  2. Guide on troubleshooting with Script Editor debugger
  3. Developer support documentation with info on the use of debugging tools
  4. Public Issue Tracker

Related tags

209 questions
24
votes
2 answers

Google app script desktop ide

I like to use google sheets with app script, but the online script ide is a hassle(lags...etc) and does not have many of the conveniences of a desktop ide. Hopefully, Google will make a desktop ide at some point. Does anybody know of a less painful…
prothan
  • 510
  • 1
  • 4
  • 10
16
votes
3 answers

How best to develop Google Sheets scripts and Git versioning

I am new to developing Google Sheets scripts. I have code forked from krlaframboise/SmartThings and would like to make some additions and commit those to my Github fork. I can obviously edit in the sheet script editor and paste those back to my…
Cord
  • 317
  • 2
  • 10
13
votes
8 answers

Can't log in to Google Apps Scripts

I'm using multiple Google accounts. In one of them (not default) I created Google Spreadsheet file and I want to create Script connected to it. Nothing complicated. But the problem is that after clicking Tools > Script Editor I'm being redirected to…
emendelski
  • 317
  • 2
  • 12
10
votes
2 answers

How to change Google Apps Script locale?

I created a Google Apps Script on the Google account, which had the Polish language set in the settings. Executing the script was causing some Google error message about exceeding quote Gmail rateMax, which was displayed in Polish. I shared this…
Michal Sz.
  • 171
  • 2
  • 8
9
votes
2 answers

Apps Script debugger won't let me look at values in objects (including arrays and block scopes)

I'm trying to debug an Apps Script project, and for the past 2–3 days, the debugger hasn't let me look at variables defined at the scope level. For example, I was trying to debug this code. /** * Deletes all rows in a sheet, excluding header rows.…
Michael Smith
  • 91
  • 2
9
votes
1 answer

How can I read the User properties saved in the File/Project properties menu?

In the Google Apps Script editor, I can set a user property by opening the File > Project properties menu, and then selecting the "User properties" tab. However, it seems that the PropertiesService is unable to access the values set in this menu. Is…
Diego
  • 9,261
  • 2
  • 19
  • 33
7
votes
2 answers

Execution Transcript missing with new Apps Script runtime powered by Chrome V8

When using the Google Apps Script editor and using the new Apps Script runtime powered by Chrome V8, the Execution Transcript under View is gone. I'm wondering, where did it go? Has it been replaced by something? Is it gone for good? I've…
Anax
  • 83
  • 7
6
votes
2 answers

Google Script editor opening with wrong account from Google Sheets

I'm logged into several Google accounts and I'm editing a Google Sheet with one of them (in Firefox). I select Script editor from the Tools menu to create a script for the spreadsheet. Google Scripts creates a new script, but under one of the other…
toby1kenobi
  • 1,609
  • 1
  • 14
  • 24
6
votes
1 answer

Google Apps Script V8 assignment to null cancels debugging

A variable assignment to null causes debugging to cancel execution at that line. Here is a test script that reproduces the problem: function myFunction() { var a = "Hallo"; Logger.log("a=" + a); var b = null; Logger.log("b=" + b); } When…
Tach
  • 61
  • 3
6
votes
2 answers

How to get JS script of a Google form?

I owned a google form, how can I get the js script of it? I click the Script Editor but there is no corresponding js I can find. I have already searched on internet but no expected answers. -- update on 20/08/2017 Assume that I owned a form like…
Bowen Xu
  • 3,836
  • 1
  • 23
  • 25
6
votes
1 answer

Google Spreadsheet: How can I leave the Script Editor open in another tab after refreshing a spreadsheet

Whenever I refresh a spreadsheet (after having changed some of its Apps Scripts code) with CMD - R, Safari closes the script editor tab automatically. How can I avoid that this tab is being closed?
AlexR
  • 5,514
  • 9
  • 75
  • 130
5
votes
1 answer

Access Google Apps Script editor from Android

I am searching for the answer for a couple of months now. Any browser redirects to downloading the Google Sheets app, which doesn't have the script editor. Stack Overflow redirects to a question about running script on Android, which is…
Fim
  • 123
  • 1
  • 9
5
votes
2 answers

Why does google script editor stop paren matching after 100 lines in a function and does it affect the code?

in google script editor function foo(){ . . . // more than 100 lines . . } clicking on { or } highlights both in red with less than 100 lines both are green. Does it affect the code or is it just there to confuse us.
MalcL
  • 109
  • 1
  • 4
  • 11
4
votes
2 answers

I want to get the values of a row of a spreadsheet based on the selected cell

I need to get all values of a row of a spreadsheet based on the cell that I have selected. Example: I have selected the Cell F1. Now I want the all value in that row (for example F1, F2, F3, F4, F5). What I tried: var selection =…
Justus_505
  • 45
  • 1
  • 5
4
votes
3 answers

No output from Logger.log(...) in Google Apps Script .gs file - what's wrong?

I have a bunch of server side code from which I log using Logger.log("message"). But one single .gs file does not log! Even with a statement as simple as this: function uploadFiles(form) { Logger.log("uploadFiles() Hello?"); ... } So simple…
jeff
  • 109
  • 1
  • 1
  • 9
1
2 3
…
13 14