Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Apps Script OnOpen Trigger new Web URL Project G Suite
Rating: 4.4 out of 5(13 ratings)
3,435 students

Apps Script OnOpen Trigger new Web URL Project G Suite

Explore Google Apps Script G Suite integration with Sheets, setup of Triggers and creating client side JavaScript
Created byLaurence Svekis
Last updated 11/2024
English

What you'll learn

  • How to apply Google Apps Script
  • How to connect Google Apps Script with Sheets
  • On Open function and triggers

Course content

2 sections • 18 lectures • 38m total length

  • Project Introduction Apps Script UI4:28

    Learn to implement onOpen triggers in Google Apps Script to open a second spreadsheet, display a client-side pop-up UI, and redirect to a web URL from a bound script.

  • Setup Google Apps Script Project.2:01
  • Create PopUp HTML.4:36
  • Source Code0:02
  • Spreadsheet App UI button2:44
  • Source Code0:05
  • HTML and JavaScript in client Side2:59
  • Source Code0:05
  • On Failure to Run Callback.2:27
  • Source Code0:15
  • Open Page with JavaScript1:43
  • Source Code0:09
  • Setup Project Trigger.4:04
  • Source Code0:08
  • Project Code Review and Conclusion11:27

    Bind Google Apps Script to a spreadsheet, create a custom UI menu and modal dialog, and use google script run to connect client-side with server-side functions.

  • Source code and Resources0:49

Requirements

  • JavaScript
  • Prior Coding Experience

Description

Explore using Google Apps Script to connect to onOpen script functions, setup UI modal, add UI menu buttons and create Client side JavaScript.  Apps Script OnOpen Trigger new Web URL Project G Suite

This course idea was a result of several students requests on this topic, I enjoy Google apps script and always happy to provide interesting solutions to coding challenges. 

JavaScript and Google Apps Script are prerequisites to this course - DO NOT TAKE this course without prior coding experience.

  • Setup a UI modal

  • Setup Triggers to run functions on Open of Sheets

  • Bound script to sheets

  • Client Side HTML handling and request of value from Google Script

  • Run JavaScript code on sheet open

  • Setup of triggers.

Source Code is included.

Taught by an instructor with many years of web development experience.  Google Developer Expert for G Suite. Ready to help you learn more about Google Apps Script.  With fast and friendly support within the Q&A section.

Are you ready to build you own version of the app, make it even better, do more....   What are you waiting for see what you can do with Google Apps Script! Join NOW.

Who this course is for:

  • Application developers
  • JavaScript Coders
  • Anyone who codes Google Apps Script
  • Anyone with a G Suite account

Report abuse