Academy ↓
Hey there stranger!
Sign up to get access.
Spreadsheet Automation 101: Dot Notation
About this Tutorial
Video Transcript
0:09 We usually see it when we use the function app spreadsheet app. You'll see that'll be the first time you see it.
0:15 So we'll do something like this. Again, I'm gonna go through this later. And when we get to the end of this word, we add a note a dot.
0:25 This.is a a period, right, is a, in our keyboard. It's just a period, but we can call it a dot.
0:33 And what it allows us to do, especially in app script, we get this auto fill options, which is really, really helpful.
0:43 But what it allows us to do is take the spreadsheet app, the entire thing that it exists and, and we'll get into that later and figure out what is the one thing we wanna do from this.
0:54 We wanna do one action from this spreadsheet app. It gives us sort of a little bit of a way to go into the spreadsheet app.
1:05 We use we'll use in the first time when you see this active spreadsheet. There it is. And then when we get to spreadsheet app dot get active spreadsheet, we can add another dot.
1:18 And this allows us to see what's inside of Get active spreadsheet that we can use. And we'll usually use Get Sheet by name.
1:26 Again, we'll add another.at the end. And again, we're inside of whatever the sheet is that we've added. So the dot notation just I wanted to point out, allows us to go deeper and deeper into the functions that allows us to do much, much more specific things.
1:44 Dot notation is incredibly important because you might want to add commas, you might wanna do other syntax, but in this particular case in Cript, we're just gonna be using dots or periods to go deeper and deeper into all of our functions.
2:00 This also appears when we're, wherever parsing j json or trying to get sort of a big text document. And we, we'll use the dot notation as well there to go deeper and deeper inside.
2:11 And that's pretty much the basic idea. That Dot notation goes deeper and deeper inside into the functions that you're using.
2:19 Right. Bye.
Courses
Spreadsheet Automation 101: Introduction to Pre-course Videos
Breaking Through Errors In Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Tips to Navigating Thousands of Lines of Code In Apps Script
Spreadsheet Automation 101: Functions
Spreadsheet Automation 101: Variables
Spreadsheet Automation 101: Dot Notation
Spreadsheet Automation 101: Camel Case
Spreadsheet Automation 101: Parentheses
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu
This Seems Like Automation
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction
Spreadsheet Automation 101 Lesson 2: Arrays
Spreadsheet Automation 101 Lesson 2: For Loop
Spreadsheet Automation 101 Lesson 2: Bracket Notation
Spreadsheet Automation 101 Lesson 2: Logger.log()
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger
Introduction to Spreadsheet Automation 101 Lesson 3
Spreadsheet Automation 101 Lesson 3: MailApp
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Automatically Clear Content | Refresh Reuse Recycle Templates
Automate Google Sheets With Zero Experience
Automatically Uncheck A Daily Checklist
Activate A Certain Sheet When Opening a Spreadsheet
Scoping Functions in Apps Script