Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 425 MB
Genre: eLearning Video | Duration: 27 lectures (1 hours, 15 mins) | Language: English
Output Spreadsheet data as a web app URL with JSON feed of contents of the Spreadsheet. Run code and customize endpoint.
What you'll learn
How to use Google Script to create WebApps
How to select content from Spreadsheets
How to output API JSON endpoint
Requirements
javascript and HTML
Internet Access
Programming experience
Description
Bonus free PDF guide packed full of resources and code snippets to help you learn - follow the lessons using the guide! Learning made easy :)
One of the most common questions I get is how to use Spreadsheet data in a web application. This course will cover how to setup a web app and output sheet data as JSON to a web URL endpoint. Which can then be used to display and use the data within any web application or web site.
Please note that the scope of this course is creating a WEB APP with Google Apps Script code, javascript and previous programming knowledge is an essential prerequisite to this course.
YOU MUST HAVE javascript KNOWLEDGE TO TAKE THIS COURSE
Course covers
Use of HtmlService to output HTML page contents
Setup of web app for web URL Create a WebApp
WebApp Client side - Server Side Code
Client side Google Script option
Output from a file
Getting Spreadsheet Data
Data as JSON Output
SheetData as JSON Output
WebPage Connection Fetch
E Parameters in request URI
Conditions with parameters
Taught by an instructor with over 20 years of Web Development experience.
If you've been looking to get started with Google Web Apps - THIS COURSE IS FOR YOU!!!!
Nothing to lose - Fast friendly support is always available to help if you need it.
Please note that the SCOPE OF THIS COURSE IS Creating a simple endpoint of JSON data and will not cover complex commands and everything about javascript, JSON its a simple HOW TO GET STARTED COURSE - if you are looking at more detailed Google Script content this is not for you.
Who this course is for:
Web developers
Web designers
Web application developers
WebMasters
Anyone who wants to learn more about Google Apps Script
Anyone who wants to use Spreadsheet data in an application
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.