Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Question 11 What will the following code output? console.log(1 + “2” + “2”); a) 5b) “32”c) “122”d) NaN Answer: c) “122” Explanation: When adding a number to a string, JavaScript performs string concatenation. 1 + “2” results in “12”, and then “12” + “2” results in “122”. Question 12 What is the output of the … Read more
Question 1 What is the output of the following code? console.log(typeof NaN); a) “number”b) “string”c) “undefined”d) “NaN” Answer: a) “number” Explanation: In JavaScript, NaN (Not-a-Number) is actually of the type number. This is a special value that results from operations that don’t yield a valid number. Question 2 What does the following code snippet do? … Read more
Expanding on our previous exercises, here are three more coding challenges to further enhance your skills with Google Apps Script. These exercises will guide you through creating a custom function, automating calendar events, and generating PDF files from Google Sheets data. Exercise 7: Create a Custom Function to Calculate the BMI Objective:Create a custom function … Read more
Continuing from our previous blog post, here are three more coding exercises for Google Apps Script. These exercises will help you deepen your understanding of Apps Script by creating custom functions, manipulating Google Sheets data, and integrating with external APIs. Exercise 4: Create a Custom Function to Convert Celsius to Fahrenheit Objective:Create a custom function … Read more
“Haunted Realms Short Ghost Stories” is an anthology that brings together over fifty tales of terror, each one a unique exploration of the supernatural. The stories in this collection span a wide range of settings and scenarios, from haunted forests and abandoned buildings to modern urban legends involving social media and technology. The authors, Lars … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace products like Google Sheets, Docs, and Gmail. In this blog post, we’ll walk you through three coding exercises that will help you get started with Google Apps Script. These exercises range from creating custom functions in Google Sheets to … Read more
Landing a job as a JavaScript developer can be a rewarding career move, but the interview process can be challenging. To help you prepare and stand out from the competition, here are ten essential tips for acing your JavaScript developer interview. 1. Master the Fundamentals Before diving into complex frameworks and libraries, ensure you have … Read more
Free on Amazon https://www.amazon.ca/dp/B0D5FX4NKP or US https://www.amazon.com/dp/B0D5FX4NKP Embark on a journey through the eerie and the unknown with “Echoes of the Unknown: Volume 2,” a collection of 100 short thrilling tales and stories that delve into the realms of the supernatural, the mystical, and the downright spine-chilling. This volume, meticulously crafted by Lars Lexis and … Read more
Google Sheets is an incredibly versatile tool for managing and organizing data. However, if you want to get notified when new data is added, you need to set up some automation. With Google Apps Script, you can create a script to send email notifications whenever a new row is added to a specific sheet. This … Read more
Sorting a column of dates and times in a specific format, like “Sun, Jun 2, 2024, 11:42 PM,” can be a useful feature when managing schedules, logs, or any time-sensitive data. Google Apps Script provides a powerful way to automate this process. In this blog post, we’ll walk through the steps to write an Apps … Read more