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.

How to create custom Web Apps with Google Apps Script

by

How to create Web Apps with Apps Script Web Apps with Apps Script Web apps allow you to publish your script to the web, with a unique URL that others can then access and interact with. Best practice is to use a standalone script for web apps, although you can also create the same webapp … Read more

How to create Custom Functions in Sheets with Google Apps Script code

by

How to create Custom Functions in Sheets with Google Apps Script code How to create Custom Functions in Sheets with Google Apps Script code Google Sheets comes with 100s of built in functions You can also create your own custom functions using Google Apps Script. Custom functions are created using standard JavaScript syntax within Google … Read more

Apps Script Simple Triggers onOpen Bound Script UI menu creator lesson

by

UI Menu Maker Bound scripts can use a trigger like the special onOpen() function, which runs automatically whenever a file is opened by a user who has edit access. Using this with the ui menu maker will automatically add the menu item to the spreadsheet and allow anyone who has edit permissions access the functions. … Read more

How to Create a PDF and Email from Sheet data using Google Apps Script code lesson

by

How to Create a PDF and Email from Sheet data using Google Apps Script code lesson Generate a PDF document on the fly and send that document as an attachment to an email with all the data coming from a spreadsheet. Standalone script connecting to a spreadsheet for data and updating the selected spreadsheet. Get … Read more

Apps Script for Creating Docs and files in Drive

by

Create a script that will get data from a sheet, create content to add within a Doc. Make the Doc, update the sheet data with the doc details, and email out to the user from the sheet the doc location. Select a Spreadsheet sheet by Name – getSheetByName(‘data’) Get the data from the sheet Loop … Read more

How to Get Sheet Row Data with Google Apps Script

by

Google Apps Script allows you to create custom blocks of code that do stuff, and there is a lot of stuff you can do with it.  Container-bound Scripts – the Google file the Apps Script is attached to is known as the container.   Bound scripts behave just like Standalone scripts but they have several special functions, … Read more

Learn Google Apps Script Introduction to Google Apps Script

by

Introduction to Google Apps Script Macros within Google Sheets can be used to write Apps Script Code. Create a new spreadsheet and add some data into the sheet. In the top menu under extensions select Macro. Google Apps Script is created using standard JavaScript Syntax. Apply some changes and update the text color of some … Read more

Free ebook Learn Google Apps Script code with 10 Projects

by

Get the free ebook for learning Google Apps Script with coding examples.

Code Examples JavaScript ebook FREE ebook JavaScript Code

by

Code Examples JavaScript ebook How to remove and update array items const arr1 = [‘FIRST’,’Laurence’,’Svekis’,100,false]; const arr2 = [‘SECOND’,2332,true,’Hello’,’Svekis’,400,false]; const arr3 = arr1.concat(arr1,arr2); const arr4 = arr1; arr2.push(arr1); console.log(arr2); console.log(arr3); Array.prototype.push.apply(arr1,arr2); console.log(arr1); arr2.push(‘NEW ITEM’); arr1.push(‘Arr 1 New’); //delete arr1[12]; //delete arr2[7]; //arr1.length = 0; arr1.splice(12,1,’REMOVED’,’SECOND’); arr2.splice(3); console.log(arr1); console.log(arr2); console.log(arr3); console.log(arr4); Comparing Data Type and automatic … Read more

Data Automatic Type Conversion with JavaScript How it works with Code Examples to learn more about

by

Data Automatic Type Conversion with JavaScript How it works with Code Examples to learn more about