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 Project Sheet UI custom Functions
Highest Rated
Rating: 4.7 out of 5(19 ratings)
2,213 students

Google Apps Script Project Sheet UI custom Functions

Search Sheet data and select Sheet cells create custom Google Apps Script code to run within your Google Sheets G Suite
Highest Rated
Created byLaurence Svekis
Last updated 11/2024
English
English [Auto],

What you'll learn

  • Perfect for anyone who wants to learn more about Google Apps Script
  • Anyone who wants to learn how to select content from Sheets and add to HTML table
  • Anyone who wants to search sheets and highlight the found content in cells

Course content

2 sections • 21 lectures • 52m total length

  • Spreadsheet More Functions with Script Introduction2:45

    Explore advanced Google Sheets functions with Apps Script. Add UI menu options to search across all sheets, copy content to a new spreadsheet, and email data as a table.

  • How to setup Bound Script to Spreadsheet Setup Sheet2:19

    Log into your Google account, create a spreadsheet named bound tester, bind a script to it, populate test data, and open script editor to name the project bound test one.

  • How to Add UI menu Items to spreadsheet GSuite Sheet3:14

    Create a custom UI menu in Google Sheets by using onOpen, getActiveSpreadsheet, and addMenu to add a search item linked to onSearch.

  • Add UI menu Item Button0:02
  • How to Apps Script Search Function Create sheet functions4:23

    Learn how to create a dynamic search in google apps script by using the ui prompt, handling yes no cancel buttons, and returning the search term to drive sheet functions.

  • UI prompt and alert source code snippet example0:09
  • How to create a Search Spreadsheet Function4:44

    Create a Google Apps Script search function that scans the active spreadsheet for a value, finds all matches with a text finder, highlights them in red, and clears formatting afterward.

  • Source Code0:12
  • Project Review Google Apps Script GSuite Sheets Sheet Selector Search Review.4:04

    Explore how to use a bound Google Apps Script to add UI menus and prompts, search across one or more sheets, and highlight matches with background color updates.

  • Search All Sheets update cell background Code Example0:12
  • How to Sheet Data Copy to new Sheet.2:37

    Learn to copy active content from a selected range, create a new sheet, and paste the values, while adding a copy option to the UI menu and testing the flow.

  • How to Create New Sheet Add Copy of Content4:39

    Create a brand-new sheet, copy content into it, and manage existing sheets by deleting and recreating as needed; loop through data to populate rows and enable cross-sheet search.

  • Source Code0:19
  • How to setup Gmail Content as HTML Table3:16

    Add a Gmail email option in Google Apps Script to send the selected content as an HTML table to the active user's email, building a data object and HTML table.

  • How to Create Content as HTML Table Part 2 Google Sheets5:31

    Learn to build an html table from a data object in google apps script, looping rows and columns and sending the formatted table via email.

  • Source Code0:39
  • Google Spreadsheet Options Review1:45

    Bound scripts add custom functions to Google Sheets, enabling an advanced search that highlights matches in red, a copy option to create a spreadsheet, and an email option for contents.

Requirements

  • Prior Coding Experience
  • JavaScript Coding understanding
  • Google Account

Description

Explore how you can create a custom Google Sheet option within your Google Sheets UI menu.

PopUp alert connects to Google Apps Script to run custom spreadsheet code o find and select cells that match the value.

Explore Google Apps Script and how it can be used to run code using data from your Spreadsheet

Discover the amazing things you can do with Google Apps Script

Course covers some of the commonly asked for functionality using Google Apps Script and Google Spreadsheets

Do more with your Spreadsheets adding a custom UI menu with advanced options

  • Search - uses UI prompt to ask the user for a search term, searches all the sheets within the spreadsheet and highlights the cells with matching content.

  • Email - Lets the user email themselves the selected content from the spreadsheet, construct an html table some selected active spreadsheet data.  Send the email.

  • Copy -Copy selected content to a new sheet, takes the selected data create a new sheet and builds the content from the selection.

JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript Experience

Source code is included - Best way to learn is to try the code and create your own version of this project

Taught by an instructor with over 20 years of web development experience ready to help you learn

Google Developer Expert - Laurence Svekis walks you through how to do some amazing functionality to save time and get the most out of Google Apps Script G Suite content

Fast friendly support is always available in the Q&A section

What are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets

Who this course is for:

  • Google Apps Script Coders
  • Anyone who wants to do more with Google Apps Script and G Suite Apps
  • JavaScript Developers - Applications developers and web coders
  • Anyone who wants to power up web applications with the power of Google G Suite Apps using CODE

Report abuse