Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Beginner Apps Script
Introduction
Course Introduction (2:57)
Templates
Join the Course Community
Course Index
Foundations
First Apps Script Example: Macros (6:22)
Second Apps Script Example: Invoice Button (11:01)
Apps Script Conventions (14:20)
Apps Script Shortcuts (6:35)
Apps Script Comments (14:17)
Apps Script Logging (11:57)
Apps Script Permissions (8:46)
Variables
var variables (10:38)
let variables (8:37)
const variables (8:21)
Data Types
Numbers (21:33)
Strings (11:22)
Boolean (7:14)
Conditional Logic
Equality (are things equal?) (11:20)
Truthy and Falsy (8:18)
If, Else Statements (17:24)
Ternary Operators (6:01)
Functions
Introduction (8:12)
Parameters and Arguments (9:08)
Arrow Functions (8:05)
Objects
What are Objects? (11:35)
Properties and Methods (10:22)
Nested Objects and Destructuring (14:18)
Modifying Objects (3:23)
Merging Objects (4:56)
Arrays
What are Arrays? (10:20)
Accessing Arrays (11:47)
Destructuring Arrays (7:15)
Adding Elements to Arrays (18:18)
Removing Elements from Arrays (9:24)
Reversing and Sorting Arrays (6:06)
2-D Arrays and Flattening Arrays (4:48)
Merging Arrays (3:56)
Loops: Iterating Over Arrays and Objects
forEach (9:15)
Filter (7:32)
Map (6:49)
Reduce (10:24)
Some and Every (5:34)
Find (4:16)
For, For Of, While, and Do While (12:08)
Object Looping (10:00)
Apps Script Specific Topics
Services and SpreadsheetApp Class (8:55)
Standalone vs. Container Bound (8:44)
Understanding Apps Script Execution (6:14)
Multiple Apps Script files (9:30)
Apps Script Quotas & Limits
Working with Sheets
Getting data in and out of Sheets (22:34)
Formatting (14:14)
Creating Formulas (12:14)
Filters and Pivot Tables (16:30)
Charts (11:27)
Backup Data I (8:35)
Backup Data II (to a new Sheet) (8:14)
Copy Chart Tool (11:08)
User Interfaces
Buttons (4:10)
Custom Menus (8:20)
Toast (4:07)
Alert Dialogs (8:32)
Prompt Dialogs (8:03)
Custom Dialogs (13:38)
Simple Sidebars (11:25)
Template Sidebars (16:27)
Projects
Threshold Trigger (19:16)
Calculate Metrics from Highlighted Range (16:11)
Tab Manager (22:50)
Checklist V1 (26:35)
Checklist V2 (23:54)
Automated Data Cleaning (31:41)
Automated Data Cleaning Code Review (6:49)
Sidebar Range Picker (33:38)
Next Steps
Congratulations
A small ask from me... (Testimonial)
Strings
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock