Google apps spreadsheet parents folder ID -

-

i have google spreadsheet keeping track of files , names inside folder spreadsheet is.
have looked , can not find how location or id of sheet
in ms cmd script "%~dp0".
how in google apps spreadsheet script.

 function fnctnmenuupdategetlocation() {  var ss = spreadsheetapp.getactivespreadsheet();   var ssid=ss.get.getid();   var file = docslist.getfilebyid(ssid);    browser.msgbox(ssid);   browser.msgbox(add); }

https://docs.google.com/spreadsheet/ccc?key=0amsqn3n9km70dgwtltjxvvbzbmjhdme5ofpkbtvxele&usp=sharing ya, working in it
live sheet

from have how address of spreadsheet in google drive
spread sheet having add folder/dir , file need

since google docs not google drive how interface spreadsheet google drive

both document service , drive service can report folder(s) spreadsheet in.

here's function, updated show name of folder contains spreadsheet, using both services.

enter image description here

function fnctnmenuupdategetlocation() {    var ss = spreadsheetapp.getactivespreadsheet();    var ssid=ss.getid();     var fileindocs = docslist.getfilebyid(ssid);    var folderindocs = fileindocs.getparents()[0].getname();     var fileindrive = driveapp.getfolderbyid(ssid);    var folderindrive = fileindrive.getparents().next().getname();     browser.msgbox("docs says: " + folderindocs +                   ", drive says: " + folderindrive); }

document service's .getparents() method returns array of folder objects, while drive's returns iterator, details of how retrieve specific parent folder(s) once you've got of them differs.

note spreadsheet may "contained" in multiple folders... in case, we've assumed first folder in list 1 - assumption may invalid.


Comments

Post a Comment

Popular posts from this blog

javascript - Count length of each class -

-
i have below code in this fiddle . html <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> javascript $('.myname').each(function(){ var text = $(this).html().split(' '), len = text.length, test = $(this).val().length, result = []; console.log('outside: ' + test); for( var = 0; < len; i++ ) { result[i] = '<span class="name-'+[i]+'" >' + text[i] + '</span>'; console.log('inside: ' + test); } $(this).html(result.join(' ')); console.log('after
Read more

What design pattern is this code in Javascript? -

-
this question has answer here: why write “.call(this)” @ end of javascript anonymous function? [duplicate] 4 answers what kind of design pattern , significance of using closure? (function(){ // code here }).call(this); edit then difference between above code , following this keyword still refer same object in both ways. (function(){ // code here })(); thats invoked function expression. more info here: http://benalman.com/news/2010/11/immediately-invoked-function-expression/ the purpose run code while protecting scope (so variables declared within don't leak out global scope. update call sets value of this function being applied on. without it, value set window object, there set outer scope.
Read more

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -

-
i have have cloudera cdh3u4 cluster setup. have secondarynamenode daemon running on 1 of nodes. i have ensure user has root access node on cluster (for example, datanode not have other daemons running) should not able start instance of secondarynamenode daemon on node (thereby having 2 secondarynamenodes on cluster) how can achieve this? thanks in advance. add property hdfs-site.xml namedfs.secondary.http.address valuesecondarynamenode-host address or ip:50090
Read more