Adam Morris brainysmurf

A simple Google Document that helps you make tables. Useful for teachers.

You can simply make a copy of this document and follow the instructions.

Manage your daily notices, or bulletin, entirely within your GAFE, no servers or databases required. This is done by creating a Google Form, and then adding the following scripts to the responses sheet that the form populates onto. Optionally create a Google Site to publish the notices.

Workflow:

Users enter into a Google form, and they get picked up and sent to staff either:
- published onto a Google Site
- sent out by email
- both (published onto a site, and then email with link sent out)
Users can enter notices in advance
Users can enter notices for a date range
Have any number of sections ("Whole School", "Secondary", etc.), and notices are collated by those sections

"Blankifier" allows teachers to quickly create a document where every "N" word is replaced with a "blank".

To get started, copy and paste the below into a Google Doc's script editor. Copy and paste text into the document, then click on Blanker -> Blanify

Features:

Decide how many words to skip before deciding to blank
Automatically skips words <= 3 words

	<?xml version="1.0" encoding="UTF-8" ?>
	<Module>
	<ModulePrefs title="hello world example" />
	<Content type="html">
	<![CDATA[
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
	]]>
	</Content>
	</Module>



	/*
	In a google domain, email addresses are (probably?) case insensitive
	Also, return a date object instead with defined formatting
	*/

	function doGet(e) {
	var currentUser = Session.getActiveUser().getEmail().toLowerCase();
	var ssUrl = e.parameter.url;

	var gl = false; // for debugging

	function onOpen() {
	var ui = DocumentApp.getUi();
	ui.createMenu('Actions')
	.addItem('Insert newline every N lines', 'actionEveryNLines')
	.addItem('Make Table', 'actionAppendTable')
	.addSeparator()
	.addItem('Blankify', 'actionBlankify')
	.addItem('Tokenize Sentences', 'actionTokenizeSentences')

	// Exmample of options

	var options = {
	method: "POST",
	contentType : "application/json",
	payload: JSON.stringify({
	secret: 'you will have to ask me',
	awesome_table_filters: {
	first_nickname_last: 'StringFilter',
	parent_email_1: 'StringFilter',

	/*
	There is a bug in the proxy provided by awesometables
	In a google domain, email addresses should case insensitive
	*/

	function doGet(e) {
	var currentUser = Session.getActiveUser().getEmail().toLowerCase();
	var ssUrl = e.parameter.url;
	var sheetName = e.parameter.sheet;
	var a1Notation = e.parameter.range;

	/*

	Use this at your own risk.

	1) Enter the ID of the folder which contains the files you would like to remove and restore edit access
	2) Then running triggerCloseDown will save those editors and remove edit access (and view access) for all editors of that file
	3) Then running triggerOpenUp will lookup editors of each file and restore editing access

	NOTES:

	function main() {
	alert('You are the man!');
	}