Formulas

Formulas and buttons here power the magic behind the scenes! Keep this section hidden and/or read-only - you shouldn't need to make any changes here.

GamePlayStatement:

⁠@Hannah Rochau ⁠ touched @ENGLAND ⁠ and guessed incorrectly. @ENGLAND ⁠ is @Neutral ⁠ . It is now the @Blue ⁠ team's turn.

⁠

This formula helps navigate the game by stating what's happened during game play.

Who'sTurn:

@Blue

⁠

This formula returns the current team's turn.

PlayerRole:

You are on the team. Wait for the spymaster to give instructions!

⁠

This formula returns the assigned role of the current logged-in user.

Formulas for setting up the board

RandomWord:

IGLOO

⁠

Pulls a random word from the word bank.

Position:

⁠

Pulls a random position to assign the word to.

⁠

Add cards to board

⁠

This button sets up the board for game play.

⁠

Reset the board

⁠

This button clears the currently selected cards and the event log by pushing the three buttons below.

⁠

Wipe board

⁠

Wipe board 2

⁠

Clear event log

⁠

Randomize Teams

⁠

RunActions(ModifyRows([Words in play].Filter([Row ID]=17),[Words in play].[Word Type],If([Words in play].Filter([Row ID]=17).[Word Type]=Red,Blue,Red)),[Words in play].[Press both buttons],AddRow([All events],[Spymaster view].[Date/Time],Now(),[Spymaster view].Event,"created the board.",[Spymaster view].Turn,1,[Spymaster view].User,user(),[Spymaster view].[Team Turn],[Turn Counter].Filter([Goes first?]=true)))

⁠

0

⁠

[ ]

⁠

12345678910111213141516171819202122232425

⁠

21617725244161013238199513214201118221512

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.