HOT
blank

Dynamic Quiz App using Google Sheets as source Google Script

Development

Rating4.1
Enroll Now

Dynamic Quiz App using Google Sheets as source Google Script, available at $44.99, has an average rating of 4.05, with 49 lectures, based on 23 reviews, and has 2042 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to practice Google Apps Script or Anyone who wants to practice using Google Script to build a fun interactive application or Anyone who wants to be able to explore the power of what can be done with Google Script or Anyone who wants to learn more about what Google Script can do or Update and use Spreadsheet data within your website or Anyone who wants to learn about Google Apps Script or JavaScript developers who want to extend their knowledge or Application developers It is particularly useful for Anyone who wants to practice Google Apps Script or Anyone who wants to practice using Google Script to build a fun interactive application or Anyone who wants to be able to explore the power of what can be done with Google Script or Anyone who wants to learn more about what Google Script can do or Update and use Spreadsheet data within your website or Anyone who wants to learn about Google Apps Script or JavaScript developers who want to extend their knowledge or Application developers.

Enroll now: Dynamic Quiz App using Google Sheets as source Google Script

Summary

Title: Dynamic Quiz App using Google Sheets as source Google Script

Price: $44.99

Average Rating: 4.05

Number of Lectures: 49

Number of Published Lectures: 49

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

  • 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

Target Audiences

  • 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

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 AWAYat 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 learnand 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.

Course Curriculum

Chapter 1: Introduction to creating web apps with JavaScript and Google Script

Lecture 1: Dynamic Quiz App Introduction

Lecture 2: Development Setup

Lecture 3: Resources

Chapter 2: Get Spreadsheet data as JavaScript object

Lecture 1: Spreadsheet Data as JSON.

Lecture 2: Google Sheets JSON data updated Version

Lecture 3: Source Code to output Google Sheets data as JSON for webpages API

Lecture 4: JavaScript Fetch Data

Lecture 5: Source Code Fetch

Lecture 6: Get Sheet Data as Object

Lecture 7: Get Sheet Data as Object 2

Lecture 8: Get Sheet Data as Object 3

Lecture 9: Source Code get sheet object

Lecture 10: Multiple Sheets Promise All

Lecture 11: Build your sheet data object

Lecture 12: Source Code Get Sheet Data

Chapter 3: Build your web application generate elements

Lecture 1: Client Side Create HTML from Data

Lecture 2: Source Code Client Side Create HTML from Data

Lecture 3: Create Quiz Questions

Lecture 4: Source Code Quiz Question loading

Lecture 5: Create Questions JavaScript

Lecture 6: Output Answers to Questions

Lecture 7: Source Code output build elements

Lecture 8: Add styling to output

Lecture 9: Source Code index html with style

Lecture 10: First Run Output Builder

Lecture 11: Check Answer Scoring

Lecture 12: Source Code with scoring

Lecture 13: Game Over handling

Lecture 14: Source Code with game over

Lecture 15: Quiz Gameplay review

Lecture 16: Source Code section final code

Chapter 4: JavaScript Create a Quiz Application

Lecture 1: Create Your Quiz

Lecture 2: Apps Script Setup – Use this

Lecture 3: Apps Script add to Sheet

Lecture 4: Source Code update sheet

Lecture 5: Connect to WebApp AJAX

Lecture 6: Source Code create html

Lecture 7: JavaScript Form Builder

Lecture 8: Source Code with builder create html

Lecture 9: Form Data Post

Lecture 10: Source Code with post method

Lecture 11: WebApp Post Formdata

Lecture 12: Quiz Creator Review and Tweaks

Lecture 13: Source Code Google Script and create file

Chapter 5: Conclusion Extras

Lecture 1: CORS error Debug.

Lecture 2: doGet Method

Lecture 3: Google Sheet new Connection URL and Source Code Example

Lecture 4: Source Code Google Sheets as Data Endpoint

Lecture 5: Bonus Lecture

Instructors

Rating Distribution

  • 1 stars: 3 votes
  • 2 stars: 0 votes
  • 3 stars: 1 votes
  • 4 stars: 6 votes
  • 5 stars: 13 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024