Lynda - Up and Running with Google Apps Script
Lynda - Up and Running with Google Apps Script
English | MP4 | 960x540 | AVC 1138 Kbps 30.000 fps | AAC 160 Kbps 48.0 khz | 1h 10mn | 185 MB
Sample Files: present
Genre: Video Training
English | MP4 | 960x540 | AVC 1138 Kbps 30.000 fps | AAC 160 Kbps 48.0 khz | 1h 10mn | 185 MB
Sample Files: present
Genre: Video Training
Meet Google Apps Script, the master key that unlocks the power of Google Apps. This JavaScript-based language allows you to access Google Apps data, automate tasks, and build your own applications. Join Scott Simpson as he introduces the Google Apps Script environment; defines the common script types, permissions, and classes; and dives into scripting services. Learn to access and edit data from documents and spreadsheets, use cloud storage, set up events and triggers, and create user interfaces like dialogs. Plus, learn to publish and share your script as a web app. At the end of the course, Scott challenges you to pull all the lessons you've learned together and build an app based on some simple parameters.
Introduction 4m 23s
Welcome 52s
What is Google Apps Script? 1m 29s
What you need to know before continuing 1m 24s
Using the exercise files 38s
1. Navigating the Google Apps Script Platform 6m 28s
Understanding script types and permissions 1m 44s
Working with the online integrated development environment (IDE) 3m 26s
Using the online documentation 1m 18s
2. Working with Apps Services 17m 29s
Creating and editing a document 5m 46s
Accessing and editing a spreadsheet 2m 33s
Reading information from a spreadsheet 2m 58s
Working with files in Drive 3m 10s
Working with email 3m 2s
3. Working with Script Services 16m 45s
Storing data for your script 5m 40s
Using external data 3m 20s
Using events and triggers in containers 2m 41s
Building custom spreadsheet functions 1m 34s
Building user interfaces 3m 30s
4. Working with Web Apps 19m 2s
Sharing your script as a web app 7m 8s
Using Google data in your web app 3m 5s
Serving JSON or XML from your script 4m 53s
Publishing your app in the Chrome Web Store 1m 52s
Using Advanced Services: URL Shortener 2m 4s
5. Putting It All Together 4m 38s
Challenge: Building an app to create folders on Google Drive 28s
Solution: Building an app to create folders on Google Drive 4m 10s
Conclusion 1m 40s
Next steps 1m 40s
Welcome 52s
What is Google Apps Script? 1m 29s
What you need to know before continuing 1m 24s
Using the exercise files 38s
1. Navigating the Google Apps Script Platform 6m 28s
Understanding script types and permissions 1m 44s
Working with the online integrated development environment (IDE) 3m 26s
Using the online documentation 1m 18s
2. Working with Apps Services 17m 29s
Creating and editing a document 5m 46s
Accessing and editing a spreadsheet 2m 33s
Reading information from a spreadsheet 2m 58s
Working with files in Drive 3m 10s
Working with email 3m 2s
3. Working with Script Services 16m 45s
Storing data for your script 5m 40s
Using external data 3m 20s
Using events and triggers in containers 2m 41s
Building custom spreadsheet functions 1m 34s
Building user interfaces 3m 30s
4. Working with Web Apps 19m 2s
Sharing your script as a web app 7m 8s
Using Google data in your web app 3m 5s
Serving JSON or XML from your script 4m 53s
Publishing your app in the Chrome Web Store 1m 52s
Using Advanced Services: URL Shortener 2m 4s
5. Putting It All Together 4m 38s
Challenge: Building an app to create folders on Google Drive 28s
Solution: Building an app to create folders on Google Drive 4m 10s
Conclusion 1m 40s
Next steps 1m 40s
General
Complete name : 1. Welcome.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 8.12 MiB
Duration : 52s 333ms
Overall bit rate mode : Variable
Overall bit rate : 1 302 Kbps
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Writing library : Apple QuickTime
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 52s 333ms
Bit rate : 1 138 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 fps
Standard : PAL
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.073
Stream size : 7.10 MiB (87%)
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 52s 245ms
Bit rate mode : Variable
Bit rate : 160 Kbps
Maximum bit rate : 163 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 1 020 KiB (12%)
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Other #1
ID : 3
Type : Object description
Format : System Core
Codec ID : 2
Duration : 52s 333ms
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
mdhd_Duration : 1000
Other #2
ID : 4
Type : Scene description
Format : System Core
Codec ID : 2
Duration : 52s 333ms
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
mdhd_Duration : 1000
Complete name : 1. Welcome.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 8.12 MiB
Duration : 52s 333ms
Overall bit rate mode : Variable
Overall bit rate : 1 302 Kbps
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Writing library : Apple QuickTime
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 52s 333ms
Bit rate : 1 138 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 fps
Standard : PAL
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.073
Stream size : 7.10 MiB (87%)
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 52s 245ms
Bit rate mode : Variable
Bit rate : 160 Kbps
Maximum bit rate : 163 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 1 020 KiB (12%)
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
Other #1
ID : 3
Type : Object description
Format : System Core
Codec ID : 2
Duration : 52s 333ms
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
mdhd_Duration : 1000
Other #2
ID : 4
Type : Scene description
Format : System Core
Codec ID : 2
Duration : 52s 333ms
Language : English
Encoded date : UTC 2013-09-12 21:36:40
Tagged date : UTC 2013-09-12 21:36:40
mdhd_Duration : 1000
Screenshots
Lynda - Up and Running with Google Apps Script
Lynda - Up and Running with Google Apps Script
Lynda - Up and Running with Google Apps Script
Lynda - Up and Running with Google Apps Script
