GAPPS-H

New Apps Script - Advanced

Form of participation
Form of training
Length of training
  • 2 day (2×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

Google Apps Srcript is an excellent JavaScript-based programming tool for people who want to use Google Apps in their work. I recommend this training to all those who want to create useful applications with Google Apps Script, and support various Google applications with other functions and menu items.

Outline

UI

  • Access Ui
  • Communication via Ui
  • Request a response with a prompt
  • Session, or I'll tell you who you are
  • Session, I also know where you are

HTML Service

  • Let's create a search and replace function
  • Edit document

SpreadsheetApp

  • Display HTML
  • Using JavaScript in HTML
  • Show Selected
  • Copy from
  • Copy a range to the same range in another worksheet
  • Data retrieval
  • Event management
  • Write random values to a range
  • Paste column or row to a given location
  • Using formulas
  • Using functions
  • Displaying data in an HTML file using JavaScript

DriveApp

  • Folder search
  • File Finder
  • Show properties
  • Add (and remove) editors to a file
  • Create WebApp

GmailApp

  • Access emails
  • Send email with image

CalendarApp

  • Access Calendar
  • Access event
  • Create an event

Outline (PDF)

Prerequisites

To successfully complete the course, you need to be familiar with the Google App Script Basic course.