by Laurence Svekis | Publisher: Packt Publishing | Release Date: April 2019 | ISBN: 9781838552121

Create your own web applications that uses Google Spreadsheet data to build quizzes and JavaScript to build the websiteAbout This VideoAll you need to know is fundamental JavaScript knowledgeTaught by an instructor with over 20 years of web development experienceIn DetailYou 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." 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.All the code and supporting files for this course are available at: https://github.com/PacktPublishing/A-Dynamic-Quiz-App-using-Google-Apps-Script-with-Google-Sheets-as-the-Data-SourceDownloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

1. Chapter 1 : Introduction to creating web apps with JavaScript and Google Script
   • Dynamic Quiz App Introduction 00:02:16
   • Development Setup 00:06:05
2. Chapter 2 : Get Spreadsheet data as JavaScript object
   • Spreadsheet Data as JSON 00:05:21
   • JavaScript Fetch Data 00:05:16
   • Get Sheet Data as Object 00:06:00
   • Get Sheet Data as Object 2 00:05:49
   • Get Sheet Data as Object 3 00:03:14
   • Multiple Sheets Promise All 00:05:48
   • Build your sheet data object 00:06:53
3. Chapter 3 : Build your web application generate elements
   • Client Side Create HTML from Data 00:06:13
   • Create Quiz Questions 00:03:23
   • Create Questions JavaScript 00:07:22
   • Output Answers to Questions 00:05:50
   • Add styling to output 00:02:40
   • First Run Output Builder 00:01:43
   • Check Answer Scoring 00:05:20
   • Game Over handling 00:05:33
   • Quiz Gameplay review 00:08:07
4. Chapter 4 : JavaScript Create a Quiz Application
   • Create Your Quiz 00:04:10
   • Apps Script Setup – Use this 00:05:56
   • Apps Script add to Sheet 00:09:05
   • Connect to WebApp AJAX 00:05:05
   • JavaScript Form Builder 00:07:34
   • Form Data Post 00:08:49
   • WebApp Post Formdata 00:04:27
   • Quiz Creator Review and Tweaks 00:07:09
5. Chapter 5 : Conclusion Extras
   • CORS error Debug 00:06:08
   • doGet Method 00:03:44