Skip to content
js owl

js owl

  • Tutorials
    • Java Script
    • JQuery
    • Google App Script
  • Contact
  • About Us

Google App Script

Categories Google App Script

How to Insert Todays Date in Google Docs (Using Shortcuts or Apps Script)

Google Docs don’t support formulas. Hence, it isn’t easy to populate values dynamically. However, Google has been bringing many features to Docs to enable a better writing experience. You can … Read more →

Categories Google App Script

How to Link to a Specific Sheet in a Google Spreadsheet in Apps Script – Definitive Guide

Each sheet in a Google Spreadsheet has a unique id called gid. You can link to a specific sheet in a Google Spreadsheet by appending the /#gid=uniquegid at the end … Read more →

Categories Google App Script

How to Find the Last Row of A Single Column in Google Sheets in Apps Script – Definitive Guide

The getLastRow() method in google sheets returns the end row position of the entire sheet. No method is available to get the last row of a specific column. This tutorial … Read more →

Categories Google App Script

How to Get Today’s date in the Google Apps Script – Definitive Guide

Google Apps script allows you to build your own web applications that integrate with Google Workspace. You can get today’s date in the Google apps script using the new Date() … Read more →

Categories Google App Script

How to Check if a Cell is Empty in Google Apps Script(Google Sheets) -With Examples

Google sheets cells are used to store values in a tabular format. You can check if a cell is empty in Google Apps Script using the SpreadsheetApp.getActiveSheet().getRange(“A5”).isBlank() method. This tutorial … Read more →

Categories Google App Script

How to Get the Range to Set Value of a Cell In Google Apps Script – With Examples

Cell range refers to the address of the cell in Google Sheets. You can get the range to set value of a Cell in Google Apps Script using the SpreadsheetApp.getActiveSheet().getRange(‘F2’) … Read more →

Categories Google App Script

How to Convert Unix Epoch Time to Date in Google Sheets (Formula Or AppsScript)

Unix epoch time is the date and time that is measured by the number of seconds elapsed since 00:00:00 UTC on 1 January 1970. You can convert Unix Epoch Time … Read more →

Categories Google App Script

How to Get Sheet By Name in Google Apps Script

You need to obtain the spreadsheet object of a Google Sheets when using google sheets and Google app scripts to perform operations on the sheets programmatically. You can get sheet … Read more →

Menu

  • Privacy Policy
  • Contact
  • About Us
2023 ©
JS OWL