phillypb’s gists

phillypb / 1) Get active spreadsheet user.gs

Last active December 31, 2018 14:05

	function getActiveUser(sheet) {

	// get active Tutor email address
	var user = Session.getActiveUser().getEmail();
	Logger.log('Active Tutor email is: ' + user);

	// get data from Tutors sheet to lookup name from email address
	var tutorsSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Tutors');
	var tutorsSheetData = tutorsSheet.getRange(2, 1, 2, 2).getValues();

phillypb / 2) Get active spreadsheet user.gs

Last active December 31, 2018 14:05

	function testGetActiveUser() {

	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var groupSheet = ss.getSheetByName('Group Feedback');

	// run function to determine if Tutor 1 or 2
	var whoAmI = getActiveUser(groupSheet);
	Logger.log('Value of whoAmI is: ' + whoAmI);

	}

phillypb / Student feedback system - HTML form - part 1.gs

Created December 31, 2018 15:02

	function getValues() {

	var ss = SpreadsheetApp.getActiveSpreadsheet();

	var groupSheet = ss.getSheetByName('Group Feedback');
	var groupSheetName = groupSheet.getSheetName();
	var numCols = groupSheet.getLastColumn();
	var numRows = groupSheet.getLastRow();

	// get 2-D list of 'Student Name'

phillypb / Student feedback system - HTML form - part 2.html

Created December 31, 2018 23:00

	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	<link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">

	<style>
	h1 {
	color:#fff;
	background-color:#006B77;

phillypb / Student feedback system - HTML form - part 3.gs

Created January 1, 2019 18:20

	function writeBack(form) {

	// get the form values
	var currentRow = form.currentRow;
	var whoAmI = form.whoAmI;
	Logger.log('whoAmI from Form is: ' + whoAmI);
	var attendance1 = form.attendance1;
	var contribution1 = form.contribution1;
	var attitude1 = form.attitude1;
	var comments1 = form.comments1;

phillypb / Student Feedback system - send emails.gs

Last active January 2, 2019 20:40

	function onOpen() {

	SpreadsheetApp.getUi()
	.createMenu('Feedback')
	.addItem('Send Student Email', 'sendEmailsConfirm')
	.addToUi();

	}

phillypb / Student Feedback system - create student documents.gs

Created January 3, 2019 19:28

	function createStudentDocs() {

	var ss = SpreadsheetApp.getActiveSpreadsheet();

	ss.toast('Starting to create Student Docs');

	var configSheet = ss.getSheetByName('Config');

	var groupSheet = ss.getSheetByName('Group Feedback');
	var groupNumRows = groupSheet.getLastRow();

phillypb / Convert text from lower case to upper case.gs

Created January 4, 2019 20:10

phillypb / Convert a string into a date format.gs

Last active January 16, 2019 18:28

	function organiseDate() {

	// example date string
	var messyDate = 'Thu Dec 20 2018 13:12:21 GMT-0000 (GMT)';

	// create a new date variable
	var newDate = new Date(messyDate);

	// format the new date variable as required
	var niceDate = Utilities.formatDate(newDate, "GMT", "YYYY_MM_dd");

phillypb / Convert Doc to PDF and move into a new folder.gs

Created January 4, 2019 21:23

	function convertToPDF() {

	// ID of current Google doc
	var docID = '123456789';

	// ID of new folder location
	var folderID = '987654321';

	// create PDF version of doc *************************************************
	var docFile = DriveApp.getFileById(docID);

Phil Bainbridge phillypb