Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as JavaScript by Fevzi ( 7 years ago )
function myFunction(e) {
  //e.values is an array of form values
  var timestamp = e.values[0];
  var contactperson = e.values[1];
  var contactmail = e.values[2];
  var startupname = e.values[3];
  var oneliner = e.values[4];
  var vertical = e.values[5];
  var irmlevel = e.values[6];
  var trllevel = e.values[7];
  var patent = e.values[8];
  var foresight = e.values[9];
  var grantfinancing = e.values[10];
  var targetmarketglobal = e.values[11];
  var targetmarketeu = e.values[12];
  var targetmarketturkey = e.values[13];
  var targetmarket = e.values[14];
  var targetcountry = e.values[15];
  var r1 = e.values[16];
  var r2 = e.values[17];
  var r3 = e.values[18];
  var r4 = e.values[19];
  var r5 = e.values[20];
  var n1 = e.values[21];
  var n2 = e.values[22];
  var n3 = e.values[23];
  var n4 = e.values[24];
  var n5 = e.values[25];
  var f1 = e.values[26];
  var f2 = e.values[27];
  var f3 = e.values[28];
  var f4 = e.values[29];
  var f5 = e.values[30];
  var c1 = e.values[31];
  var c2 = e.values[32];
  var c3 = e.values[33];
  var c4 = e.values[34];
  var c5 = e.values[35];
  var b1 = e.values[36];
  var b2 = e.values[37];
  var b3 = e.values[38];
  var b4 = e.values[39];
  var b5 = e.values[40];
  var round = e.values[41];
  var todate = e.values[42];
  var premoney = e.values[43];
  var fundingneed = e.values[44];
  var equity = e.values[45];
  var shareinvestor = e.values[46];
  var businessconcept = e.values[47];
  var howitworks = e.values[48];
  var competitiveedge = e.values[49];
  var team = e.values[50];
  var opportunity = e.values[51];
  
  //file is the template file, and you get it by ID
  var file = DriveApp.getFileById('1jLnswkdiGUIz79y3UU9-Ptc00VQ8spLimCYTl7HP25k'); 
  
  //We can make a copy of the template, name it, and optionally tell it what folder to live in
  //file.makeCopy will return a Google Drive file object
  var folder = DriveApp.getFolderById('1ipIIDjXK8zUd8tNGZz5AYra5r_6YVzfS')
  var copy = file.makeCopy(startupname + 'One Pager', folder); 
  
  //Once we've got the new file created, we need to open it as a document by using its ID
  var doc = DocumentApp.openById(copy.getId()); 
  
  //Since everything we need to change is in the body, we need to get that
  var body = doc.getBody(); 
  
  //Then we call all of our replaceText methods
  body.replaceText('{{contactperson}}', contactperson);
  body.replaceText('{{contactmail}}', contactmail);
  body.replaceText('{{oneliner}}', oneliner);
  body.replaceText('{{vertical}}', vertical);
  body.replaceText('{{irmlevel}}', irmlevel);
  body.replaceText('{{trllevel}}', trllevel);
  body.replaceText('{{patent}}', patent);
  body.replaceText('{{foresight}}', foresight);
  body.replaceText('{{grantfinancing}}', grantfinancing);
  body.replaceText('{{targetmarketglobal}}', targetmarketglobal);
  body.replaceText('{{targetmarketeu}}', targetmarketeu);
  body.replaceText('{{targetmarketturkey}}', targetmarketturkey);
  body.replaceText('{{targetmarket}}', targetmarket);
  body.replaceText('{{targetcountry}}', targetcountry);
  body.replaceText('{{r1}}', r1);
  body.replaceText('{{r2}}', r2);
  body.replaceText('{{r3}}', r3);
  body.replaceText('{{r4}}', r4);
  body.replaceText('{{r5}}', r5);
  body.replaceText('{{n1}}', n1);
  body.replaceText('{{n2}}', n2);
  body.replaceText('{{n3}}', n3);
  body.replaceText('{{n4}}', n4);
  body.replaceText('{{n5}}', n5);
  body.replaceText('{{f1}}', f1);
  body.replaceText('{{f2}}', f2);
  body.replaceText('{{f3}}', f3);
  body.replaceText('{{f4}}', f4);
  body.replaceText('{{f5}}', f5);
  body.replaceText('{{c1}}', c1);
  body.replaceText('{{c2}}', c2);
  body.replaceText('{{c3}}', c3);
  body.replaceText('{{c4}}', c4);
  body.replaceText('{{c5}}', c5);
  body.replaceText('{{b1}}', b1);
  body.replaceText('{{b2}}', b2);
  body.replaceText('{{b3}}', b3);
  body.replaceText('{{b4}}', b4);
  body.replaceText('{{b5}}', b5);
  body.replaceText('{{round}}', round);
  body.replaceText('{{todate}}', todate);
  body.replaceText('{{premoney}}', premoney);
  body.replaceText('{{fundingneed}}', fundingneed);
  body.replaceText('{{equity}}', equity);
  body.replaceText('{{shareinvestor}}', shareinvestor);
  body.replaceText('{{businessconcept}}', businessconcept);
  body.replaceText('{{howitworks}}', howitworks);
  body.replaceText('{{competitiveedge}}',competitiveedge); 
  body.replaceText('{{team}}', team);
  body.replaceText('{{opportunity}}', opportunity);
   
  //Lastly we save and close the document to persist our changes
  doc.saveAndClose(); 
}

 

Revise this Paste

Your Name: Code Language: