Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
The replace() method returns a new version of the original string with the pattern matched values being replaced by the new string value. RegExp can be used to set the pattern to be matched, if the pattern is a string value only the first occurrence of the matched results will be replaced. Using a string … Read more
Google Apps Script Images and Files File variables 1How to create a Google Spreadsheet and give it a name, get its ID. 2How to Create a Folder and Get the ID of the Folder 2How to create a sheet and move the file into a specific folder 2How to select a file and move it … Read more
The match() method will return the resulting match of the string value from the regular expression pattern. Depending on if the g flag is used, which is the global flag the results will be returned without the g flag as the first pattern match result including the index value and the string, or with the … Read more
Regular Expressions provide a powerful way to extract information from text content. Regular Expressions or Regex can be used to search text and find matches on the search pattern. The returned results are the matches from the text on the search pattern provided. The search pattern can get fairly complex, this chapter is … Read more
Learn Google Apps Script How to interact with Google Workspace Sheets Data Source code is at https://github.com/lsvekis/Google-Apps-Script/blob/main/Youtube/Apps%20Script%20Sheets%20Common%20Question The code will cover many of the commonly asked questions I get about Apps Script. – How to update a row value – How to output a webapp with Google Apps Script – How to send data to … Read more
Use the promo code MAY-DEAL on any of my courses to get the best deal possible for the next 4 days only. More Courses https://www.udemy.com/u/lars51/ JavaScript Dynamic Web Pages AJAX 30 Projects APIs JSON https://www.udemy.com/course/ajax-json/?couponCode=MAY-DEAL Modern Web Design Beginners HTML CSS JavaScript 25+ Projects https://www.udemy.com/course/modern-web-design/?couponCode=MAY-DEAL JavaScript DOM Game Blackjack JavaScript Game from Scratch https://www.udemy.com/course/javascript-game-code/?couponCode=MAY-DEAL JavaScript … Read more
Use the Promo code MAY-BEST to get the best price possible on all my courses NOW!!! https://www.udemy.com/user/lars51/ Your chance to get these top performing courses for the best deal possible! For the next 4 days ONLY. Hurry….. *** Google Workspace and Google Services – Recommended just for you. *** Google Apps Script WebForm and Fetch … Read more
Regex Checking for Numbers in the input field Check for values that match a Regex pattern in the input field. Push a button and apply the match checker to return the results in the console. <!DOCTYPE html> <html> <head> <title>JavaScript Course</title> </head> <body> <div class=”main”> <input id=”nums” ><button>Submit</button> </div> <script> … Read more
Apps Script – Search Active Sheet to find matching text results of cells Use of the createTextFinder method to search a sheet object and return back the matching results. To get the first value use the method findNext() in the results which is an iterator. To convert all the matching results into an array object … Read more
Words Typing Display Game Words Typing Display Game Exercise is to create a speed typing game using JavaScript, the game will test time and accuracy of typed words. Each word will show, as well as the following word in the random word sequence. The objective of the JavaScript game is to type the words accuray … Read more