Script - Today's Date
function onOpen(){
SpreadsheetApp.getUi()
.createMenu("Scripts")
.addItem("Make Copy With Todays Date", "makeCopy")
.addToUi();
};
function makeCopy() {
var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ss_id = ss.getId();
DriveApp.getFileById(ss_id)
.makeCopy(formattedDate.toString())
SpreadsheetApp.getUi()
.createMenu("Scripts")
.addItem("Make Copy With Todays Date", "makeCopy")
.addToUi();
};
function makeCopy() {
var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ss_id = ss.getId();
DriveApp.getFileById(ss_id)
.makeCopy(formattedDate.toString())
Comments
Post a Comment