Tour of the new Apps Scripts editor and IDE

Apps Script is an application development platform that empowers citizens and well-seasoned developers alike to streamline their workflows. In this episode of Sheets to Apps, we demo the new features in Apps Script - such as the Apps Script editor and the new Integrated Development Environment (IDE). Watch to learn how the functionality of Apps Script has been improved and how you can use it!

Timestamps:
0:00 - Intro
00:30 - Macro recorder
00:38 - Visit the code editor
00:46 - Products you can use Apps Script
00:56 - Components of the Apps Script IDE
01:30 - New material design-based UI
01:38 - Spacing, collapse code, move files, syntax error icon
02:00 - Library of actions
02:15 -New autocompletion features (documentation pop-up & user-defined functions)
02:39 - Explicit indentations in editor (spaces & tabs)
02:46 - Rename variables in bulk
03:05 - Customize editor ex: dark mode
03:14 - New streaming logs
03:54 - New debugging features
04:50 - Enabling other Google services
04:57 - Options for deploying a script
05:36 - Connect script with Google Cloud compute resources
05:56 - Returning to legacy view (presently available as of Dec 2020 butcan change)
06:17 - Visual summary of key new features launched

Product: Apps Script; fullname: AGV;

#SheetsToApps #CustomizingGoogleWorkspace

[trappedcat]

This is amazing. 5 stars for the new exection log and dark mode.

[prahladpai]

@google, We definitely need the following two things.

1) Ability to change the timezone setting.
2) Access to the Property Service like in the legacy editor.

[happylife]

The new Apps Scripts editor has improved on the legacy one in some aspects, but created some bugs/problems that the legacy one didn't have. For example, Logger.log() or console.log() does not display the output in the Execution Log in callbacks either in web app or spreadsheet app. In addition, the callback in the addEventListener didn't seem to work. Pls advise where I send those questions/bugs to and get some answers from. Thanks.

[manohardev]

This is great overview. Thanks. Is there a way to change the editor to dark mode?

[ahmetustunt]

Is there a way to collapse the side-bar where Files are located? In the Legacy mode, it was done with a quick slide to the right side, but here it stops at one point. It can be a good feature as some people prefer a clean screen (especially if you have a small monitor :D)

[virtualintelligencebriefin]

How do you find text across all files? It was there in legacy editor but cannot find it in new editor. Such a useful thing is omitted

[dennistucker]

I come from a Excel/VBA background. Why doesn't the App Script IDE include a WYSIWYG web form editor?

[plavali_znaem]

Hi, just wondering: is that possible to create some app with Google Apps Scripts, where user can type in some user data, and it would be saved into a database?
And, in addition, is that possible to create a database via Google spreadsheets with foreign keys (in such a way, that tables are linked with each other via a certain column, and when a user fills in a column "user" in a table A, it is also gets filled in the table B, given that A and B are connected via "user") ?

[bocobox]

I don't see any of IDE in my app script. is there something I need to do to get it done?

[KuyaRicOfPRU]

Good day! Can you make tutorial on how to make RESPONSIVE PRODUCT CARDS on webpage using Google Sheets & Apps Script?

[alexandremartin]

Is google apps scripts covered by any SLA?

[markreyes]

My browser says that app script is not a secure third party app. Is it safe to give permissions?

[ArjanGroenenboom]

Is there a way to switch to dark mode for the entire page? Now only the edit window is dark, the large white spaces above and left of the window are kind of annoying

[CesarPeron]

where is the manage version tool from the older GUI????