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