Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
JavaScript QUIZ 25 Test your Knowledge! What will console.log(typeof undefined) output? A. “undefined” B. “object” C. “null” D. “string” Which statement creates a constant in JavaScript? A. var myConst = 10; B. let myConst = 10; C. const myConst = 10; D. myConst = 10; Which of these is a correct method to create a … Read more
Question 1 Q: What is the output of “10” + 20 in JavaScript? A: 2. “1020” Question 2 Q: Which method can be used to convert JSON data to a JavaScript object? A: 1. JSON.parse() Question 3 Q: What does the map() method do? A: 1. Modifies each item in an array and returns a … Read more
Exercise 21: Generating a Table of Contents in Google Docs Objective: Create a script to automatically generate a table of contents in a Google Document based on heading styles. Code Sample: function generateTOC() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var toc = body.appendParagraph(“Table of Contents”); toc.setHeading(DocumentApp.ParagraphHeading.HEADING1); var paragraphs = body.getParagraphs(); paragraphs.forEach(function(paragraph) { … Read more
Exercise 16: Automated Email Responses Using Gmail Objective: Write a script to automatically send a response to every email received with a specific subject. Code Sample: function autoRespondToEmails() { var query = ‘subject:”specific subject” is:unread’; var threads = GmailApp.search(query); var response = “Thank you for your email. We will get back to you shortly.”; threads.forEach(function(thread) … Read more
Exercise 11: Generating a Report from Google Forms Responses Objective: Create a script to generate a summary report from Google Forms responses in a Google Sheet. Code Sample: function generateFormReport() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Form Responses 1”); var data = sheet.getDataRange().getValues(); var report = {}; for (var i = 1; i < data.length; i++) { … Read more
Exercise 6: Create an Automated Reminder in Google Calendar Objective: Write a script to create a calendar event and set an email reminder. Code Sample: function createCalendarEvent() { var calendar = CalendarApp.getDefaultCalendar(); var startTime = new Date(‘March 15, 2024 10:00:00’); var endTime = new Date(‘March 15, 2024 11:00:00’); var event = calendar.createEvent(‘Meeting with Team’, startTime, … Read more
🚀 Boost Your Google Workspace Skills: Exciting Google Apps Script Exercises! 📊👩💻 Exercise 1: Create a Custom Menu in Google Sheets Objective: To create a custom menu in Google Sheets that triggers a simple script. Code Sample: function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu(‘Custom Menu’) .addItem(‘Show Alert’, ‘showAlert’) .addToUi(); } function showAlert() { SpreadsheetApp.getUi().alert(‘Hello, … Read more
🚀 Unveiling Advanced Google Apps Script Mysteries: A Deep Dive for Developers! 📊 Question 1: How does Google Apps Script handle date and time operations, and what are some common pitfalls? Answer: Google Apps Script uses the JavaScript Date object for date and time operations. Common pitfalls include handling time zones and daylight saving time … Read more
🌟 Unraveling the Mysteries of Advanced JavaScript – A Deep Dive! 🚀🔍 JavaScript Questions and Answers Question 6: What is a Promise in JavaScript and How Does it Work? Answer: A Promise in JavaScript is an object representing the eventual completion or failure of an asynchronous operation. It allows you to write asynchronous code in … Read more
JavaScript Questions and Answers Question 1: Explain Event Delegation in JavaScript. Answer: Event delegation is a technique involving adding an event listener to a parent element instead of multiple child elements. When an event occurs on a child element, it bubbles up to the parent, which handles the event through a single listener. This is … Read more