Google scripts app- variable within variable error

Question

Google drive script for searching- I can't add the variable for searchterm. As soon as I add it I continue to get errors - Perhaps I am going about it wrong?

Ultimately I would like a web app with a searchbox, button that searches for the terms. With the owneris variable...

function SearchFiles() {
//Please enter your search term in the place of Letter
var searchterm ='print';
var searchFor ='title contains "searchterm"';
var owneris ='and "[email protected]" in Owners';
var names =[];
var fileIds=[];
var files = DriveApp.searchFiles(searchFor + owneris);
while (files.hasNext()) {
  var file = files.next();
  var fileId = file.getId();// To get FileId of the file
 fileIds.push(fileId);
 var name = file.getName();
 names.push(name);

}

for (var i=0;i<names.length;i++){
 Logger.log(names[i]);
Logger.log("https://drive.google.com/uc?export=download&id=" + fileIds[i]);

}

}

utphx · Accepted Answer · 2017-01-14 05:35:15Z

2

You just need to add quotes in the right places and it should work:

var searchterm ="'print';
var searchFor ="title contains " + searchterm;
var owneris =" and '[email protected]' in owners";

Be sure to change [email protected]

answered Jan 14, 2017 at 5:35

utphx

1,2651 gold badge8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

OblongMedulla Over a year ago

Great!it worked! Thanks for you help! Now I have to figure out how to get an input text box in google html to populate the searchterm variable. I may need to ask for more help!!

Collectives™ on Stack Overflow

Google scripts app- variable within variable error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related