LearnNowOnline

Learn your way! Get started

Google Apps Script, Part 8 of 9: Mini and Web App

with expert Laurence Svekis

Watch trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
Release date 11/30/2021
Level Advanced
Runtime 4h 14m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Learn Google App Script from top to bottom to interact with Google Services. This course covers: using app script in some mini projects with triggers, user interface, documents and radio buttons.

Prerequisites

HTML, CSS, JavaScript are strongly recommended Some programming Background Understanding of web technologies and how websites work Google Account

Meet the expert

Providing Web development courses and digital marketing strategy courses since 2002. An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web & application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about ;everything to do with web application development, programming to online marketing with a strong focus on social media and SEO.

Course outline

Module 14

Mini Apps Code Examples (19:39)
  • Introduction (00:08)
  • Mini Apps Code Examples (01:44)
  • Create Charts in Sheets (10:34)
  • Create Charts in Sheets Continued (07:05)
  • Summary (00:08)
Charts to Slides Create (21:50)
  • Introduction (00:08)
  • Charts to Slides (10:19)
  • Slides as PDF in Drive (05:11)
  • Force Create PDF (06:02)
  • Summary (00:08)
UI Tester Docs (20:50)
  • Introduction (00:08)
  • UI Tester Docs (06:03)
  • Using Event Details (05:34)
  • UI Tester Sheets (08:56)
  • Summary (00:08)
Sheets Simple Triggers (24:19)
  • Introduction (00:08)
  • Sheets Simple Triggers (06:34)
  • onSelection Triggers (06:32)
  • onGet onPost Simple triggers (05:39)
  • doPost (05:16)
  • Summary (00:08)
Apps Script Triggers (18:22)
  • Introduction (00:08)
  • Apps Script Triggers (08:46)
  • Script Trigger (09:19)
  • Summary (00:08)

Module 15

Code Examples Mini Projects (19:28)
  • Introduction (00:08)
  • Code Examples Mini Projects (02:04)
  • Multiple Page WebApp Introduction (04:10)
  • Multiple Page WebApp templates (12:57)
  • Summary (00:08)
Multiple Page Web App (23:44)
  • Introduction (00:08)
  • Dynamic Content (06:19)
  • Select Page Elements (06:37)
  • Add a Menu (04:23)
  • Update Menu (06:06)
  • Summary (00:08)
Introduction Document UI File (22:35)
  • Introduction (00:08)
  • Introduction Document UI File (02:48)
  • Document UI File templates (09:31)
  • Build the Client Side interaction (09:59)
  • Summary (00:08)

Module 16

Docs and Client Side Interaction (21:15)
  • Introduction (00:08)
  • Docs and Client Side Interaction (05:38)
  • Debug Docs Script (07:18)
  • Docs Interactive Project (08:02)
  • Summary (00:08)
Custom Sheet Quiz Web App (24:38)
  • Introduction (00:08)
  • Custom Sheet Quiz WebApp (04:00)
  • App Setup (10:39)
  • Sheet Data to Client Side (09:41)
  • Summary (00:08)
Add Questions with RadioButtons (38:08)
  • Introduction (00:08)
  • Add Questions with RadioButtons (08:19)
  • Radio Button Labels (07:57)
  • Submit Form to Sheets (08:58)
  • Add Data to Sheet (06:14)
  • onSuccess (06:22)
  • Summary (00:08)