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 →
AWS S3 is a simple storage service that allows you to store file objects in Buckets. AWS also provides APIs to get the objects programmatically. This tutorial teaches you the … Read more →
JavaScript arrays allow you to store multiple elements of any type in a single object. In JavaScript, null and undefined values are also used to denote the falsy values. This … Read more →
Firestore TimeStamp represents date and time as a timestamp in the UTC Epoch time. This tutorial teaches you the different methods to convert a Firestore Date/TimeStamp to a JavaScript date. … Read more →
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 →
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 →
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 →
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 →
JavaScript arrays allow you to store any type of data, including strings, numbers etc. You can check for duplicate strings in an array in JavaScript using Array.filter((item, index) => stringArray.indexOf(item) … Read more →
JavaScript arrays allow you to store multiple elements in a single object. You can find a value in an array of objects in JavaScript using the array.find(obj => obj.id === … Read more →
