Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Laurence Svekis 
https://github.com/lsvekis/Apps-Script-Code-Snippets Accidentally overwriting data is one of the most common problems in shared Google Sheets. Someone edits a completed row.A formula gets replaced.A “final” value quietly changes. Google Sheets has Protected Ranges, but managing them manually doesn’t scale. In this tutorial, you’ll build a Google Apps Script that: ✅ Watches for edits✅ Detects when a … 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
https://github.com/lsvekis/Apps-Script-Code-Snippets Duplicates in a spreadsheet aren’t always “bad”—but sometimes they’re a sign of a problem. A common pattern is: you want values to be unique as you enter them, and if someone repeats a value that already appeared earlier in the same column, you want an instant visual warning. In this tutorial, you’ll build an … 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
Becoming a Meta-Learner: Exercises 1–5 (Complete + Worked Examples) What these exercises build A meta-learner doesn’t just learn topics — they improve their learning process over time. These exercises turn your learning into a system that adapts to you. 🎯 Exercise 1 — Look Back (Pattern Mining) What the student does Pick 3 recent things … Read more
How to Build a Google Docs Add-On with Apps Script (Step-by-Step) https://github.com/lsvekis/Google-Docs-Addon Google Docs is incredibly powerful—but when documents are copied from Word, PDFs, LMS systems, or email, formatting quickly turns into chaos. Instead of fixing formatting manually every time, you can build a Google Docs Add-on using Google Apps Script that runs directly inside … Read more
🌟 VIBE LEARNING — ISSUE #20 (ADVANCED) Becoming a Meta-Learner: Learning How You Learn Best The final skill that makes all other skills easier to acquire. 👋 Welcome to Issue #20 (Advanced) By now, you’ve learned how to: This final issue focuses on the skill behind all skills: Meta-learning — understanding, adapting, and improving your … Read more
🚀 Vibe Coding — Issue #13 Choose Your Path: Vibe Coding Playbooks for Real Growth Beginner • Frontend • Learning • Leadership • Career Tracks By now, one thing should be clear: There is no single “right” way to use AI.What works depends on where you are and what you’re trying to improve. Issue #13 … Read more