Yagisanatode @yagisanatode@qoto.org

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

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/