Looking for a script that can provide me with the last modified time and date of a Google Sheet.
I have all the Google Sheet workbook IDs listed in column E of a sheet named 'Planner Directory' and I need to display the last modification details in column F.
If anyone could help with this, it would be greatly appreciated. Thank you!
Since you have all the data conveniently stored in a Google Sheet, the most efficient way to automate tasks is by using Google Apps Script. Below is an example of how you can make this process work seamlessly.
function myFunction() {
var ss = SpreadsheetApp.getActive().getSheetByName("Sheet20"); // Modify this to match your sheet name
var range = ss.getDataRange();
var values = range.getValues();
for(var i=1; i<values.length; i++)
{
values[i][1] = lastModifiedTime(values[i][0]); // 0 represents the column where IDs are stored
// 1 represents the column where time will be displayed.
}
range.setValues(values);
}
function lastModifiedTime(id)
{
var file = DriveApp.getFileById(id);
return file.getLastUpdated();
}
Replace the Sheet ID fields with the appropriate IDs.
https://i.sstatic.net/kQKMb.png
https://i.sstatic.net/PSV5y.png
Make sure to adjust the format of the column where you want the last modified time to be displayed as Number > Date time.
To automate this script, set up a time-driven trigger within Google Apps Script to run the script at specified intervals (e.g., every 5 or 10 minutes) for accurate and updated results.
https://i.sstatic.net/aG2s0.png
After implementing the recommended script to retrieve the last modified date of a file, I encountered a couple of challenges. Despite formatting the column as Date, the formula in the adjacent cell failed to recognize the last modified date as today's date.
The formula does not seem to acknowledge the date provided by the script, even with the correct formatting.
Furthermore, running the suggested script caused the formula to be overwritten with static text instead.
I'm currently delving into the world of promises. Here is a snippet of my code: checkEmailUsername = function(email, username) { return new Promise(function(resolve, reject) { var query; query = "SELECT * FROM users WHERE email = ? O ...
I am looking to differentiate between true and false using filter() but it keeps initializing the value to true and false. I want all true values to appear on one side and false values on another side, with a line separating them. ...
Trying to implement slick.js, a carousel framework, in an Angular project. Initially attempted 'npm install slick --save' and manually adding the downloaded files to scripts and styles JSON objects. When that failed, resorted to importing the C ...
I have created a blog page with options for signing up and signing in. I used the req.locals.<name> method Using the GET method. Code snippet from server.js app.get('*',(req,res, next) => { res.locals.user = req.user || null; ...
Attempting to develop a Vue SPA app, but encountering an issue with the routes not matching what was defined in the router. Despite all configurations seemingly correct, there is confusion as to why this discrepancy exists. What element might be overlooked ...
I am having trouble getting my jQuery code to display a specific paragraph when a particular div is clicked on. My goal is for the content "v" to be displayed if the user clicks on the ".Virus" div, and for the contents of ".screenInfo" to be shown if the ...
Can someone help me understand why I'm getting an 'undefined' response when I use console.log(tooltipValues), but there's no issue with console.log(tooltipJSON). I've noticed that when I embed the data directly in my JS code, ever ...
Can you provide guidance on how to run the same code for multiple pages using routes? Below is an example I am currently exploring: var routeManager = { _routes: {}, // Collection of routes add: function(urls, action) { urls.forEach(fun ...
Seems like this question might be a duplicate, but I'm not bothered. Despite searching on Google, I haven't found a solution. What could be the mistake here? $(document).ready(function() { $("#foo").click(function() { $.ajax({ type ...
I have gone through various forums and discussions regarding this issue, but none of the solutions seem to work for me. For some reason, I am facing difficulties passing props to react-navigation when I attempt to navigate, resulting in the following erro ...
Trying to create a new MDX blog website using Next.js 13 with the latest app router, but encountering an error message saying "Module not found: Can't resolve 'fs'". It was working fine in Next.js 12 and pages directory, but not in the lates ...
Suppose you have an observable containing a large number of elements, say 450 or more. You want to transfer these elements to a different observable in batches of 100 elements each. You can check out a functional example provided by @martin at this link: ...
Just starting out with react and I have an array of image URLs. My current output looks like this: Output Image Link: Looking to remove the scroll bar at the bottom and get rid of scrolls entirely. Here's how I want it to look: Expected Output: Wa ...
While working on an Express JS project, I encountered issues trying to install the bcrypt module for data authentication. Despite multiple attempts, I kept receiving the same errors. [email protected] install /media/iron/1d6c195f-2350-423c-a3f0-050 ...
Currently, I am developing an Angular application where I am dealing with a specific array that contains a flag named "checked". Based on the value of this flag, I need to perform certain manipulations. Here is a snippet of my sample data: const data = [{ ...
For my e-commerce React.js web app, I want to show the rating value of each product. Using the JS map function, I was able to track which product was hovered by its index ('onChangeActive' is the handler for this). {products.map((product, index) ...
I've been working on AngularJS and created a basic module and controller. I'm attempting to show the data of an element inside the controller on the HTML view page, but all I see is {{student.name}} and I'm receiving an error message that sa ...
Currently, I am developing a mobile app using Ionic and I am in need of a popup window to collect two pieces of data - a username and a password. After researching several websites, I was unable to find a solution that addressed collecting two pieces of ...
Is there a way to pass a JavaScript array as a parameter in an AJAX GET request? I am currently dealing with an API call and have a method that requires three parameters, with the third one being an array. ...
Currently in the process of updating my react site to version 16.8, I have encountered an issue with a material ui table. The functionality involves users selecting certain options, triggering a rest call when a button is clicked, and then displaying the r ...