Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Javascript Game Hangman Game – Select Letters solve the phrase – player needs to guess the hidden phrase by clicking the available letters. Solve it will as little missed letters as possible. GET the Course https://www.udemy.com/course/javascript-games/?referralCode=1FA695493D1D521C1575 JavaScript Hangman Game Board Setup. Launch app content when DOM loaded DomContentLoaded Run App DOM is ready to write … Read more
JavaScript Create 5 Fun Word Games make your own Web Games Do you want to create fun games using JavaScript – build 5 amazing interactive games perfect for kids using JavaScript Get the FULL course https://www.udemy.com/course/javascript-games/?referralCode=1FA695493D1D521C1575 4 JavaScript Wordsearch – Word searches are fun to play and even more fun to build. This game section … Read more
Create a Google Sheet Under File Menu Select ‘Publish to the web” Select under Link Sheet and as Web Page – Click Publish Check the URL provided to ensure page is visible on the web Copy Sheet ID Place the id in the JSON URL ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; const id = ‘1H2xq8J5uZKDABgu1JlvV-nVWKqZoV8_UpB_D_snOrLo’; const url = ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; 7. … Read more
https://www.udemy.com/course/javascript-learn/?referralCode=ACDDDD610F7B5821266E Fast Paced JavaScript Introduction course designed to get you started quickly – Core fundamental JavaScript Syntax Perfect course to have a quick start or refresher to JavaScript. Warning this is a fast paced courses covering a lot of concepts quickly! – Source code is included and its suggested that you try the code between … Read more
The code below will output content from a Google Sheet – as JSON into a Webapp URL which is perfect to be used from any website to connect via AJAX to get the JSON data. function doGet(e) { const id = ‘1zydy1wJynoC*****7ZFzx1t7B452UdSFqSe0E3I’; const ss = SpreadsheetApp.openById(id); const sheet = ss.getSheetByName(‘data’); const rows = sheet.getDataRange().getValues(); const … Read more
How to use Data in a Google Sheet to output as JSON for your website sharing Google Sheets as JSON get data with AJAX https://www.udemy.com/course/sheet-as-json/?referralCode=30A002EE878D362F522D Explore how you can output and share Google Sheets Content as JSON in a Web app with Apps Script Code JavaScript and Google Apps Script as the backend code to … Read more
Last chance for 2020 to get these top courses of the YEAR. JavaScript DOM Game Blackjack JavaScript Game from Scratch Explore JavaScript Document Object Model web page element updates manipulation using JavaScript code to create a GAME https://www.udemy.com/course/javascript-game-code/?couponCode=LAST2020 API Quiz Game JavaScript Project Google SpreadSheet Data Explore how to connect to a Google Sheet Data … Read more
Since myjson.com shut down – and unfortunately I was using it and referring to it in many courses. I’ve now setup some end points that you can use to practice making requests to. They are basic JSON returns on GET method requests. https://www.discoveryvip.com/shared/party.json https://www.discoveryvip.com/shared/quiz.json https://www.discoveryvip.com/shared/list.json https://www.discoveryvip.com/shared/coin.json https://www.discoveryvip.com/shared/person.json https://www.discoveryvip.com/shared/test1.json https://www.discoveryvip.com/shared/people.json https://www.discoveryvip.com/shared/data1.json https://www.discoveryvip.com/shared/peopledata.json https://www.discoveryvip.com/shared/1people.json https://www.discoveryvip.com/shared/books1.json https://www.discoveryvip.com/shared/books2.json https://www.discoveryvip.com/shared/person1000.json … Read more
Happy Tuesday – 3 FREE JavaScript Courses ready for you – TODAY ONLY How to create a JavaScript Game Number Guessing Game Project https://www.udemy.com/course/javascript-number-game/ JavaScript 3 practice projects Input form Exercise Generator https://www.udemy.com/course/javascript-project-course/ JavaScript code 3 code mini projects practice coding DOM https://www.udemy.com/course/javascript-example-code/
Title URL Google Apps Script Guide to the New IDE https://www.udemy.com/course/google-apps-script-ide/ Google Apps Script Web App and Client Side Data https://www.udemy.com/course/apps-script-web-app-sheets/ Apps Script OnOpen Trigger new Web URL Project G Suite https://www.udemy.com/course/apps-script-gsuite/ Motivation Increase your productivity How to achieve https://www.udemy.com/course/motivation-course/ CSS Learn CSS Quick Start Course for Beginners Web Design https://www.udemy.com/course/css-course-quick/ JavaScript Learn JavaScript Quick … Read more