This file contains hidden or 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 hidden or 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 hidden or 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
| This script will automatically save spreadsheet sheets when edited in Google docs. | |
| Installation: | |
| * Open your google spreadsheet | |
| * Open the script editor by clicking on Tools -> Script Editor | |
| * Paste this code into the script editor | |
| * Change the fileId to file you want to backup, | |
| eg. https://docs.google.com/spreadsheets/d/1Ly5SSIE9d-b_IA6VxDB1HF3pnf37SPf22KhZVv3PPiVA1w/edit#gid=966474823 | |
| the fileId would be: |