Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
I’m happy to annouce that I’m on michaelmanagement.com https://www.michaelmanagement.com/instructor/laurence-svekis Check out some of my courses USE the coupon code STUDENT to get 90% off the course.
Want to learn more about JSON and how to use it in your web pages? Check out this course. FREE TODAY – Learn JSON for beginners with JavaScript https://www.udemy.com/course/json-javascript-course/ Happy Wednesday 🙂 Enjoy the FREE Course of the DAY – About JavaScript and JSON for web pages – Source code and Code examples INCLUDED…… Limited … Read more
Create your own wordsearch its easy – add words to the first column in your Google Sheet. Publish the sheet and get the URL id of the sheet. The application will generate the WordSearch as well you can link to your own WordSearches and share the link. Try it for yourself here : https://games.basescripts.com/
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