This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const sleep = ms => new Promise(r => setTimeout(r, ms)); | |
var title = "GOPRO - 24 July 22 - Atlantis L 2nd time"; | |
var filenameEle = document.getElementById("original-filename"); | |
var filename = filenameEle.innerText.substring(0, filenameEle.innerText.length - 4); | |
var title2 = title + " - " + filename; | |
var textbox = document.querySelector("#textbox"); | |
textbox.innerText = title2; | |
document.querySelector(".use-placeholder .dropdown-trigger-text").click(); | |
await sleep(500); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Sheet > Extensions > Apps Script | |
// Add Script | |
// Add trigger for script | |
// ------------------------------ | |
// Backup script | |
function archiveCopy() { | |
var file = DriveApp.getFileById("original_file_id_to_backup"); | |
var destination = DriveApp.getFolderById("backup_folder_name"); | |
var timeZone = Session.getScriptTimeZone(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function myOnEdit() { | |
var fileId = "1Ly5SSIE9d-b_IA6VxDB1HF3pnf37SPf22KhZVv3PPiVA1w"; | |
var folderId = "1S1F8NpjOfbxY_4n27llfqh6eOs3Kb1eojaq"; | |
var file = DriveApp.getFileById(fileId); | |
var folder = DriveApp.getFolderById(folderId); | |
var now = new Date(); | |
var fileNameDate = now.getFullYear() + "-" + zeroPrefix_(now.getMonth()+1) + "-" + zeroPrefix_(now.getDate()) + 'T' + zeroPrefix_(now.getHours()) + ":" + zeroPrefix_(now.getMinutes()) + ":" + zeroPrefix_(now.getSeconds()) | |