google apps script - How do I move a spreadsheet from the root to my active folder? -

-

i use following code create new spreadsheet.

function addnewspreadsheetwithfoldershift() { var source = spreadsheetapp.getactive();  var ssid=source.getid(); var fileindocs = docslist.getfilebyid(ssid); var folder=fileindocs.getparents()[0]; var foldername = folder.getname(); var folderid = folder.getid(); var timezone=session.gettimezone(); var dtstamp= utilities.formatdate(new date(), timezone, 'yyyy:mm:dd  hh:mm:ss  zzz'); var user=session.geteffectiveuser().getemail(); var output_name=dtstamp+"linechecks" var ssout = spreadsheetapp.create(output_name);  // create new spreadsheet, output_name. ssout.addtofolder(folder); }

it winds in root directory. wind in directory started from. tried using addtofolder seems files can moved using it. there way move newly created spreadsheet?

you can use docslist service move file after creation, try :

  ...   var ssout = spreadsheetapp.create(output_name);  // create new spreadsheet, output_name.   var root = docslist.getrootfolder();   var folder = docslist.getfolderbyid('your folder id');// or use getfolderbyname if want   var ssoutid = ssout.getid();   var newfile = docslist.getfilebyid(ssoutid); // begin 'move folder process'   newfile.addtofolder(folder);   newfile.removefromfolder(root);// had in 2 separate steps  }

Comments

Post a Comment

Popular posts from this blog

mod rewrite - Using "?" when rewriting the URL -

-
i have been researching weeks looking how rewritting file/directory complementary "?" or "question mark" what need: http://mydomain.com/demo01.php to like: http://mydomain.com/?theme=jerus theme > simple directory need use websites products(in case themes) jerus > name of theme extra info: i plan on rewritting every url individually refrain wildcard varibles.** wouldn't easy instead of doing url rewriting put php in directory called theme , name index.php? http://mydomain.com/theme/?t=jerus but if you're re-writing urls make rule acutally make route this: http://mydomain.com/theme/jerus/ which waaaay prettier see question: using clean urls in restful api
Read more

.htaccess: Transfer name to index.php if not directory public -

-
i have piece of code: options followsymlinks <ifmodule mod_rewrite.c> rewriteengine on rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewriterule ^(.*)$ index.php?url=$1 [l] </ifmodule> <ifmodule !mod_rewrite.c> errordocument 404 /index.php </ifmodule> i don't know how allow directory name "public" inside folder .htaccess, other names dir should transfered index.php. how that? add rewritecond exclude public directory rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_filename} !-l rewritecond %{request_uri} ^/public(/.*)?$ rewriterule ^(.*)$ index.php?url=$1 [l] now, redirection work /public directories only. if want url have rest of path that's below public url=subfolder/page.php /public/subfolder/page.php use rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewrit...
Read more

Admob integration with pygame in android -

-
hello curious know solution integrating admob app written in pygame subset android. have tried below things did' t work me :( still nothing working me may there no way :( try 1: followed google https://developers.google.com/mobile-ads-sdk/docs/admob/fundamentals#android solution has no code change build.xml modification didt works me :( try 2: tried below solutio also. http://www.michenux.net/android-admob-tutorial-461.html did't work me :( try 3: tried hack pythonactivity.java. getting below related errors. have googleadmobadssdk-6.4.1.jar in \pgs4a-0.9.4\libs path still below kind of error. below code: protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //vrbilgi setcontentview(r_layout_main); // setcontentview(r.layout.main); // create adview // adview = new adview(this, adsize.banner, my_ad_unit_id); adview = new adview(this, adsize.banner,"a15...
Read more