Google Form to Create an Event in Calendar -
i have created google form our local scout district, notify taking section out , about. working fine notification email. trying automatically create calendar event, later shared through out website management team can view , see of scouts are.
anyway on track, fields have far are:
function calendarsubmit(e){ var group = e.values[1]; var activitydatestart = e.values[2]; var activitytimestart = e.values[3]; var activitydateend = e.values[4]; var activitytimeend = e.values[5]; var activity = e.values[6]; var location = e.values[7]; var description = e.values[8]; var authleader = e.values[9]; var authleaderno = e.values[10]; var authleaderpermit = e.values[11]; var leadercharge = e.values[12]; var leaderchargeno = e.values[13]; var leaderemail = e.values[14] var adults = e.values[15]; var beavers = e.values[16]; var cubs = e.values[17]; var scouts = e.values[18]; var explorers = e.values[19]; var other = e.values[20]; var intouchname = e.values[21]; var intouchcontact = e.values[22]; var manageremail = e.values[23]; var ra = e.values[24]; var rules = e.values[25]; }
i want calendar title use variable title, where
var title = group + " - " + activity;
start , finish times:
var start = activitydatestart + activitytimestart; var end = activitydateend + activitytimeend;
location:
var loc = location
description:
var caldescription = "location of activity: " + activity + " /n" + "description of activity: " + description + " /n/n" + "leader in charge: " + leadercharge + " /n" + "no. of adults (18+): " + adults + " /n" + "no. of beavers: " + beavers + " /n" + "no. of cubs: " + cubs + " /n" + "no. of scouts: " + scouts + " /n" + "no. of explorers/young leaders: " + explorers + " /n" + "no. of non-uniformed young people (under 18): " + other;
the trouble having not sure how script of above calendarapp.
Comments
Post a Comment