Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Why Use Custom Formulas in Google Sheets? Google Sheets already comes packed with tons of functions, but there are times when you need something more specialized. Custom formulas allow you to simplify calculations, automate repetitive tasks, and introduce unique functionality into your spreadsheets. The best part is that creating these custom functions is easier than … Read more
40 Advanced JavaScript Coding Exercises Deep Clone an Object Using Recursion Objective: Create a function that performs a deep clone of an object, handling nested objects and arrays. function deepClone(obj) { if (obj === null || typeof obj !== ‘object’) { return obj; } const clone = Array.isArray(obj) ? [] : {}; for (let key … Read more
Editing text in Google Docs can sometimes become repetitive and time-consuming, especially when you need to apply specific formatting to certain elements throughout the entire document. Luckily, Google Apps Script allows you to automate many tasks, saving you valuable time and ensuring consistency. Today, we’ll look at a script that does just that: it automatically … Read more
If you’ve ever had to manually edit paragraphs in a Google Doc, you know it can be a tedious task. For example, imagine working through a document where you must find every paragraph starting with “// Exercise X:” and convert them into proper headings. Not only is this repetitive, but it’s also easy to make … Read more
Mark your calendars for Devfest 2024, hosted by GDG Ottawa! This highly anticipated event is set to take place on November 10th in Ottawa! Devfest 2024 is a premier gathering for developers, tech enthusiasts, and industry leaders, offering a unique blend of learning, networking, and innovation. The event features an impressive lineup of expert speakers from … Read more
Introduction: Google Apps Script allows you to extend the functionality of Google Sheets by creating custom formulas and functions. These custom functions behave just like built-in spreadsheet functions and can be used directly within cells. By leveraging custom functions, you can perform complex calculations, manipulate data, and integrate external services directly from your spreadsheet. This … Read more
Advanced JavaScript Guide Welcome to the Advanced JavaScript Guide! This guide is designed for developers who have a basic understanding of JavaScript and want to delve deeper into advanced concepts. We’ll cover complex topics, provide code samples, and include quizzes and exercises to test your knowledge. Advanced Functions Functions are the building blocks of JavaScript. … Read more
JavaScript Objects Tutorial for Beginners Welcome to the JavaScript Objects tutorial for beginners! This guide is designed to help you learn JavaScript Objects from scratch. We’ll cover the basics, provide coding examples, and include quiz questions to test your understanding. By the end of this tutorial, you’ll have a solid foundation in JavaScript Objects and … Read more
Welcome to the JavaScript Data Types tutorial for beginners! This guide is designed to help you understand the different data types available in JavaScript. We’ll cover the basics, provide coding examples, and include quiz questions to test your understanding. By the end of this tutorial, you’ll have a solid foundation of JavaScript data types and … Read more
Python Tutorial for Beginners Welcome to the Python tutorial for beginners! This guide is designed to help you learn Python from scratch. We’ll cover the basics, provide coding examples, and include quiz questions to test your understanding. By the end of this tutorial, you’ll be able to write simple Python programs and have a strong … Read more