Google Apps Script Project Sheet UI custom Functions

Focused View

Laurence Svekis

50:14

69 View

1. Introduction to Google Sheets functions with Apps Script

1. Spreadsheet More Functions with Script Introduction.mp4

02:45

2. How to setup Bound Script to Spreadsheet Setup Sheet.mp4

02:19

3. How to Add UI menu Items to spreadsheet GSuite Sheet.mp4

03:14

4. Add UI menu Item Button.html

5. How to Apps Script Search Function Create sheet functions.mp4

04:23

6. UI prompt and alert source code snippet example.html

7. How to create a Search Spreadsheet Function.mp4

04:44

8. Source Code.html

9. Project Review Google Apps Script GSuite Sheets Sheet Selector Search Review..mp4

04:04

10. Search All Sheets update cell background Code Example.html

11. How to Sheet Data Copy to new Sheet..mp4

02:37

12. How to Create New Sheet Add Copy of Content.mp4

04:39

13. Source Code.html

14. How to setup Gmail Content as HTML Table.mp4

03:16

15. How to Create Content as HTML Table Part 2 Google Sheets.mp4

05:31

16. Source Code.html

17. Google Spreadsheet Options Review.mp4

01:45

2. Google Apps Script Common Questions and Answers with Source Code examples

1. how to create a prototype to add to array with Search of array contents.mp4

10:57

2. Array Search Prototype coding example Google Apps Script.html

3.1 Google AppsScript Code Examples.pdf

3. Apps Script Coding Examples.html

Description

Search Sheet data and select Sheet cells create custom Google Apps Script code to run within your Google Sheets G Suite

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

Who is this 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

What You Need to Know?

Prior Coding Experience

JavaScript Coding understanding

Google Account

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

I'm here to help you learn, achieve your dreams, come join me on this amazing adventure todayGoogle Developers Expert - GSuite Providing Web development courses and digital marketing strategy courses since 2002.Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses."I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides.""Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge."Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real."My courses are designed to help you achieve your goals, learn and update skills"Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO. "Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.