{"id":39,"date":"2017-01-03T19:05:39","date_gmt":"2017-01-03T13:35:39","guid":{"rendered":"https:\/\/drgovinddas.wordpress.com\/?page_id=39"},"modified":"2018-06-14T13:57:40","modified_gmt":"2018-06-14T13:57:40","slug":"downloads","status":"publish","type":"page","link":"https:\/\/govinddas.com\/index.php\/downloads\/","title":{"rendered":"Resources"},"content":{"rendered":"

List of my successful experiments in digital world :<\/strong><\/span><\/p>\n

 <\/p>\n

(1)<\/strong> ADOBE CAPTIVATE PROJECTS<\/strong><\/span><\/p>\n

Under construction<\/p>\n

(2)\u00a0<\/strong><\/p>\n

Translate our YouTube videos (required google account login) to help other language speaking community at<\/p>\n

https:\/\/goo.gl\/YrSZqV<\/a><\/p>\n

 <\/p>\n

(3) HOW TO COPY FILES\/FOLDERS NAMES (HUGE) LIST INTO GOOGLE SPREADSHEET<\/strong><\/span><\/p>\n

Enlist names of google drive folder in spreadsheet<\/p>\n

Link code for google script :\u00a0https:\/\/goo.gl\/qjMtj2<\/a><\/p>\n

Code is given below. (replace my drive<\/span> with name of your folder)<\/p>\n

 <\/p>\n

\/\/ replace your-folder below with the folder for which you want a listing
\nfunction listFolderContents() {
\nvar foldername = ‘my drive<\/span>‘;
\nvar folderlisting = ‘listing of folder ‘ + foldername;<\/p>\n

var folders = DriveApp.getFoldersByName(foldername)
\nvar folder = folders.next();
\nvar contents = folder.getFiles();<\/p>\n

var ss = SpreadsheetApp.create(folderlisting);
\nvar sheet = ss.getActiveSheet();
\nsheet.appendRow( [‘name’, ‘link’] );<\/p>\n

var file;
\nvar name;
\nvar link;
\nvar row;
\nwhile(contents.hasNext()) {
\nfile = contents.next();
\nname = file.getName();
\nlink = file.getUrl();
\nsheet.appendRow( [name, link] );
\n}
\n};<\/p>\n

 <\/p>\n

Place this script and allow google drive for permission. You will be able to save them in automatic spreadsheet in google drive parent folder. Example of my drive test (for files list) given below. You can replace circled areas according to your need- i.e. name of folder, and whether you need to enlist files names only or folder names only. (This script doesn’t work on hybrid, i.e. both file and folder names, so arrange them in drive accordingly. And ya, ignore cursor pipe sign preceding parenthesis.;-)<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

****************************<\/p>\n

NEW IDEAS<\/strong><\/span><\/p>\n

In dissertation \/ research studies, in place of filling hard copy of proforma; one can use Google form. This gives following advantages<\/p>\n

1. It directly generates excel sheet
\n2. Investigator doesn’t have to spend separate time for data entry
\n3. It can be operated by mobile.
\n4. No need of carrying hard copies of proforma in field
\n5. Google form itself generates primary analysis of data like percentage, pie chart
\n6. Investigator can anytime view primary analysis during the study up to entry made in form.<\/p>\n

All the types of questions can be generated in google form e.g. date, multiple option type, short text, long text etc.<\/p>\n

 <\/p>\n

**********************************************<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

List of my successful experiments in digital world :   (1) ADOBE CAPTIVATE PROJECTS Under construction (2)\u00a0 Translate our YouTube videos (required google account login) to help other language speaking community at https:\/\/goo.gl\/YrSZqV   (3) HOW TO COPY FILES\/FOLDERS NAMES (HUGE) LIST INTO GOOGLE SPREADSHEET Enlist names of google drive folder in spreadsheet Link code for google script :\u00a0https:\/\/goo.gl\/qjMtj2 Code is given below. (replace my drive with name of your folder)   \/\/ replace your-folder below with the folder for…<\/p>\n

Read More Read More<\/span><\/a><\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":79,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-39","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/pages\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/pages\/39\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/media\/79"}],"wp:attachment":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/media?parent=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}