How do I script making a backup copy of a spreadsheet and its values not its formulas to an archive folder? -


i new google app scripts , have been looking way sheet. using.

driveapp.getfilebyid("146qfnrqonpbcdhv6qb0bschfp8tquxjoac1qg‌​_esy4e").makecopy("d‌​ailyarchive" + date() + " backup");

the problem making daily backup , backups updating original , want make backup of values have archive. in sheet importing data jail roster. http://www.kitsapgov.com/sheriff/incustody/jailwebname.xml

here quite simple 1 sheet (you can adapt several sheets)

  var source = spreadsheetapp.getactivespreadsheet();   var data = source.getactivesheet().getdatarange();   var cible = spreadsheetapp.create(source.getname()+" backup");   cible.getactivesheet().getrange(data.geta1notation()).setvalues(data.getvalues());   logger.log(cible.getid());   logger.log(cible.geturl()); 

Comments