Google Spreadsheet,脚本,备份文件,子文件夹 [英] Google Spreadsheet, script, backup file, subfolder
问题描述
我需要每天备份一个文件,我使用以下脚本解决了这个问题:
function myFunction (){
DocsList.getFileById(SpreadsheetApp.getActiveSpreadsheet()。getId())。makeCopy(SpreadsheetApp.getActiveSpreadsheet()。getName()+_Backup);
}
我使用时间驱动触发器设置我想要的小时该脚本创建备份文件。但是,我希望这些每日备份到达特定的子文件夹,我们称之为每日备份文件夹。
有人可以帮我一个脚本吗?
预先感谢!
使用DocsList服务:
试试:
<$ c $ b $ function bbackup(){
var backup = DocsList.getFileById(SpreadsheetApp.getActiveSpreadsheet()
.getId())
.makeCopy(SpreadsheetApp.getActiveSpreadsheet()
。 getName()+_Backup);
backup.addToFolder(DocsList.getFolder('TEST BACKUP'));
backup.removeFromFolder(DocsList.getRootFolder());
$ b但是,由于DocsList服务已折旧,因此您可能需要考虑Drive服务。
Try:
function backUP(){
DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet()
.getId())
.makeCopy(SpreadsheetApp.getActiveSpreadsheet()
.getName()+_Backup,(DriveApp.getFolderById('folder_id')));
}
填写最后一个文件夹每日备份文件夹的实际ID该脚本的行,看看是否可行?
I need to backup a file on a daily basis, I have resolved this issue using the following script:
function myFunction() { DocsList.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId()).makeCopy(SpreadsheetApp.getActiveSpreadsheet().getName() + "_Backup"); }
And I'm using the Time-driven trigger to set the hour I want the script creates the backup file. However, I would like these daily backups going to a specific Subfolder, lets call it "Daily Backup Folder".
Can someone help me with a script for that?
Thanks in advance!
解决方案using DocsList service: try:
function backUp() { var backup = DocsList.getFileById(SpreadsheetApp.getActiveSpreadsheet() .getId()) .makeCopy(SpreadsheetApp.getActiveSpreadsheet() .getName() + "_Backup"); backup.addToFolder(DocsList.getFolder('TEST BACKUP')); backup.removeFromFolder(DocsList.getRootFolder()); }
However, since DocsList service is depreciated, you may want to consider Drive service. Try:
function backUP() { DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet() .getId()) .makeCopy(SpreadsheetApp.getActiveSpreadsheet() .getName() + "_Backup", (DriveApp.getFolderById('folder_id'))); }
Fill in the actual id of the folder 'Daily Backup folder' in the last line of the script and see if that works ?
这篇关于Google Spreadsheet,脚本,备份文件,子文件夹的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!