Dosanko SE

GAS Lab

[GAS Beginner Series #25] Display Popup Messages: Create Yes/No Confirmation Dialogs with Ui.alert()

As you get more comfortable building automation scripts and ...
GAS Lab

[GAS Beginner Series #24] Prepare Dialogs and Custom Menus: How to Use SpreadsheetApp.getUi()

Up until our previous lesson, we dove deep into the "trigger...
GAS Lab

[GAS Beginner Series #23] Manage Triggers Programmatically: How to Use ScriptApp.newTrigger() and ScriptApp.deleteTrigger()

In our previous articles (Parts 21 and 22), we explored simp...
GAS Lab

[GAS Beginner Series #22] Trigger Scripts on Cell Edits: How to Use onEdit(e) & Event Objects

In our previous session (Episode 21), we explored onOpen(e) ...
GAS Lab

[GAS Beginner Series #21] Automate on File Open: How to Use onOpen(e) and Create Custom Menus

We are finally stepping into Phase 3: Automation, UI Extensi...
GAS Lab

[GAS Beginner Series #20] Automate Google Sheets Data Sorting: How to Use Range.sort()

When managing customer lists, sales figures, or daily tasks ...
GAS Lab

[GAS Beginner Series #19] Delete Entire Rows: How to Use Sheet.deleteRow() and Avoid Multiple Row Pitfalls

To everyone handling event planning and management: thank yo...
GAS Lab

[GAS Beginner Series #18] Insert Rows at the Top of Google Sheets: How to Use Sheet.insertRowBefore()

When managing business data in Google Sheets every day, have...
GAS Lab

[GAS Beginner Series #17] Master String Manipulation: How to Use String.split() and String.replace()

Have you ever opened a customer management list or form resp...
GAS Lab

[GAS Beginner Series #16] Bulk Transform Array Data: Complete Guide to Array.map() and 2D Arrays

In our previous tutorial (Lesson #15), we covered how to nea...