Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Apps Script Consent Form Exercise - JavaScript Cloud
Rating: 4.5 out of 5(87 ratings)
5,803 students

Google Apps Script Consent Form Exercise - JavaScript Cloud

Practice Exercise for Learning how to use Google Apps Scripts - Track within a Spreadsheet, send email, convert to PDF
Created byLaurence Svekis
Last updated 11/2024
English
English [Auto],

What you'll learn

  • Create Google Script to power Google Apps
  • Create apps with Google Script
  • Build a form that submits data to a spreadsheet and sends email

Course content

2 sections • 14 lectures • 1h 15m total length

  • Google Script App Introduction2:50

    Explore building a web interface with Google Apps Script to collect user data and emails, submit to a spreadsheet, and send a PDF generated from a Google Doc.

  • Setup Google Script4:23

    Master Google Apps Script, a JavaScript cloud-based language, to automate spreadsheets and emails with HTML service and build a consent form web app that saves responses to a spreadsheet.

  • Setup Developer Environment11:44

    Open the Google developer environment, create your first standalone script, and learn to use the script editor, logger, and run and debug functions to build and test consent form automation.

  • HtmlService Output HTML6:15

    Output html content using the HTML service in Google Apps Script. Render templates from files like index.html, and configure iframe sandbox mode to display styled, client-side JavaScript.

  • HtmlService Try and Catch2:34

    Master error handling with try-catch in HtmlService, output JSON via content service, and format errors as JSON; then build the consent form page and wire submissions to the Google script.

  • HTML form submission to GS9:16

    Build a client-side html form with name, email, and terms checkbox, prevent default submission, assemble a data object, and submit via ajax to a Google Apps Script backend.

  • Google Script RUN5:19

    Use the Google script run service in HTML pages to send form data to a Google script, handle success and failure callbacks, and return data.

  • SpreadSheet App add data10:06

    Create and connect a Google spreadsheet with a script, then append rows for name, email, due date, and optional id or send email flag, opening by id.

  • Send and Email with PDF of Doc10:28

    Learn to create a document, convert it to PDF, and send it via email using Google Apps Script, with DriveApp and MailApp services, including attachments and HTML email options.

  • Add to Google Sites Embed Web app URL4:59

    Embed a Google Apps Script web app into Google Sites by publishing versions, embedding the URL, and collecting form submissions that populate a spreadsheet with configurable permissions.

  • Source Code Overview6:18

    Explore how Google Apps Script powers a web app form, captures submissions, stores them in a spreadsheet, and emails a PDF attachment using doGet, HTML output, and JSON handling.

  • Source Code0:57

Requirements

  • Google account
  • JavaScript and basic HTML and CSS knowledge
  • Basic Web development understanding

Description

Learn more about what Google Script can do and how to create time saving amazing applications.  

Apps Script is a scripting language for light-weight application development in the G Suite platform.  Google Apps Script is a scripting language based on JavaScript that lets you do new and cool things with G Suite products like Docs, Sheets, Gmail and others. There's nothing to install — we give you a code editor right in your browser, and your scripts run on Google's servers.

Within the lessons of the course we show you how to build a fully functional mini application that can accept user data within a form, submit that content to a spreadsheet, email out a response, take a document and convert it to a pdf.  All this an a whole lot more, source code is included.

Source code included, learn how to use Google Script to extend what your Google Docs can do.  Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.  

Taught by a knowledge instructor with many years of web development experience, ready to help you learn.

Join now and create your own Google Scripts Apps see what is possible.

Who this course is for:

  • Anyone who wants learn more about Google Scripts
  • Anyone who wants to explore how to use Web App within Google Script
  • Web developers who want to incorporate Google Script functionality
  • Practice and apply Google Suite of Products

Report abuse