Rock Paper Airtable

Explore

Rock Paper Airtable

This formula was the Airtable contest winner for April.

ā€‹

For a video demo and some information about myself check out my interview with Built on Air

ā€‹

overview:

This is a playable "Rock Paper Scissors" game against Airtable. The game play is best using a public form view which allows anyone to play regardless if they have an Airtable account.

ā€‹

game definition:

Rockā€“paperā€“scissors (also known as scissorsā€“rockā€“paper or other variants) is a hand game usually played between two people, in which each player simultaneously forms one of three shapes with an outstretched hand. These shapes are "rock" (a closed fist), "paper" (a flat hand), and "scissors" (a fist with the index finger and middle finger extended, forming a V). "Scissors" is identical to the two-fingered V sign (also indicating "victory" or "peace") except that it is pointed horizontally instead of being held upright in the air. A simultaneous, zero-sum game, it has only two possible outcomes: a draw, or a win for one player and a loss for the other.

ā€‹

Credit: Wiki Article

ā€‹

"AI" design:

Airtable's choice is based on a sudo random number generator:

ā€‹

```

IF({Human_Choice},

SWITCH(

MOD(

VALUE(

DATETIME_FORMAT(CREATED_TIME(),'s')

),3

),

0,'šŸ—æ',

1,'šŸ“œ',

2,'āœ‚ļø'

)

)

```

* apologies markdown is not agreeing with indentations

ā€‹

What it's doing is choosing based on the time of record creation. It's clock just happens to only have a seconds hand there is only three. Instead of the clock having numbers they are "Rock, Paper, scissors".

ā€‹

This formula was the Airtable contest winner for April.

ā€‹

interface design:

A Public Form View:

this is a single entry form where the player chooses their move

ā€‹

A Public Block View:

this is a page designer block that always shows the most recent result of a match. It is expected that there is only one human player at a time.

ā€‹

bonus:

* Also included is a separate table "Rock, Paper, Scissors, Lizard, Spock" which is a game created within the show "The Big Bang Theory".

Explore
Updated June 3, 2019 at 4:14 PM
Copied 311 times

Robert DeLanghe

Data dude. Lover of boardgames.
Explore the base
Game results
Game results