Yagisanatode @yagisanatode@qoto.org

Reconsider Smart Chips when using Apps Script in Google Sheets. @GoogleWorspaceDev Google Developer Experts #GoogleAppsScript #GoogleSheets #GoogleWorkspace https://youtu.be/YQ5SFNXeULE

New Google Chat Quick Commands an alternative to Slash Commands. I give them a spin in Google Apps Script @WorkspaceDevs #GoogleAppsScript #GoogleChat Google Developer Experts

https://youtu.be/AvAYawLx5SU

We can also use the Google Docs API Advanced Service to retrieve text data from a Google Doc with Apps Script or indeed, with any other programming language. This returns a JSON Object for the current doc.

This tutorial is 4 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 @WorkspaceDevs
https://youtu.be/BEtj42ufWhU

Sometimes, you need to focus on extracting the text of a Google Doc, including what is displayed on the 'Smart Chips'. In this tutorial, we use the Google Drive API OCR (Optical Character Recognition) to extract text from our Google Docs.

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 @WorkspaceDevs
https://youtu.be/7nTVFmfcNaI

Extract Google Docs body text, links and Chips (Person, Date, Rich Links) with Google Apps Script and the DocumentApp Service.

This tutorial is 2 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 @WorkspaceDevs
https://youtu.be/ElwWk5oD4eM

Get a Google Docs Body Text with Apps Script (4 approaches)
https://yagisanatode.com/get-a-google-docs-body-text-with-apps-script/

Retrieve the body text of a Google Doc with Google Apps Script DocumentApp service

Offset Gradient Conditional Formatting in Google Sheets with Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace #GoogleSheets @WorkspaceDevs
https://youtu.be/4koWQysEJC8

+1 (or even comment) on this Apps Script API bug:
DocumentApp Text class setAttributes() displays unreliable results.

https://issuetracker.google.com/issues/383380992

A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/coko7zUXsHk

+1 this Bug - Google Workspace Add-on Card Service does not maintain your primary and secondary colour preferences for a number of widgets like footer buttons, checkboxes, radio buttons, toggle buttons, text input borders and legends. https://issuetracker.google.com/issues/380912402 #googleAppsScript

Part 4: Add Conditional Formatting Rules to a Google Sheet Tab with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/efKql-S5fXE

Part 2: Remove a conditional formatting rule WITHIN a range in Google Sheets with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/eOkwBwm_76I

Remove a conditional formatting rule by the exact range in Google Sheets with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/kJoWhXyYzWQ

Update multiple Apps Script projects from a single source with CLASPALL CLI tool. #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/Avndw9t6StM

Extract the workdays between two days in JavaScript
https://youtu.be/a2FGIDtWB_U #JavaScript #JavaScriptTutorials #VanillaJavaScript

Calculating the Workday End Date in JavaScript
https://youtu.be/pJLlAE8REZY #JavaScript #JavaScriptTutorials #VanillaJavaScript

When is a leap year? How is it calculated?

In this tutorial, we learn a simple and fast function to calculate a leap year with JavaScript for the Gregorian Calendar. #JavaScript #JS #JavaScriptTutorials https://youtu.be/-dZb30LpD5I

Create a Year Day prototype for the Date object in JavaScript.

A bonus addition to the 'Get the Day of the Year in JavaScript' written tutorial
https://youtu.be/qlEKjbmkz4Y #JavaScript ##JS #JavaScriptTutorials

Get the Day of the Year of a Date in JavaScript. #JavaScript #JavaScriptTutorials #VanillaJavaScript
https://youtu.be/1HiolzjYMuM