copyDoc.saveAndClose(); Missing ) after argument list Google Sheet Script -
i not not know coding - i'm trying run script below , recieve error missing ) after argument list on line 79 copydoc.saveandclose();
blockquote
here url doc: https://docs.google.com/document/d/1fcbvbhmccdfjcakxsu5ueaod30h1d5ytyqp_s28vpzc/edit?usp=sharing
here script. please advise. sincere thanks.
function myfunction() { // rsaez@shsd.org // travel request // template google docs , name var doctemplate = "1fcbvbhmccdfjcakxsu5ueaod30h1d5ytyqp_s28vpzc"; // *** replace template id *** var docname = "travel_request"; // when form gets submitted function onformsubmit(e) { //get information form , set variables var email_address = "rsaez@shsd.org, rsaez@shsd.org"; var building = e.values[5]; var request = e.values[6]; var total_days = e.values[7]; var substitute_needed = e.values[8]; var staff_member_type = e.values[9]; var coverage_type = e.values[10]; var time_of_day = e.values[11]; var coverage = e.values[12]; var request_type = e.values[13]; var destination = e.values[14]; var purpose = e.values[15]; var city = e.values[16]; var state = e.values[17]; var purpose_is_related_to = e.values[18]; var registration = e.values[19]; var lodging = e.values[20]; var lodging_cost = e.values[21]; var lodging_total = e.values[22]; var meals = e.values[23]; var meals_cost = e.values[24]; var meals_total = e.values[25]; var mileage = e.values[26]; var other = e.values[27]; var travel_cost = e.values[28]; var miscellanous = e.values[29]; // document template, copy new temp doc, , save doc’s id var copyid = docslist.getfilebyid(doctemplate) .makecopy(docname+' '+full_name) .getid(); // open temporary document var copydoc = documentapp.openbyid(copyid); // document’s body section var copybody = copydoc.getactivesection(); // replace place holder keys,in our google doc template copybody.replacetext('keydate', copybody.replacetext('keyname', copybody.replacetext('keyposition', copybody.replacetext('keybuilding', copybody.replacetext('keyrequest', copybody.replacetext('keydayt', copybody.replacetext('keysubstitute', copybody.replacetext('keystaff', copybody.replacetext('keyday', copybody.replacetext('keytime', copybody.replacetext('keycoverage', copybody.replacetext('keyrequest', copybody.replacetext('keydest', copybody.replacetext('keypurpose', copybody.replacetext('keycity', copybody.replacetext('keyst', copybody.replacetext('keypurprelated', copybody.replacetext('keyrt', copybody.replacetext('keylnd', copybody.replacetext('keylcp', copybody.replacetext('keylt', copybody.replacetext('keymnd', copybody.replacetext('keymcp', copybody.replacetext('keymt', copybody.replacetext('keymlt', copybody.replacetext('keyot', copybody.replacetext('keytotalboe', copybody.replacetext('keymisc', // save , close temporary document copydoc.saveandclose(); // copydoc.saveandclose() (options.cand_email); // convert temporary document pdf var pdf = docslist.getfilebyid(copyid).getas("application/pdf" }
your last line,
var pdf = docslist.getfilebyid(copyid).getas("application/pdf"
seems missing ')' @ end. perhaps missing ) after argument list.
Comments
Post a Comment