fancy sharing template - i'm sorry did you say street magic

	A	E	F	G	I	J	K	M	O	P
1		what does a round look like?			neighbourhood
2		declare a compass			title
3		each player wanders the city: add...			reputation
4			a neighbourhood, or		reputation
5			a landmark, or		true name
6			a resident			landmark
7		the compass holds an event. each player...				title
8	city name (don't rush it)		asks a question, or			address
9			states an opinion, or			true name
10	city adjectives (setting the tone)		shows a consequence				resident
11		take a rest stop					title	pronoun
12		the compass					true name
13		round	player	compass
14	turn order	1
15		2
16		3
17		4
18		5
19		6
20		7
21	event	8
22
23
24
25
26
27
28	event	event
29
30									instructions
31									instructions
32									to use this document, login to your google account and click 'file' → 'make a copy'... to save to your drive. then, give your players edit access. when you want to add new neighbourhoods, landmarks, or residents, click the cell in column i where you want to make your addition. then click the button that matches what you want to add: +neighbourhood, +landmark, or +resident. everything should shuffle down automatically. the first time you click one of the buttons, google will prompt you for permissions. if you trust me, a complete stranger on the internet, click the following things when prompted to enable the code that makes the buttons work: Continue [Choose your Account] Advanced Go to street magic script (unsafe) Allow ...and once you've done that, the sheet should be able to add neighbourhoods, landmarks, and residents automatically, which will save you a few annoying clicks. have fun! if you had a good time, consider picking up a copy of i'm sorry, did you say street magic here:
33
34
35	event	event
36
37
38
39
40
41
42	event	event
43
44
45
46
47
48
49	event	event
50
51
52									https://seaexcursion.itch.io/street-magic
53
54									if you like this sheet, i make stuff like this every couple of months. find me on twitter here:
55
56									@KurtRefling	https://twitter.com/KurtRefling
57
58									help and troubleshooting
59									help and troubleshooting
60									"i get a red error message that says exception: you can't perform a cut/paste from a range that partially intersects a merge. what's going wrong?" the sheet is trying to paste the cells into the wrong spot! do you have a cell in column i selected? when you click the button, your active cell should be the place you want your new neighbourhood, landmark, or resident to appear.
61
62
63
64
65
66									oh no! i clicked the button and it pasted in the wrong place. what should i do? you can erase the mistake by pressing undo twice -- this is because clicking the button is actually doing two things: inserting cells, and copying cells into the new space.
67
68
69
70
71									the buttons seem to be doing nothing. if it's not even prompting you to give it permission, the button might not be assigned to the script anymore. heck. i actually have no idea why this happens, but here's what you need to do: 1. right click on the button that isn't doing anything. 2. click on the ellipsis. 3. click "assign script" in the drop-down menu. 4. depending on which button you're fixing, type the following (no quotes or commas): "AddNeighbourhood", "AddLandmark," or "AddResident".
72
73
74
75
76
77
78
79									these permissions are, uh, scary. RIGHT? jeez louise. if you're feeling a little sketched out, feel free to read over the code -- you can view it under Tools -> Script Editor.
80									my problem isn't here. help? sorry friendo. you can send me a DM at the twitter account above. i shall do my best to help.
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100