Description

Type

Course
Methodology

Online

Start date

Different dates available

Explore how you can use Google Sheets to store data submitted directly from your own website using an HTML form.Google apps script has so many possibilities to really power up your web pages. Please note this course requires fundamental JavaScript knowledge and is designed to cover building a project that allows web users to submit a form, using AJAX send the data to a Google Script Web app and using Google Script to deposit the submission data into a Google Spreadsheet.Learn the basics of writing Google ScriptExplore how to add content and append content to spreadsheetsSee how you can create web apps with web URLsSubmit data to your web app using AJAX - we use jQuery in the course using GetRetrieve parameters in the request using Google Script and create an array to submit and add content to your spreadsheetReturn a callback response in JSON format back to your web pageAll the source code is included to get you started quickly. 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 a 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

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Course objectives

Connect website input form to Google Spreadsheet
Add data from an input form to Google Spreadsheet

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

I agree to the Privacy Policy and the Conditions.

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

Javascript training
HTML
Javascript
Ajax
Web
Project
Programming
Programme Planning
Programming Application
IT

Course programme

Introduction to Google Apps Script Project 4 lectures 24:35 Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Introduction to Google Apps Script Project 4 lectures 24:35 Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Introduction to Google Apps Script Project: Introduction to Google Apps Script Project Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Introduction to Google Apps Script Project: Getting started Quick Intro to Google Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Introduction to Google Apps Script Project: Write Code with Apps Script Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Introduction to Google Apps Script Project: Debugging and more Google Script Logger Log Build a web app to send data into your Google Sheet 7 lectures 33:39 How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script JSON response data Build a web app to send data into your Google Sheet: JSON response data Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Build a web app to send data into your Google Sheet 7 lectures 33:39 How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script JSON response data Build a web app to send data into your Google Sheet: JSON response data Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App Build a web app to send data into your Google Sheet: How to Setup Web App HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form Build a web app to send data into your Google Sheet: HTML submission form Setup Client Form AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App Build a web app to send data into your Google Sheet: AJAX request to Web App Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Build a web app to send data into your Google Sheet: Web App Get Request Data Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script Build a web app to send data into your Google Sheet: Code Fixes Google Script JSON response data Build a web app to send data into your Google Sheet: JSON response data JSON response data Build a web app to send data into your Google Sheet: JSON response data JSON response data Build a web app to send data into your Google Sheet: JSON response data JSON response data Build a web app to send data into your Google Sheet: JSON response data Build a web app to send data into your Google Sheet: JSON response data Build a web app to send data into your Google Sheet: JSON response data Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview Build a web app to send data into your Google Sheet: Project review coding overview

Additional information

JavaScript developers and Application developers who want to extend their knowledge

See related categories

A Google Script Project Using Website Spreadsheets and Data Storage

Questions & Answers

Reviews

This centre's achievements

Subjects

Course programme

Add similar courses
and compare them to help you choose.

A Google Script Project Using Website Spreadsheets and Data Storage

Questions & Answers

Reviews

This centre's achievements

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.