Yagisanatode @yagisanatode@qoto.org

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

Part 3 of the Append a Range of Data from one location in a Sheet to another with Google Apps Script. In this final tutorial, we handle for messy data that may cause other approaches to fail. #GoogleSheets #GoogleWorkspace @WorkspaceDevs

https://youtu.be/idX4CzDepFI #GoogleAppsScript

Part 2 of the Append a Range of Data from one location in a Sheet to another. Here we learn how to append a range to a sheet that has existing columns of data extending down the row with an EASY approach and a FAST binary search approach #GoogleSheets #GoogleWorkspace @WorkspaceDevs
https://youtu.be/O2WtggyNRLI

Append a Range of Cell Values to a new Google Sheet Tab with Apps Script - Simple approach #GoogleSheets #GoogleWorkspace @WorkspaceDevs
https://youtu.be/PsHp7haJgAs

Handling User Access Issues with Dialogues and Sidebars in Google Workspace Apps like Google Sheets, Google Docs, and Google Slides #GoogleSheets #GoogleWorkspace #GoogleDocs #GoogleSlides @WorkspaceDevs
https://youtu.be/aQgUYUPpiag

Assess Issues with Dialogues and Sidebars in Google Workspace Apps like Google Sheets, Google Docs, and Google Slides #GoogleSheets #GoogleWorkspace #GoogleDocs #GoogleSlides @WorkspaceDevs
https://yagisanatode.com/google-workspace-custom-dialog-access-denied-and-similar-errors/

I really enjoyed this Google Workspace Add-On walkthrough (GWAOw!) for Sign PDF with Jotform Sign. So much so that I moved to them as my signing platform. Check out the walkthrough: https://yagisanatode.com/gwaow-6-sign-pdf-with-jotform-sign/ #GoogleWorkspace @jotform #businessadmin

A Better Financial Year Formula In Google Sheets #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript #financialYear @WorkspaceDevs
https://yagisanatode.com/a-better-financial-year-formula-in-google-sheets/

Get the last value in a range in Google Sheets #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://www.youtube.com/watch?v=9JGiO5_lqF8t/

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://yagisanatode.com/prevent-consecutive-clicks-of-google-sheets-image-buttons-in-with-lock-service-and-google-apps-script/

This article by @edzitron very much articulates my experiences and feelings about the current tech industry. Good products left to stagnate or enshitify while products we don't need are forced down our throats all in the name of 'innovation'. https://www.wheresyoured.at/rotcombubble/

Now choose to display ALL selected Shared Drive folders OR only those created by you in the Product version of 'List all Files and Folders in a Google Drive Directory in Google Sheets'

https://yagisanatode.com/products/product-list-all-files-and-folders-in-a-google-drive-directory-in-google-sheets/

#GoogleSheet #GoogleAppsScript #AppScript @WorkspaceDevs