Robin Linacre RobinL

[ Launch: print_template ] e9c894c68af525ebe5e31e72fef74dc5 by RobinL[ Launch: print_template ] 4648a7873c2bc372af8cc4c9782d798a by RobinL[ Launch: test ] 4653053 by enjalot[ Launch: test ] 4652017 by enjalot[ Launch: test ] 4582399 by enjalot

[ Launch: Heatmap ] 9ff47b7e0b42a8e6c437b55663f7e958 by RobinL[ Launch: Enter append etc ] be3851c06371f2b1decabb7268abb562 by RobinL[ Launch: Tributary inlet ] 79e488516a98132cc08b610ac28f482a by RobinL

[ Launch: Enter append etc ] be3851c06371f2b1decabb7268abb562 by RobinL[ Launch: Tributary inlet ] 79e488516a98132cc08b610ac28f482a by RobinL

[ Launch: print_template ] 0a5d43327d5b91282663ac7b715acdbd by RobinL[ Launch: print_template ] 4648a7873c2bc372af8cc4c9782d798a by RobinL[ Launch: test ] 4653053 by enjalot[ Launch: test ] 4652017 by enjalot[ Launch: test ] 4582399 by enjalot

[ Launch: Tributary inlet ] 79e488516a98132cc08b610ac28f482a by RobinL

[ Launch: print_template ] 4648a7873c2bc372af8cc4c9782d798a by RobinL[ Launch: test ] 4653053 by enjalot[ Launch: test ] 4652017 by enjalot[ Launch: test ] 4582399 by enjalot

	function email_and_assign_edit_urls(e) {
	var form = FormApp.getActiveForm();
	var ss = SpreadsheetApp.openById(form.getDestinationId());
	var sheet = ss.getSheets()[0];

	Logger.log(form.getDestinationId())
	var data = sheet.getDataRange().getValues();
	var urlCol = 9; // column number where URL's should be populated; A = 1, B = 2 etc
	var responses = form.getResponses();
	var timestamps = [], urls = [], resultUrls = [];