google apps script - moving folders in drive using sheet -


back on seemingly impossible task. apparently people in office can't move folders around drive, task automate moving process. can see in sheet (link below) have setup routing system.

https://drive.google.com/file/d/0b2lmfutaxagkn1vhqlphofeynvk/view?usp=sharing

i have criteria, such name of folder, folder should in, , folder needs moved to. basically, i'm trying find script following things:

1) works when button selected in google sheet 2) moves folder in drive folder folder b. 3) using cell references.

don't know how find folder id, wouldn't folder moved change based on spreadsheet criteria. , can't use outside program it's on government system. ideas? have great piece of script, doesn't seem work using cell references.

function copyandmove(file,folder){ var newfile=file.makecopy('copy of '+file.getname(d9)); newfile.addtofolder(b1);// newfile.removefromfolder(docslist.getrootfolder());}

any appreciated!

to value in cell have use format below

 var ss = spreadsheetapp.getactivespreadsheet();  var sheet = ss.getsheets()[0];  // first argument row, second column. 1,2 returns value in b1  var range = sheet.getrange(1, 1);  var value = range.getvalue();

so final code be

function copyandmove() {      var ss = spreadsheetapp.getactivespreadsheet();      var sheet = ss.getsheets()[0];  // first argument row, second column. 9,4 returns value in d9      var d9 = sheet.getrange(9, 4).getvalue();      var b1 = sheet.getrange(1, 2).getvalue();      var file = driveapp.getfilesbyname(d9).next();      var folder = driveapp.getfoldersbyname(b1).next();      var newfile = file.makecopy('copy of '+ d9, folder);      file.settrashed(true);  }

i'm not sure wanted newfile.removefromfolder(docslist.getrootfolder()); if wanted delete original file last line of function that.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more