google apps script - How do I sum input box values and use the sum as a variable? -

-

in google apps spreadsheet, trying define number of spreadsheet rows want process using input box define start , end rows. need add "1" sum total number of rows want process. math looks like:

(endrow - startrow) + 1 = numrows

the variables want sum startrow , endrow. need add 1 total desired value numrows.

function onopen() {    var ui = spreadsheetapp.getui();    ui.createmenu('run script')        .additem('create certs', 'menuitem1')        .addtoui();  }   //nest createdocument function within menuitem1 function  function menuitem1() {     function createdocument(firstname, lastname, course, date) {  }  //the createdocument function used here (moved line 9)    var sheet = spreadsheetapp.getactivesheet();    //var startrow = browser.inputbox("enter start row");    //var numrows = browser.inputbox("enter number of rows merge");    //var datarange = sheet.getrange(startrow, 1, numrows, 7);    //here add rows scripting starts    var startrow = browser.inputbox("enter start row");    var endrow = browser.inputbox("enter end row");    var numrows =     var datarange = sheet.getrange(startrow, 1, endrow, numrows, 7);      var data = datarange.getvalues();    (var = 0; < data.length; ++i) {      var row = data[i];      var date = row[0];      var nic = row[1];      var course = row[2];      var lastname = row[3];      var firstname = row[4];      var middle = row[5]      var email = row[6];      var docname = lastname+" "+nic+" pme cert";      var subjecttxt = "nwc "+ course +" online pme course certificate";      var fullbody = "pme course completion certificate" + "\n\n";        fullbody += "your " + course + " course completion certificate attached." + "\n\n";        fullbody += "regards," + "\n\n";        fullbody += "professor steve pierce" + "\n";        fullbody += "u.s. naval war college "+ "\n";        fullbody += "online pme program team" + "\n\n";        fullbody += "learn more nwc's online pme program @ link below:" + "\n";        fullbody += "http://www.usnwc.edu/academics/college-of-distance-education/pme-(1).aspx" + "\n";            var docid = driveapp       .getfilebyid("1cjdoldpjmpskkqstpmbk3drznfyurgy5mmsfvhfigz4")       .makecopy(docname).getid();          var doc = documentapp.openbyid(docid);          var body = doc.getactivesection();      body.replacetext('fname', firstname);      body.replacetext('lname', lastname);      body.replacetext('midname', middle);      body.replacetext('course', course);      body.replacetext('date', date);          doc.saveandclose();                  mailapp.sendemail(email, subjecttxt, fullbody, {attachments: doc.getas("application/pdf")});            spreadsheetapp.flush ();      driveapp.getfilebyid(docid).settrashed(true);      //return doc;    }  }


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more