Google Apps Scripts for 18xx - Revision history

Rich: /* The Need For Author Identification */

2020-05-03T23:13:51Z

The Need For Author Identification

← Older revision		Revision as of 23:13, 3 May 2020
Line 14:		Line 14:

	==The Need For Author Identification==		==The Need For Author Identification==
	In the last few years a large number od Dream [and dream like] spread sheets have been written.		In the last few years a large number of Dream [and dream like] spread sheets have been written.
	There is now a developing problem in identifying who is responsible for a given sheet. IE: who owns it.<br>		There is now a developing problem in identifying who is responsible for a given sheet. IE: who owns it.<br>
	If a problem is found with a sheet then who should it be reported to?		If a problem is found with a sheet then who should it be reported to?

Rich: /* Introduction */ added The Need For Author Identification

2020-05-03T23:12:54Z

Introduction: added The Need For Author Identification

← Older revision		Revision as of 23:12, 3 May 2020
Line 12:		Line 12:
	[https://docs.google.com/spreadsheets/d/1nNbuODtWgUW-VfAa46xKwPLDBsLPkHPgbtT-9w-_a7g/ here].		[https://docs.google.com/spreadsheets/d/1nNbuODtWgUW-VfAa46xKwPLDBsLPkHPgbtT-9w-_a7g/ here].
	<span style="color: Fuchsia">This article documents the two scripts (functions) used in this spreadsheet.</span>		<span style="color: Fuchsia">This article documents the two scripts (functions) used in this spreadsheet.</span>

			==The Need For Author Identification==
			In the last few years a large number od Dream [and dream like] spread sheets have been written.
			There is now a developing problem in identifying who is responsible for a given sheet. IE: who owns it.<br>
			If a problem is found with a sheet then who should it be reported to?

			To solve this problem, I would like anyone who submits a scripted sheet to be included in my
			spread sheet template folder to comply with this requirement.

			The following header (or something like it) should be put at the start of the script file of all scripted sheets:

			<pre>
			/*
			* @OnlyCurrentDoc
			*
			* This sheet was created by Richard Price [or whomever] on mm/dd/yyyy
			* This sheet was last updated by xxxxx on mm/dd/yyyy [repeat each time the sheet is updated]
			*
			* Copyright (c) yyyy by xxxxxxx under the the MIT License.
			* A copy of this license can be found in the LICENSE.text file.
			*/
			</pre>

			I have created a LICENCE.txt file in the template folder.

	==The newTab function==		==The newTab function==

Rich: Added ==Making Usage Easier==

2018-11-11T17:30:42Z

Added ==Making Usage Easier==

← Older revision		Revision as of 17:30, 11 November 2018
Line 96:		Line 96:
	* Type '''newTab'''		* Type '''newTab'''
	* The button should now cause a new tab to be created.		* The button should now cause a new tab to be created.

			==Making Usage Easier==
			Google has created a very strict authorization requirement for Google Apps Scripts running on Google sheets. See [[18xx Dream Spreadsheet Authorization Issue]] for more information about this. This requirement can be made easier for players to cope with by putting an @OnlyCurrentDoc declaration at the start of the file. This stops the script from doing anything that affects any other documents, and means you get a considerably less scary message when authorizing the script.

			You should add this declaration in a Javascript comment at the start of the script file.
			<pre>
			/**
			* @OnlyCurrentDoc
			*/
			</pre>

Rich: /* The Button */

2017-09-28T20:32:55Z

The Button

← Older revision		Revision as of 20:32, 28 September 2017
Line 92:		Line 92:
	* Close the drawing editor		* Close the drawing editor
	* Size and position the button that now appears on the spreadsheet		* Size and position the button that now appears on the spreadsheet
	* Right-click the button and click the ... that appears on top left corner		* Right-click the button and click on the ... that appears on top left corner
	* From the menu that now appears, select '''Assign script'''		* From the menu that now appears, select '''Assign script'''
	* Type '''newTab'''		* Type '''newTab'''
	* The button should now cause a new tab to be created.		* The button should now cause a new tab to be created.

Rich: /* The Button */ initial contents

2017-09-28T20:23:48Z

The Button: initial contents

← Older revision		Revision as of 20:23, 28 September 2017
Line 83:		Line 83:

	==The Button==		==The Button==
			The '''New Tab''' button that overlays cells A8:B9 is a simple image that is linked to the newTab function. Follow these steps to create this button:
			* In the spreadsheet insert a drawing (Insert->Drawing)
			* In the Drawing editor select Shape->Shapes
			* A box containing 7 rows of different shapes will open
			* Click on the first shape in the fourth column (the Bevil)
			* Use the cursor to draw a bevil shaped like the one in the 18EU sheet
			* Doubleclick on the image to add the "New Tab" text
			* Close the drawing editor
			* Size and position the button that now appears on the spreadsheet
			* Right-click the button and click the ... that appears on top left corner
			* From the menu that now appears, select '''Assign script'''
			* Type '''newTab'''
			* The button should now cause a new tab to be created.

Rich: /* The showPrompt function */ initial contents

2017-09-28T18:27:03Z

The showPrompt function: initial contents

← Older revision		Revision as of 18:27, 28 September 2017
Line 57:		Line 57:
	==The showPrompt function==		==The showPrompt function==

			The showPrompt() function is quite self explanatory. It uses the '''ui''' class to display a request for the name of the new tab. The rest of the code handles the various response types available to the user. Any response other than entering a name and pressing OK will terminate the creation of the new tab.
			<pre>
			function showPrompt() {
			var ui = SpreadsheetApp.getUi();

			var result = ui.prompt(
			'Please enter name of new tab:',
			ui.ButtonSet.OK_CANCEL);

			// Process the user's response.
			var button = result.getSelectedButton();
			var text = result.getResponseText();
			if (button == ui.Button.OK) {
			// User clicked "OK".
			return text;
			} else if (button == ui.Button.CANCEL) {
			// User clicked "Cancel".
			return "";
			} else if (button == ui.Button.CLOSE) {
			// User clicked X in the title bar.
			return "";
			}
			}
			</pre>

	==The Button==		==The Button==

Rich at 17:00, 28 September 2017

2017-09-28T17:00:08Z

← Older revision		Revision as of 17:00, 28 September 2017
Line 10:		Line 10:

	The resultant spreadsheet is		The resultant spreadsheet is
	[https://docs.google.com/spreadsheets/d/~~11o1Pcq16ye6qTiUmw40w5_Juw7cNeyu5BwgiQVQHCrk~~/~~edit~~ here].		[https://docs.google.com/spreadsheets/d/1nNbuODtWgUW-VfAa46xKwPLDBsLPkHPgbtT-9w-_a7g/ here].
	<span style="color: Fuchsia">This article documents the ~~three~~ scripts (functions) used in this spreadsheet.</span>		<span style="color: Fuchsia">This article documents the two scripts (functions) used in this spreadsheet.</span>

	==The newTab function==		==The newTab function==

Rich at 16:56, 28 September 2017

2017-09-28T16:56:53Z

← Older revision		Revision as of 16:56, 28 September 2017
Line 56:		Line 56:

	==The showPrompt function==		==The showPrompt function==


	~~==The shareAdjust function==~~


	==The Button==		==The Button==

Rich: /* The newTab function */ initial contents

2017-09-28T16:55:51Z

The newTab function: initial contents

← Older revision		Revision as of 16:55, 28 September 2017
Line 14:		Line 14:

	==The newTab function==		==The newTab function==
			The newTab() function contains the bulk of the code that actually creates and initializes the new tab. This entire function is included at the end of this section.

			The first thing that this function does is to call the showPrompt() function (see next section) to get the name of the new tab.
			It then creates the new tab, renames it to the name supplied by showPrompt and moves it to the left most spot on the tab bar.
			It then places the name of the previous tab in cell A13.

			Finally it clears the contents of all of the detail cells and the '''for each''' loop adjusts the '''Pool''' cells to include any values in he '''Sold This OR''' cells.
			<pre>
			function newTab() {
			var newTabName = showPrompt();
			if (newTabName == "") {
			return
			}
			var sheet = SpreadsheetApp.getActiveSpreadsheet();
			var curTab = sheet.getActiveSheet();
			var curTabName = curTab.getName();
			var newTab = sheet.duplicateActiveSheet();
			var soldAdjust = [
			["AL9:AL9","AL10:AL10"], ["AN9:AN9","AN10:AN10"],
			["AP9:AP9","AP10:AP10"], ["AR9:AR9","AR10:AR10"],
			["AT9:AT9","AT10:AT10"], ["AV9:AV9","AV10:AV10"],
			["AX9:AX9","AX10:AX10"], ["AZ9:AZ9","AZ10:AZ10"]
			];
			sheet.moveActiveSheet(1);
			sheet.renameActiveSheet(newTabName);
			newTab.getRange("A13:A13").setValue(curTabName);
			newTab.getRange("E20:AJ20").setValue(0);
			newTab.getRange("E22:AJ22").setValue(0);
			newTab.getRange("E24:AJ25").setValue(0);
			newTab.getRange("E28:AJ28").setValue(0);
			newTab.getRange("AK20:AZ28").setValue(0);
			for each (xa in soldAdjust) {
			soldShares = newTab.getRange(xa[0]).getValue();
			poolShares = newTab.getRange(xa[1]).getValue();
			sumShares = soldShares + poolShares;
			newTab.getRange(xa[1]).setValue(sumShares);
			}
			newTab.getRange("AK9:AZ9").setValue(0);
			}
			</pre>

	==The showPrompt function==		==The showPrompt function==

Rich: /* Introduction */

2017-09-25T23:44:35Z

Introduction

← Older revision		Revision as of 23:44, 25 September 2017
Line 2:		Line 2:
	To paraphrase Jonathan Coveney:<br>		To paraphrase Jonathan Coveney:<br>
	The dream spreadsheet for 18xx PBEM would:		The dream spreadsheet for 18xx PBEM would:
	* Cause changes in the past spreadsheet tabs to flow ~~flow~~ to the future tabs.		* Cause changes in the past spreadsheet tabs to flow forward to the future tabs.
	* Create a new tab with one click.		* Create a new tab with one click.