Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
1) Custom menu in Google Sheets Does: Adds a menu item so users can click to run functions.How it works: onOpen() runs automatically when the file opens (for editors), and SpreadsheetApp.getUi() adds UI. function onOpen() { SpreadsheetApp.getUi() .createMenu(‘Tools’) .addItem(‘Say Hello’, ‘sayHello’) .addToUi(); } function sayHello() { SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } 2) Show a toast … Read more
https://github.com/lsvekis/Apps-Script-Code-Examples 1) Add a Custom Menu on Open (Sheets) Does: Adds a menu to your spreadsheet UI.Use when: You want easy buttons for scripts. function onOpen() { SpreadsheetApp.getUi() .createMenu(‘Tools’) .addItem(‘Say Hello’, ‘sayHello’) .addSeparator() .addItem(‘Run Cleanup’, ‘cleanup’) .addToUi(); } function sayHello() { SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } function cleanup() { SpreadsheetApp.getUi().alert(‘Cleanup placeholder.’); } 2) Show a … Read more
🧠 Vibe Learning Extension Pack 10 Advanced Exercises to Go Beyond the Workbook If you’ve worked through the Vibe Learning Workbook, you’ve already learned how to: Now it’s time to level up. This extension pack introduces advanced, real-world exercises designed to help you: These exercises assume you’ve completed (or understand) the core ideas in the … Read more
Build AI Apps with Google Apps Script Free: January 6 – January 10, 2026 Amazon US | Amazon Canada Smarter Learning with AI – Vibe Learning Free: January 7 – January 11, 2026 Amazon US | Amazon Canada Learning to Work With Generative AI (Beginner’s Guide) Free: January 8 – January 12, 2026 Amazon US … Read more
1 FOUNDATIONS: PERSONALIZED LEARNING Goal of Issue 1: Teach AI how you learn, and teach you how to control explanations. 🎯 Exercise 1 — Personal Learning Profile (FOUNDATIONAL) What the Learner Does You teach the AI who you are as a learner so it stops guessing. Prompt Ask me 12 questions to create my Personal … Read more
🚀 Node.js Interview Quiz (100 Questions with Answers) 1️⃣ Node.js Fundamentals (1–15) 1) What is Node.js? Answer: A JavaScript runtime built on Chrome’s V8 engine.Explanation: Node.js allows JS to run outside the browser, mainly for servers and tooling. 2) Is Node.js single-threaded? Answer: Yes (but it uses background threads).Explanation: JS runs on one thread, but … Read more
1) Basics, Types, Coercion (1–15) 1) What is the result of typeof null? A) “null” B) “object” C) “undefined” D) “number”Answer: B Explanation: A long-standing JS quirk: typeof null returns “object”. 2) What does NaN === NaN evaluate to? A) true B) falseAnswer: B Explanation: NaN is not equal to anything, even itself. Use Number.isNaN(x). … Read more
If you’re serious about improving your JavaScript skills, reading alone isn’t enough — you need structured, real-world practice. I’ve just published 30 additional JavaScript coding exercises (Exercises 21–50), each one including:✅ Full, working code✅ Clear learning objectives✅ Step-by-step explanations✅ Practical DOM, async, and browser API examples This set goes beyond basics and helps you practice … Read more
https://github.com/lsvekis/Doc-Cleanup-Toolkit User & Developer Guide This guide explains what the Google Docs Cleanup Toolkit does, how to use it safely, and how each part of the system fits together. 1. What This Toolkit Is The Google Docs Cleanup Toolkit is a Google Apps Script project that helps you: It is designed to be: 2. Who … Read more
Key Ideas, Frameworks, and Systems from the First 10 Issues Learning has fundamentally changed. We now live in a world where artificial intelligence can explain, quiz, challenge, coach, critique, and adapt to us in real time. Yet most people still use AI the same way they use a search engine—asking shallow questions and getting shallow … Read more