database - I have custom code that I need to bold for output. What google sheets script can I use? -
i have created customized work order submission form in forms & sheets auto emails confirmation each submission (job request form) create data trail of vendor activity. integrated , totally cobbled lot of reading in these forums coupled gazillion frustrating moments of trial & error. novice moving towards "capable" im stuck on piece of code triggered confirmation email random work order generator , email confirmations , toggle based management built in. code below need triggered confirmation email sends confirmation of service, work order #, , shows submitted. problem code have providing data how , want , placement great, need create visual distinction between column titles , variable submission data. can please me add bold code column titles in line 16 create visual differentiation between columnar "category , submission data?
// constant written in column c rows email // has been sent successfully. var email_sent = "email_sent"; function sendemails2() { var sheet = spreadsheetapp.getactivesheet(); var startrow = 2; // first row of data process var numrows = 1000; // number of rows process // fetch range of cells a2:b3 var datarange = sheet.getrange(startrow, 1, numrows, 27) // fetch values each row in range. var data = datarange.getvalues(); (var = 0; < data.length; ++i) { var row = data[i]; var emailaddress = row[19]; var message = row[16] + "\n\n" + "submitted by: " + row[19] + "\n\n" + "date submitted: " + row[0] + "\n\n" + row[21] + "\n\n" + "important notes cds: " + row[20] + "\n\n" + "full show services: " + row[3] + "\n\n" + "event start date: " + row[4] + "\n\n" + "event end date: " + row[5] + "\n\n" + "warehouse locations: " + row[6] + "\n\n" + "individual services requested: " + row[7] + "\n\n" + "individual services - warehouse(s) & date(s) requested: " + row[8] + "\n\n" + "partial hourly staffing details requested: " + row[9] + "\n\n" + "requestors instructions / comments: " + row[10] + "\n\n" + "files: " + row[11] + row[12] + "\n\n" + "thank request. appreciate business. cds special events team ";// second columnn var emailsent = row[18]; var subject = row[16];// third columnvar ss = spreadsheetapp.getactivespreadsheet(); if (emailsent != email_sent) { // prevents sending duplicates mailapp.sendemail(emailaddress, subject, message); sheet.getrange(startrow + i, 19).setvalue(email_sent); // make sure cell updated right away in case script interrupted spreadsheetapp.flush(); } } }
Comments
Post a Comment