Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Add Columns with Apps Script Sort By Column Index value Filter the rows in a Google Sheet Create a pivot table in a Google Sheets Create a new Google Slides presentation Add Columns with Apps Script function addColumn() { const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheet = ss.getSheets()[0]; const sheetName = sheet.getName(); sheet.insertColumnBefore(1); const lastCol = … Read more
Here are top tips for YouTube marketing in full detail with steps to achieve a better ranked channel: Here are some additional tips that can help you achieve a better ranked channel: More tips for YouTube marketing: By following these tips, you can increase your chances of success on YouTube. Just remember to be patient, … Read more
How to Grow Your YouTube Channel Growing a YouTube channel requires a well-planned strategy that takes into account various factors such as content creation, audience engagement, promotion, and optimization. Here is an outline of a YouTube channel strategy that can help you grow your channel: By following these strategies, you can grow your YouTube channel … Read more
Google Apps Script is a scripting language based on JavaScript that allows users to extend and automate the functionality of various Google services such as Sheets, Docs, Forms, and Gmail. It provides a wide range of services and methods for interacting with Google Apps and allows users to create custom scripts and applications that integrate … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The first function makeSlides() creates a new Google Slides presentation titled “Laurence Test2”. The function then retrieves the first slide in the presentation and inserts a new text … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The code modForm() does the following: The variable id is assigned the ID of an existing Google Form. The openById() method of FormApp is used to open the … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) Sets the id variable to a specific Google Sheets ID. Opens the Google Sheets file with the given id, selects the sheet named “users”, and retrieves all the … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) dataFolder() function The dataFolder() function does the following: Sets the sid variable to a specific Google Sheets ID. Sets the id variable to a specific Google Drive folder … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The getUserInfo() function takes an id parameter and returns an object containing information about a user. It first sets a variable sid to a string value, which is … Read more
Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) This code creates a new Google Form with a title, a text question, and a multiple choice question with three choices. It also logs the URL of the … Read more