- Видео 224
- Просмотров 1 102 072
Yagisanatode -Scott-
Австралия
Добавлен 19 май 2019
Welcome to my RUclips channel! I'm a Google Workspace Developer and Educator, and I help people automate and extend their Google Workspace environment. I offer a variety of services, including consulting, training, and development. I also have a number of courses and apps available for purchase.
If you're looking for help with Google Workspace, then my channel is for you! I post new videos every week, so be sure to subscribe and hit the notification bell so you don't miss a thing!
Here are some links to my services, courses, and apps:
💻 My Services: yagisanatode.com/google-workspace-developer/
🎓 My Courses: yagisanatode.com/products-category/courses/
🚀 My Add-ons: yagisanatode.com/products-category/gwao/
🛠 My Tools and Apps: yagisanatode.com/products-category/google-workspace-tool/
Thanks for watching!
If you're looking for help with Google Workspace, then my channel is for you! I post new videos every week, so be sure to subscribe and hit the notification bell so you don't miss a thing!
Here are some links to my services, courses, and apps:
💻 My Services: yagisanatode.com/google-workspace-developer/
🎓 My Courses: yagisanatode.com/products-category/courses/
🚀 My Add-ons: yagisanatode.com/products-category/gwao/
🛠 My Tools and Apps: yagisanatode.com/products-category/google-workspace-tool/
Thanks for watching!
Workspace After Dark 22-01-2025: Gemini in Google Workspace, Grade All Classroom, getSheetById()
I'm trying out Twitch and live streaming for a weekly update on what's going on in the world of Google Workspace and Apps Script. Let me know what you think.
Providing some live walkthroughs of new features, discussions on new changes and honest opinions about recent updates.
Covering the Latest Google Workspace and Apps Script updates for the 16th to the 22nd of January 2025.
-- Google Workspace --
🐐 Gemini for Google Workspace - play around
🐐 Introducing the ability to ‘grade all’ in Google Classroom
-- Apps Script --
🐐 getSheetById() - SpreadsheetApp
-- Links --
workspaceupdates.googleblog.com/
developers.google.com/apps-script/docs/release-notes
=== Twitch ===🐐
Every Wednesday
www.twitch.tv/...
Providing some live walkthroughs of new features, discussions on new changes and honest opinions about recent updates.
Covering the Latest Google Workspace and Apps Script updates for the 16th to the 22nd of January 2025.
-- Google Workspace --
🐐 Gemini for Google Workspace - play around
🐐 Introducing the ability to ‘grade all’ in Google Classroom
-- Apps Script --
🐐 getSheetById() - SpreadsheetApp
-- Links --
workspaceupdates.googleblog.com/
developers.google.com/apps-script/docs/release-notes
=== Twitch ===🐐
Every Wednesday
www.twitch.tv/...
Просмотров: 38
Видео
Get Google Docs Body Text, Links & Smart Chips with Docs API Advance Service - Apps Script
Просмотров 422 часа назад
Extract Google Docs body text, links, People and Rich Link Smart Chips and Code Snippets with Docs API Advanced Service with Google Apps Script. This tutorial is 3 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. The Docs API is a platform-agnostic REST API that you can call f...
Get Google Docs Body Text with OCR Drive API Advanced Service - Apps Script
Просмотров 10916 часов назад
Extract Google Docs body text with Drive API Advanced Service OCR (Optical Character Recognition) hack with Google Apps Script. This tutorial is 3 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. Check out the written tutorial for more details The Written Tutorial 🐐 yagisanato...
Get Google Doc Body Text, Links& Smart Chips with Apps Script DocumentApp
Просмотров 158День назад
Extract Google Docs body text, links and Chips (Person, Date, Rich Links) with Google Apps Script and the DocumentApp Service. This tutorial is 1 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. Check out the written tutorial for more details The Written Tutorial 🐐 yagisanatod...
Offset Gradient Conditional Formatting in Google Sheets with Apps Script
Просмотров 183Месяц назад
Learn how to apply Offset Gradient Conditional Formatting in Google Sheets with Google Apps Script. Have you ever wanted to apply a gradient to a column or columns based on a set of column values in another range in Google Sheets? Well in this tutorial we will go through three examples that will cover: 1. Generating Conditional Formatting rules based on an ordered list of sample numbers (or cha...
A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets
Просмотров 190Месяц назад
An easy to use pseudo-class to quickly set and clear conditional formatting rules in a Google Sheet tab with Apps Script. The key methods: - clearRule - You can clear a range of rules by: 1. And exact range match. 2. Any rule within a target range. 3. Any rule overlapping a target range. - setRule - Set conditional formatting rules and position them in your desired order. To the documentation! ...
Add Conditional Formatting Rules to a Google Sheet Tab with Apps Script
Просмотров 3022 месяца назад
Adding new conditional formatting rules to a Google Sheet tab with Apps Script can be tricky. This tutorial covers how to do this without deleting the existing conditional formatting in the sheet tab. To the Starter Sheet!: docs.google.com/spreadsheets/d/1LdDeet5pBYS5c3dbUJGv9yR0_B7m8rzxTd4FcFYttuA/copy The Conditional Formatting with Apps Script Playlist: ruclips.net/p/PLSDEbLgMgqvqETwEGcHZQfM...
Clear Conditional Formatting Rules that Overlap a Target Range in Google Sheets with Apps Script
Просмотров 1332 месяца назад
Clear conditional formatting rules that Overlap a target Range in Google Sheets with Google Apps Script. To the Starter Sheet!: docs.google.com/spreadsheets/d/1snkQPSNCZvVhRSmhQMiUeB3Hh6q8SDZcaD8JxqOxk1M/copy The Conditional Formatting with Apps Script Playlist: ruclips.net/p/PLSDEbLgMgqvqETwEGcHZQfMZJVP-Fh7K- 00:00 Previous tutorial recap 00:36 What we're building 01:48 The starter script and ...
Clear Conditional Formatting Rules Within a Range in Google Sheets with Apps Script
Просмотров 1412 месяца назад
Remove a conditional formatting rule within a range in Google Sheets with Google Apps Script. To the Starter Sheet!: docs.google.com/spreadsheets/d/1snkQPSNCZvVhRSmhQMiUeB3Hh6q8SDZcaD8JxqOxk1M/copy The Conditional Formatting with Apps Script Playlist: ruclips.net/p/PLSDEbLgMgqvqETwEGcHZQfMZJVP-Fh7K- 00:00 Previous tutorial recap 00:27 What we're building 01:48 The starter script and Test functi...
Clear Conditional Formatting Rules by Exact Match in Google Sheets with Apps Script
Просмотров 1152 месяца назад
Remove a conditional formatting rule by the exact range in Google Sheets with Google Apps Script. To the Starter Sheet!: docs.google.com/spreadsheets/d/1snkQPSNCZvVhRSmhQMiUeB3Hh6q8SDZcaD8JxqOxk1M/copy The Conditional Formatting with Apps Script Playlist: ruclips.net/p/PLSDEbLgMgqvqETwEGcHZQfMZJVP-Fh7K- 00:00 Intro 00:51 What we're building 01:23 The starter script and Test function 02:48 Check...
CLASPALL Update Multiple Google Apps Script projects with one CLI command
Просмотров 1853 месяца назад
CLASPALL is a Command Line App that runs with Google's CLASP, allowing you to update multiple Google Apps Script Projects from a single core project locally. To the Written Tutorial: yagisanatode.com/claspall-update-multiple-apps-script-projects-from-a-single-source/ 00:00 Intro 00:51 What is CLASPALL? 01:25 Use CLASP to create or clone locally 02:23 Check version claspall -v -version 02:44 Get...
Extract the Workdays Between Two Dates In JavaScript
Просмотров 733 месяца назад
Given a start date, end date, weekends and holidays, extract the valid workdays between two dates in JavaScript To the written tutorial: yagisanatode.com/extracting-the-valid-workdays-between-two-dates-in-javascript/ Chapters: 00:00 What we're building 01:07 Sample Data runsies() 02:56 getWorkdays() function 04:30 function head variables 06:36 record workday periods 13:25 test the code More on ...
Calculating the Workday End Date in JavaScript
Просмотров 893 месяца назад
Given a start date, number of days and holidays, calculate the end date of a workday period. To the written tutorial: yagisanatode.com/calculate-the-workday-end-date-in-javascript/ 00:00 What we're building 00:25 runsies() sample test function 07:06 getWordayEndDate() function More on advanced dates in JavaScript ruclips.net/p/PLSDEbLgMgqvour_OTZ1sgBOxcm5gxeJ57 My Site yagisanatode.com/ More on...
Extracting Overlapping Date Ranges in JavaScript
Просмотров 1423 месяца назад
Given a target date range and an array of date ranges to check, return the ranges of the checked dates where they overlap the target range otherwise return null using JavaScript. To the written tutorial: yagisanatode.com/extracting-overlapping-date-ranges-between-2-date-ranges-with-javascript/ More on advanced dates in JavaScript ruclips.net/p/PLSDEbLgMgqvour_OTZ1sgBOxcm5gxeJ57 My Site yagisana...
Is a Year a Leap Year? Gregorian Calendar & JavaScript
Просмотров 684 месяца назад
Is a Year a Leap Year? Gregorian Calendar & JavaScript
Create a Year Day prototype for Date in JavaScript
Просмотров 514 месяца назад
Create a Year Day prototype for Date in JavaScript
Get the Day of the Year of a Date in JavaScript
Просмотров 1894 месяца назад
Get the Day of the Year of a Date in JavaScript
Append Range Values to Messy Ranges with Gaps in Google Sheets - Apps Script
Просмотров 2424 месяца назад
Append Range Values to Messy Ranges with Gaps in Google Sheets - Apps Script
Append range values in Google Sheets with Extra Column Data - Apps Script
Просмотров 4284 месяца назад
Append range values in Google Sheets with Extra Column Data - Apps Script
Append a Range of Cell Values to a new Google Sheet Tab with Apps Script
Просмотров 6695 месяцев назад
Append a Range of Cell Values to a new Google Sheet Tab with Apps Script
Handling Dialog and Sidebar Access Issues in Google Workspace Apps
Просмотров 1985 месяцев назад
Handling Dialog and Sidebar Access Issues in Google Workspace Apps
Access Issues with Dialogue and Sidebars in Google Workspace Apps
Просмотров 1765 месяцев назад
Access Issues with Dialogue and Sidebars in Google Workspace Apps
GWAOw! 6 - Sign PDF with Jotform Sign
Просмотров 965 месяцев назад
GWAOw! 6 - Sign PDF with Jotform Sign
Add an Empty Space Option to a Dropdown Menu in Google Sheets
Просмотров 1,6 тыс.6 месяцев назад
Add an Empty Space Option to a Dropdown Menu in Google Sheets
A Better Approach to Financial Year Formulas in Google Sheets
Просмотров 4346 месяцев назад
A Better Approach to Financial Year Formulas in Google Sheets
Get the last value in a range in Google Sheets
Просмотров 2,7 тыс.6 месяцев назад
Get the last value in a range in Google Sheets
Prevent consecutive clicks of a Google Sheet Image Button with Lock Service
Просмотров 4347 месяцев назад
Prevent consecutive clicks of a Google Sheet Image Button with Lock Service
Generate UUIDs in Google Sheets with Apps Script (Unique IDs)
Просмотров 1,1 тыс.8 месяцев назад
Generate UUIDs in Google Sheets with Apps Script (Unique IDs)
Sort Sheet Tabs by Date in Google Sheets with Apps Script
Просмотров 3558 месяцев назад
Sort Sheet Tabs by Date in Google Sheets with Apps Script
Remove Empty Cells from Google Sheets QUERY
Просмотров 1,1 тыс.8 месяцев назад
Remove Empty Cells from Google Sheets QUERY