Laurence Svekis

Laurence Svekis is a web technology enthusiast, educator, and author who has been working in the field for over 20 years. He has expertise in web development technologies, such as HTML, CSS, JavaScript, jQuery, Bootstrap, PHP, and MySQL. Svekis is a prolific course instructor on Udemy, with over 500,000 students enrolled in his courses. He has authored over 100 online courses, covering a wide range of web technologies and tools, such as Google Apps Script, WordPress, React, Node.js, Express.js, and MongoDB. His courses are known for their practical and hands-on approach, with a focus on real-world projects and examples. In addition to teaching, Svekis is also a published author, with several books to his name Svekis is passionate about empowering people with the skills and knowledge they need to succeed in the rapidly evolving field of web technology. He is committed to providing high-quality educational resources that are accessible to anyone, regardless of their background or experience level.

Node js What Does [Object: null prototype] Mean

by

The output [Object: null prototype] { adf: ‘bsdf’ } appears in the console when you log req.body in your Express.js application because of how the body-parser middleware processes incoming JSON data. What Does [Object: null prototype] Mean? The notation [Object: null prototype] indicates that the object being logged is a plain object created with a … Read more

How to Modify Node.js Code to Handle an Object from a JSON File

by

The current code reads a JSON file, parses it into an object, and then logs certain values to the console. We’ll go through the steps to make this code more flexible by allowing it to handle a JSON object. Here’s the code as it stands: const http = require(‘http’);const fs = require(‘fs’);const site = http.createServer(function(req, … Read more

Understanding Logger.log in Google Apps Script

by

In Google Apps Script, the Logger class provides simple logging functionality that can help you debug your scripts by recording messages in the Google Apps Script log. This log can be viewed in the Apps Script editor under the “Executions” or “Logs” tabs. Basic Usage of Logger.log The Logger.log method is used to record messages. … Read more

Calculating Cost Per Item with Discount Using Google Apps Script

by

In this blog post, we will delve into a Google Apps Script function that calculates the cost per item, considering any applicable discounts. This script is especially useful for e-commerce platforms or any other scenarios where discounts and coupon codes are used to determine the final cost of products. We will explain the code in … Read more

Calculating the Total Cost Using Google Apps Script

by

Google Apps Script is a powerful tool that allows you to automate tasks and enhance your Google Sheets capabilities. In this blog post, we will demonstrate how to use Google Apps Script to calculate the total cost from a sample data table. This script can be especially useful for financial calculations, budgeting, or any scenario … Read more

Copying and Manipulating Data with Google Apps Script

by

In this blog post, we will explore how to use Google Apps Script to copy data from one Google Sheet to another. Specifically, we will copy five columns, excluding one column, and ensure that our destination sheet has an auto-incrementing number for the first column. Additionally, we will eliminate any duplicate rows in the process. … Read more

Importing Data from Another Spreadsheet Using Google Apps Script

by

Importing data from one Google Sheet to another can streamline data consolidation and ensure that you always have the latest information in one place. Google Apps Script provides an efficient way to automate this process. In this blog post, we will walk through how to import data from one spreadsheet to another using Google Apps … Read more

Generating PDFs from Sheets Generate PDFs from Google Sheets Using Apps Script

by

Automatically generate PDFs from your Google Sheets data: Step-by-Step Guide: function createPDF() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var folder = DriveApp.getFolderById(‘your-folder-id’);var pdf = DriveApp.createFile(sheet.getBlob().getAs(‘application/pdf’));folder.createFile(pdf);} Explanation:

Logging Data Changes Track Data Changes in Google Sheets with Apps Script

by

Track and log changes in your Google Sheets data. Here’s how: Step-by-Step Guide: function onEdit(e) {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var range = e.range;var newValue = e.value;var oldValue = e.oldValue;var logSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Log’);logSheet.appendRow([new Date(), range.getA1Notation(), oldValue, newValue]);} Explanation:

Creating a Reminder System Build a Reminder System with Google Apps Script

by

Set up automated reminders based on your Google Sheets data: Step-by-Step Guide: function sendReminders() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var data = sheet.getDataRange().getValues();var now = new Date();for (var i = 1; i < data.length; i++) {var email = data[i][0];var reminderDate = new Date(data[i][1]);if (reminderDate <= now) {MailApp.sendEmail(email, ‘Reminder’, ‘This is your reminder!’);}}} Explanation: