Dynamic Quiz App using Google Sheets as source Google Script

1,993 students enrolled

Dynamic Quiz App using Google Sheets as source Google Script

Create your own web applications that uses Google Spreadsheet data to build quizzes and JavaScript to build the website

1,993 students enrolled

Created by Laurence Svekis

Last updated 11/2019

English

English [Auto]

Preview this course

Dynamic Quiz App using Google Sheets as source Google Script

$139.99 $199.99 30% off

5 hours left at this price!

30-Day Money-Back Guarantee

2.5 hours on-demand video
17 articles
4 downloadable resources
Full lifetime access
Access on mobile and TV

Certificate of Completion

Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business

What you'll learn

Connect website input form to Google Spreadsheet
Build a quiz application from scratch that uses Google Sheets as the data source
Add data from input form to Google Spreadsheet

+ – Introduction to creating web apps with JavaScript and Google Script

3 lectures 08:31

Dynamic Quiz App Introduction

Preview 02:26

Development Setup

Preview 06:04

Resources

00:01

+ – Get Spreadsheet data as JavaScript object

10 lectures 39:10

Spreadsheet Data as JSON.

05:21

JavaScript Fetch Data

05:15

Source Code Fetch

00:05

Get Sheet Data as Object

06:00

Get Sheet Data as Object 2

05:48

Get Sheet Data as Object 3

03:17

Source Code get sheet object

00:14

Multiple Sheets Promise All

05:48

Build your sheet data object

06:53

Source Code Get Sheet Data

00:28

+ – Build your web application generate elements

16 lectures 52:35

Client Side Create HTML from Data

06:12

Source Code Client Side Create HTML from Data

00:34

Create Quiz Questions

03:22

Source Code Quiz Question loading

00:38

Create Questions JavaScript

07:21

Output Answers to Questions

05:49

Source Code output build elements

01:02

Add styling to output

02:40

Source Code index html with style

00:14

First Run Output Builder

Preview 01:43

Check Answer Scoring

05:19

Source Code with scoring

01:15

Game Over handling

05:33

Source Code with game over

01:22

Quiz Gameplay review

08:07

Source Code section final code

01:22

+ – JavaScript Create a Quiz Application

13 lectures 55:13

Create Your Quiz

04:09

Apps Script Setup - Use this

05:55

Apps Script add to Sheet

09:05

Source Code update sheet

00:24

Connect to WebApp AJAX

05:04

Source Code create html

00:10

JavaScript Form Builder

07:33

Source Code with builder create html

00:25

Form Data Post

08:48

Source Code with post method

00:36

WebApp Post Formdata

04:26

Quiz Creator Review and Tweaks

07:08

Source Code Google Script and create file

01:29

+ – Conclusion Extras

3 lectures 11:05

CORS error Debug.

06:08

doGet Method

03:44

Bonus Lecture

01:13

Requirements

Internet connection
Google Account
Fundamental JavaScript Knowledge

Description

Build your own Dynamic and interactive quiz that uses only Google Sheet data to output the contents of the quiz, and JavaScript on your web page or website. You will be amazed at what you can do with just a few lines of code and how easy it is to connect Google Sheets to your website. This is a great solution to avoid backend code using only Google Script which is essentially JavaScript with a bunch of methods in the cloud.

No database - only JavaScript skills is a prerequisite for this course.

Power up your web applications - made easy - no magic just code ;)

All the source code is included

New to apps script - don't worry its like JavaScript : Apps Script is a scripting language based on JavaScript 1.6, which gets executed in the Google Cloud.

JavaScript developers extend your knowledge and learn how you can use your skills to develop apps script bringing together all the power of Google's Apps.

Google Apps Script : is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides subset of ECMAScript 5 API however instead of running on the client, it gets executed in the Google Cloud. According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services."Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides."

If you haven't tried it yet, I guarantee you will be BLOWN AWAY at how powerful Google Script can be, and at how easy it is to write. With just a few lines of code you can DO A WHOLE LOT!!!

Don't take my word for it try it and see.

Taught by an instructor with over 20 years of web development experience, ready to help you learn and answer any questions you may have.

What are you waiting for this course is perfect to start writing Google Script and to practice writing Google Script, you have nothing to lose.

Who this course is for:

Anyone who wants to practice Google Apps Script
Anyone who wants to practice using Google Script to build a fun interactive application
Anyone who wants to be able to explore the power of what can be done with Google Script
Anyone who wants to learn more about what Google Script can do
Update and use Spreadsheet data within your website
Anyone who wants to learn about Google Apps Script
JavaScript developers who want to extend their knowledge
Application developers

Featured review

Guillermo Ithier ( 126 courses, 10 reviews )

7 months ago

This course covers the skills needed to work with Google Suite products particularly Google Sheets. Laurence is clear with all of his explanations and is very responsive to all questions you may have. I would recommend this course to anyone wanting to learn how to create apps that help you work more efficiently with google suite products. I enrolled in his other courses and they are all wonderful.