Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Top courses for 2022 and updated courses below: Use the promo code SECOND-22 to get the best price possible on my courses, top courses listed below. 53+ Hours of HD video – JavaScript Projects JavaScript Projects Games 55 Modern JavaScript DOM ES6 Loaded with Coding Examples Modern JavaScript – Wow 50+ Hours of HD Video … Read more
Today Only Save 50% on my book/liveProject series and other selected titles @ManningBooks: http://mng.bz/WrEx AI as a Service; From On-Prem to AWS (Four-Project Series); Creating a WhatsApp Notification Service Using AWS Lambda and a Serverless Framework; and Explore the Power of Google Docs are being featured as related titles in the Deal of the Day on November 28th, along … Read more
Sheet data as table in docSelect all the sheet data range as an array of values Get the values as a nested array of array items. Select the doc and use the appendTable to the body of the document. DocumentApp.openById(DOCID).getBody().appendTable(getValues1()); const SHEETID = ‘1u7vPqjklpmn8ygU’;const DOCID = ‘1yoV_oFO-v7963hhIrY’; function getValues1() {const ss = SpreadsheetApp.openById(SHEETID);const sheet = … Read more
How to connect to a JSON API output results on page using AJAX JavaScriptIn this example we connect to the Star Wars API at https://swapi.dev/The API returns results that are within an array format, then using JavaScript loop through the results array and output either the title or the name that is being returned into … Read more
How to Get Vowels from a string Using the match method you can select the RegExp results and create an array of items from the results. In this case the regular express will return all matches of “aeiou” both upper and lower case and global using the flags gi Select the page elements const output … Read more
Keep your kids busy with Math Quizzes, Free addon for Google Docs create fun Math quizzes, even adults test your knowledge. https://workspace.google.com/marketplace/app/math_quiz_maker/708278458140?hl=en-CA Simple Add on to Generate Random Math Questions within you Google Docs. You select the number of questions, the values of the numbers and the operators you want in the questions. Magically creates … Read more
Anyone looking for a FREE WordSearch maker in Google Docs, I created this about 1 year ago its an addon for Docs and creates wordsearches from a list of words you can customize. Enjoy https://workspace.google.com/marketplace/app/wordsearch_maker/921473344337?hl=en-CA #google #wordsearch
Use the promo code EARLY1-22 to get the BEST PRICE POSSIBLE on my courses! I’ve selected the below courses for you! JavaScript Dynamic Web Pages AJAX 30 Projects APIs JSON https://www.udemy.com/course/ajax-json/?couponCode=EARLY1-22 Modern Web Design Beginners HTML CSS JavaScript 25+ Projects https://www.udemy.com/course/modern-web-design/?couponCode=EARLY1-22 Google Apps Script Complete Course New IDE 100+ Examples https://www.udemy.com/course/course-apps-script/?couponCode=EARLY1-22 Complete JavaScript Projects Course … Read more
You can use the code snippet to check the web app URLs and if you are making AJAX requests to the web app as an endpoint these will return the request values.
Git and GitHub Pages Quick Setup GuideGo to https://github.com/ and create an account. Then setup a new repository. Click the Green Code button in the drop down menu to get the HTTPS URL for the repo. You will need this to clone the repo to your local machine. Open your editor, I am using https://code.visualstudio.com/ … Read more