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,440 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
English [Auto],

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 a bound Google Apps Script project in a new Google Sheets spreadsheet, set an on open trigger with a popup UI, and prepare coding in the script editor.

  • Create PopUp HTML.4:36

    Create a pop-up in Google Sheets via an onOpen trigger using HtmlService to build index.html and showModalDialog in the spreadsheet UI, with a configurable width and height.

  • Source Code0:02
  • Spreadsheet App UI button2:44

    Add a testable UI button to the spreadsheet app, linking a menu item to run a function and open a popup window, with a trigger on open setup.

  • Source Code0:05
  • HTML and JavaScript in client Side2:59

    Explore embedding client-side JavaScript in an Apps Script project, calling a server-side function to return a web URL, and handling the response with a success callback.

  • Source Code0:05
  • On Failure to Run Callback.2:27

    Add a failure callback to the onopen trigger, log errors, and dynamically display results in a created div on the page; verify client-side outputs in a popup and prepare redirection.

  • Source Code0:15
  • Open Page with JavaScript1:43

    Create an anchor tag with document.createElement, use a server-returned web URL to open in a new window, test the click flow, and plan to auto trigger on page open.

  • Source Code0:09
  • Setup Project Trigger.4:04

    learn how to set up onOpen triggers in Apps Script, either manually via edit current project triggers or with script to run a selected function when a spreadsheet opens.

  • 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