Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
https://github.com/lsvekis/100-NodeJS-Snippets 1) Basic “Hello World” HTTP server What it does: Starts a basic HTTP server on port 3000.Use it for: Quick sanity checks, learning request/response basics. 2) Minimal server with routing (no frameworks) What it does: Routes by URL with if statements.Use it for: Tiny services, prototypes, understanding routing fundamentals. 3) Read JSON body from … Read more
https://github.com/lsvekis/100-CSS-Snippets 1) Modern CSS Reset (minimal) Does: Prevents common layout surprises (box sizing, default margins, media sizing).Use it: Put at the top of your stylesheet for consistent baseline behavior. 2) Fluid Container Does: Keeps content readable on large screens and padded on small screens.Use it: Wrap page sections in .container. 3) Responsive Typography (clamp) Does: … Read more
🚀 Vibe Coding — Issue #16 Legacy, Scale & Longevity: Vibe Coding in Large Codebases Legacy Systems • Refactoring • Risk Management • Long-Term Maintainability • AI with Restraint If Issue #15 was about teams,Issue #16 is about time. Most real-world codebases: Vibe Coding at this level is not about speed.It’s about respecting constraints while … Read more
https://github.com/lsvekis/100-Advanced-Google-Apps-Script-Examples A) Sheets: Performance, Data Ops, Automation (1–25) 1) Batch update with RangeList (fast formatting) Does: Applies formatting to many ranges in one go. 2) Write values + formulas in one pass Does: Sets values and formulas efficiently. 3) Build an index of unique keys → row numbers Does: Creates a lookup map for fast … Read more
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
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